Atlas: Bulk CSV Export

1. Go to atlas.density.io

2. In the top right corner, select Export CSV. A box with the options for your download will appear.

3. Time Range: To update these settings, click on the date range, operating hours, and days of the week shown in the area with the grey background. A calendar will pop up. 

4. Time Resolution: Select between 1 day, 1 hour, 30-minute, or 15-minute time frames. The occupancy will show the average and the peak for the selected amount of time.

5. Spaces: Select between the space, floor, full building, or portfolio level of reporting. You will receive a zip file containing each level selected in its own file.

7. Include Floor and Building Occupancy Summary: This field is required to show Entry sensor data but can be used for all sensors. This will add the following reports:

• Building level
• Floor level
• Space, floor, building level

8. The ZIP file will include (based on your CSV settings selection):

• Labels: A list of the space IDs and associated labels
  
  
• Spaces: Space metadata, time used percentage and minutes, average occupancy, and average density.
  
  
• Building level: Occupancy average and peak for the building
  
  
• Floor level: Occupancy average and peak for the floors
  
  
• Space, floor, building level: Space metadata, time used percentage and minutes, average and peak occupancy, and average density.
  
  

9. For portfolio-level reporting, please note that there is not a separate portfolio CSV. The download will include:

• Labels
• Spaces (your selected floors will be included and shown in a separate column)
• Building Level
• Floor Level (your selected floors will be included and shown in a separate column)

Columns:

• ORGANIZATION_NAME and ORGANIZATION_ID: The organization ID is needed for API queries. The organization name allows you to check that this is the correct location. 
• SPACE_ID and SPACE_NAME: Space ID is needed for certain API queries. Space name allows you to check that this is the correct location. You can also filter your report by space if you have pulled a location with multiple spaces. 
• FLOOR_NAME and FLOOR_ID: Floor ID is needed for certain API queries. The floor name allows you to check that this is the correct location. If you have pulled a location with multiple floors, you can also filter your report by floor. 
• BUILDING_NAME and BUILDING_ID: Building ID is needed for certain API queries. Building name allows you to check that this is the correct location. If you have pulled a location with multiple buildings, you can also filter your report by building. 
• IWMS_ID: This is used if you have synced your data into an IWMS to ensure that the spaces match what is in the application.
• AREA_SQFT: This is the size of the space according to the input in Atlas
• CAPACITY: The maximum number of people in the space, according to the input in Atlas
• FUNCTION: The type of space, e.g., meeting room, phone booth, desk, etc.  
• COST_PER_SQFT: The cost of the space, according to the input in Atlas
• LOCAL_DATE_TIME: The time of the data pulled, adjusted for the timezone of the space
• COUNTING_MODE: The type of sensor data, e.g., Entry, Open Area, or Waffle 
• TIME_USED_PERCENT and TIME_USED_MINUTES: The percentage/minutes the space was occupied, during the time range pulled (e.g., 15 minutes, 1 hour, etc.)
• AVG_OCCUPANCY_WHEN_USED: The average occupancy of the space during the time range pulled (e.g., 15 minutes, 1 hour, etc.)
• ENTRANCES and EXITS: The raw count of entrances and exits during the time range pulled (e.g., 15 minutes, 1 hour, etc.)

Key Notes

• The Atlas file has identifiers for spaces, floors, and buildings, which can be used to track data precisely.
• You may see blank columns based on the sensors installed in your space. This is expected - if you only have Waffle sensors, for example, the Entrances and Exits columns will be blank.