Learn how to utilize the CSV bulk import feature for measurements, a powerful tool that streamlines the process of importing large point datasets into your portal for easier spatial data visualization and analysis, eliminating manual entry.
Before you begin your CSV import, consider creating a custom point template to ensure all your imported points are styled according to your specific preferences right from the start. Defining a template beforehand allows you to control aspects such as color, icon style, and label visibility, guaranteeing a consistent visual representation of your data upon import. While creating your own custom template offers maximum control over your point aesthetics, you also have the option to utilize one of the predefined options in the Properties panel.
Importing Point Data from CSV
Click the UPLOAD button, and choose Measurements.
A window will open. Drag and drop or navigate to the CSV file you want to import.
Upon uploading your CSV, the system will display a preview of the first few rows of your data. From the Select measurement template dropdown, you can choose from several options. If you created a custom template earlier in the CSV upload process, you will also see that template listed as an available option within this dropdown.
Next, connect the columns in your CSV file to the matching fields from your template.
If your CSV file includes a header row in the very first line, click the Use first row as header checkbox.
Available fields
Point Name, Easting, and Northing are mandatory for import. If your template includes a text field labeled 'Description,' the data in that field will be displayed. The 'Custom Description' field will always appear, but is optional for import.
Point Name: Choose the CSV column that contains a unique identifier or name for each point. This allows for easy identification and referencing of individual measurements.
Easting: Select the column that holds the easting coordinate values for your points. Ensure that the units in your CSV are consistent with your project's coordinate system.
Northing: Map this to the CSV column containing the northing coordinate values. Again, verify unit consistency.
Description: This field allows you to import textual information associated with each point.
Custom description: Use this field to map additional columns in your CSV file that you want to display. If you’ve assigned a header row, custom descriptions will take on the title specified in the header.
Ignore: For any columns in your CSV file that do not represent relevant measurement data you wish to import, simply select the "Ignore" option from the dropdown menu. This ensures that these columns are skipped during the import process.
With all relevant CSV columns mapped to template fields, click FINISH. This will process your data, and a new folder will be generated and named after the original CSV file. These points will be visible on the map by default. To hide them, simply toggle off the eye icon associated with the newly created folder.
PROPERTIES
Click on any of the points on the map to open the information provided in your original CSV file. When you map CSV columns with a Description, it will display the text content from your mapped columns, allowing you to modify this information as needed.
Click the +ADD/EDIT ITEMS at the bottom of the PROPERTIES panel to edit any of the properties associated with your points.
Select the custom items you want to include with your custom measurement and drag them to the left side of the window. You can also make changes to any of the column header fields in this window.
STYLE
To visually differentiate your imported points on the map, click the STYLE button. This will open a panel of predefined color swatches, allowing you to change the point marker's color. You can also select from a set of predefined icons, allowing you to represent different types of measurements with distinct visual symbols. You can also toggle to display a label next to each point on the map.
The CSV bulk import feature streamlines various workflows by allowing the direct import of point data, eliminating manual data entry, and simplifying the integration of spatial data.
I still can't do it!
We wrote these articles to equip you with everything you need to get the job done on your own, but we understand that sometimes this isn't sufficient.
If you're stuck, you can connect with our support team by clicking the support button on the top right corner of your user portal.
Related to