This article will overview how to add data that can be used for both the Sheet Viewer, and Data Browser.
Getting set up
- First, you want to go to NJDOT Web Straight Line Diagrams
- Once you are in the site, you will need to sign into your account. If you do not have an account you will need to get that set up.
- Click on this Icon to get to the sing in window
- Once in the sign in window type in your username and passwords
- You will know the login was successful when you see your username appear in place of the log in logo
- Click on this Icon to get to the sing in window
Importing Data file
- Click the drop down next to your username and select "Custom Data Sources"
- Once this page loads you will see all data that you have previously loaded
- You will see all information that is available about the data source
- Click "Create New" in the upper right hand corner to start your new data source
- Step 1 of Import: choosing your file
- Supported file types are Excel (*.xls, *.xlsx), Access (*.mdb, *.accdb), and Text (*.csv, *.txt)
- There are 4 things that you need in your file. SRI, Milepost Start, Milepost End, and Value
- Once you are sure you have everything you need in your file, click "Create New Custom Data Source"
- Browse to where your file is located on your computer
- The name field will be filled by the file name
- Fill in the description field and click upload
- This upload could take some time, give it a minute to complete
- Step 2 of Import: Mapping Table
- Once your table is selected and uploaded you have to map the columns
- Go through each column and make sure that the correct table field is being paired up with the correct data field
- For example, "Milepost Start Column' should match your "MP_START" field
- You will know that your table has been created successfully when you get this pop up. This will give you a message saying the process is completed and if there are any errors with the data imported
- close out of the pop out and you will see your upload in your list of data sources
This data is now available in the NJDOT Web SLD data sites