Creating a New Table from Scratch
When you turn on a layer in Sitewise, the data shown on the map is stored in a table. These tables store data for points and polygons. This includes but not limited to store locations, customer spotting, franchise territories and store trade areas. Check out the Tables vs Layers article to learn more!
In Sitewise you can also create an empty table for new data that you would like to track! By creating tables this way, you will unlock the ability to track data by simply adding records from within the platform itself without needing to upload a separate file. If you do have a data file that you want to import into Sitewise then, please refer to the Uploading Tables guide!
This guide will walk you through how to create this table from scratch, set the geometry type, column data types and other standard field settings to prepare the data for display! If you would like to follow along with the instructions, feel free to watch the training video at the bottom of the article. Once you’ve mastered tables then, you can easily manage and edit your organization’s data within the Platform!
Table Creation
- Navigate and click on the gear icon in the top right corner of the Sitewise platform.
- Select settings window them click on the Tables tab.
- To create a new table, click on the plus icon, at the top right of the window.
- The Add Table window will appear!
- Give your new table a meaningful name. This will make its easy to find in the list of tables or when adding the table to your map set!
- Choose if others in your organization can make edits to the table by selecting or deselecting the “allow edits” button.
- The “Shared” parameter has a few options. Click the “shared” checkbox to allow others in your organization to view the table.
- You can set which data you would like to store under the “Layer Type”
- You can define the fields you want to see in your table under “Column Definitions”. In each column, you can set the name, data type and maximum column character length/size.
- Click on the plus icon at the top to add a new field. A blank column will appear, you can name it according to what the values in the field will represent.
- Data Type: You have many options for selecting the data type: text, integer, float and date.
- Once you are satisfied with your new table settings, click Save.
- After the window closes, you will now be able to see your new table in the Tables tab
Note: If you only want select groups in your organization to have access to the data, then you can edit the share settings after the table is created. Note: To create a table that contains shapes, such as a trade area table – choose “polygon”. Note: It is best practice to use float for any numeric field and text for all others, including date. You also do not need to know every field you need and can keep the default address fields. Though we recommend planning out the table as much as possible beforehand!We've included a video that demonstrates the steps outlined above - giving you a visual walkthrough if you would like to follow along for a more hands-on experience!
Check out this guide to add the table you had created to a mapset as a layer. You can start working with the layer right away! Please refer to our Working with Point and Polygon Data article to learn more. If you have any further questions, please contact our Support Team, we would be happy to help!
Related Articles
Styling Your Data
At Sitewise, we understand the importance of visualizing data for better analysis and insights. That’s why we’ve made it simple to add your data and customize its styling for a seamless mapping experience. This article will walk you through all the ...Uploading Tables
The article will review the different ways to upload and add your data to a table in Sitewise. If you do not have a data file ready to upload but would like to still track information in the platform, take a look at the Creating a New Table from ...Table Settings
Table settings in Sitewise allow you to manage key aspects about how a table and its data are used and controlled. This includes everything from setting who can access the table, to setting what table information is displayed when added as a layer to ...Data Fit
The Data Fit feature in Sitewise lets you size your study area according to a desired value for a particular variable. For example, you can use Data Fit to create a circle that is big enough to capture a population of 20,000 people. How to create a ...Link Geography to a Table
At Sitewise, we understand that proper data visualization is essential for site analysis and effective future planning. You can link your uploaded file to a standard geographic boundary within Sitewise, enabling you to display your data as a thematic ...