"properties": {
"shape_area": "0.0007823067885",
"objectid": "1",
"shape_leng": "0.116357453189",
"location_id": "1",
"zone": "Newark Airport",
"borough": "EWR"
}
At this point, you have created a new, empty data set. It does not contain any data yet, nor knows the platform anything about the pick-up locations yet.
First, you will define which of the properties of the .geojson
file are relevant:
The platform must know which property represents the ID of each pick-up location.
That way, when it encounters the same ID in the .csv
file with the time-varying data, it knows to which pick-up location that taxi trip belongs.
You need to indicate if you want additional properties to be available for analysis.
by clicking on the Configure GeoJSON Properties button in the navigation bar
Let us first have a look which properties are available in the GeoJSON file that you have downloaded before.
The properties of a single location look like:
"properties": {
"shape_area": "0.0007823067885",
"objectid": "1",
"shape_leng": "0.116357453189",
"location_id": "1",
"zone": "Newark Airport",
"borough": "EWR"
}
For this tutorial, you will use the following properties:
The location_id: this is the identifier of the area, and is required.
The zone, borough and shape_area properties can be interesting to include. It would for example allow you to restrict the data to the EWR borough only.
Auto-detect the available properties
When you don’t know which properties are present in your file, you can also upload the file to inspect and select which properties you want to include. See this article for more information. |
Now that you know which property represents the location id, you can provide this info to the platform. This tutorial uses the wizard for this.
Right now, the wizard contains the single required property (but since it is not provided, it is marked as invalid):
The identifier: each pick-up location has an id associated with it.
This id is used in each row of the .csv
files to refer to that location.
The platform needs to know which of the properties in the .geojson
file represents that identifier.
The wizard has context-sensitive help messages
The info box on the right-hand side of the wizard contains some additional information. This information updates based on the property you are currently editing. |
If you stopped here, you won’t have access to the additional properties of each pick-up location during analysis. But most likely, you will want to make some additional properties available.
For this tutorial, you can for example add the zone and borough.
For each of these properties, you need to specify:
The name of the property in the .geojson
file
The display name: this display name is a human-readable string for the property that will be shown in the platform.
The type of the property value: the values of a property can be strings, numbers, booleans .
More details about the type of the column available
If you are unsure what the data type for your column is, consult the help on the right-hand side of the wizard. We also have an additional article with more guidance available. |
Press the ADD PROPERTY button at the bottom of the wizard, and fill in the details for this new property.
In this case, the display name can be the same as the name as "borough" is perfectly suited to show to a user.
The type of this property is an enumeration, as there are only a limited number of boroughs.
Press the ADD PROPERTY button at the bottom of the wizard, and fill in the details for this new property.
In this case, you are going to change the display name. The "zone" property represents the name of the pick-up location, hence it makes more sense to call this property "location name" in the UI.
Additionally, you also indicate that the value of this property should be used as display name for the pick-up locations. You can do this at the bottom of the configuration by assigning the special meaning "Display name for the areas".
By default, when the platform lists the available areas defined in the GeoJSON file, it shows the ID of each area. In this case, that ID is meaningless to a user as it is just a number. By marking this property as the display name for the areas, the platform will show this name instead of the id.
As there is only a limited set of zones, choose enum
as data type.
This for example allows to create a filter to "only show the data from the Newark Airport area" instead of having to use "only show the data from the 1 area".
Now that you have filled in all the properties you want to have available for analysis, you still have to press the save button at the bottom of the wizard to save this configuration.
After you have saved the configuration, a table showing the properties of your data will appear underneath the wizard:
At this point, it is still possible to change the properties.
For example, if you realize you made a mistake, you can still correct it.
Once you start uploading your .geojson
file, it is no longer possible to make changes to the data structure.
Other ways of defining your data
In this tutorial we used the wizard to define the structure of the data.
You can also define this in a separate file (in This is explained in more detail here. |
Go to the next part: Step 3: Upload the geojson file