ICON

Help - Edit a dataset

Help Center Spotzi Studio Draw a map

Edit a dataset

5 MIN BEGINNER EDIT A DATASET, DELETE ROW, ADD ROW, ADD MAP FEATURE, DELETE COLUMN, ADD COLUMN


Add a row to a dataset

Spotzi allows you to add a row to a dataset. Keep in mind that, when you add a row with a geometry, you in fact add a feature to your map. In this example we will create an extra row with the coordinates of the Coliseum Park (latitude = 40.76900427024065, longitude = -73.98427784442903). To create a new row you have to take the following steps:

Add a New Row to a Dataset

1. Go to MY DATA and view the dataset to which you want to add an extra row.

Add a New Row to a Dataset

2. Your table will open up. To add a row press the ADD ROW button in the right corner  at the bottom.

Add a New Row to a Dataset

3. An empty row will be created. To add the name of our location (Coliseum Park) and its coordinates to the new row click into the respective cells. A typing window will appear. Click SAVE after every change you made.

Add a New Row to a Dataset

4. When you are done, go back to your map. You can see that the row (map feature) has been added to your map.

Add a New Row to a Dataset

Delete a row of a dataset

Spotzi allows you to delete a rows of a dataset. Keep in mind that every row represents a map feature if it contains a geometry. So if you delete a row, you may delete a map feature (point, line or polygon). To delete a row you have to take the following steps:

1. Go to MY DATA and view the dataset of which you want to delete a row.

Delete a Row from a Dataset

2. Your table will open. To delete a row press the small arrow button in front of the row. A drop down menu with the options to delete the row appears. Click DELETE THIS ROW.

Delete a Row from a Dataset

3. Confirm that you want to delete the row.

Delete a Row from a Dataset

4. After the confirmation you have successfully deleted your row.

Delete a Row from a Dataset

Quick tip! Export your data before deleting a row
Before you delete a row, always make sure you made a backup of your data. Deleting rows is permanent so make sure you exported the data before you delete any rows whatsoever.

Add a column to a dataset

Spotzi allows you to add a column to a dataset. Keep in mind that every column is a field. In this example we will create an additional column with the phone number of the Sheraton Hotel in Times Square (+1 212-581-1000). As you can see we only have a name field, a description field and an imageurl field. To create a new column (or a new field) you have to take the following steps:

Add a Column to a Dataset

1. Go to MY DATA and view the dataset to which you want to add an additional column.

Add a Column to a Dataset

2. Your table will open. To add an additional column press the ADD COLUMN button in the bottom right corner.

Add a Column to a Dataset

3. An empty column will be created. Give the column a name and press SAVE to confirm.

Add a Column to a Dataset

4. Add the phone number by double clicking the appropriate cell. A type screen will pop up. Here you can type the phone number of the Sheraton Hotel. Click SAVE.

Add a Column to a Dataset

5. Go back to your map. You will see that there are extra fields to select from when you want to edit the infowindow. That means you have successfully created a column.

Add a Column to a Dataset

Quick tip! Mind the data types.
Do you want to add an extra column that you can use to style your data? Keep in mind that every styling option (range, category or custom) needs a certain data type. For example, range and custom styling need a field of type number, while category styling is based on a field of type string.

Delete a column of a dataset

Spotzi allows you to delete a column of a dataset. Keep in mind that every column is a field of a map feature. So if you for example want to delete a column with information about the postal code, the map connected to this dataset will not depict postal codes anymore . To delete a column you have to follow the steps outlined below:

1. Go to MY DATA and view the dataset of which you want to delete a column.

Delete a Dataset Column

2. Your table will open. To delete a column press the small arrow button next to the column title. A drop down menu will appear. Click DELETE THIS COLUMN.

Delete a Dataset Column

3. Confirm that you want to delete the column.

Delete a Dataset Column

4. After confirming you have successfully deleted your column.

Delete a Dataset Column

Related blog posts

Interested in our solutions? Please contact our sales team.

Whether you are new to data analytics or already an expert. We offer solutions for everyone. You don’t need to be a data expert to work with Spotzi Location. For more tailor made solutions we offer Spotzi Studio. With this plan you cannot only manage the data yourself but also connect to our API and manage users for the dashboards you create. Or work with our Market Ready Dashboards and drive on autopilot.