Once you have added observations and sites to your sketch, you can export the content to a variety of formats.
Generating exports
Click the Menu button at the top right corner of the screen
Click Export
Check the content you would like to export, and select the format: CSV, PDF, DOCX*, or JPEG
*For DOCX files, we recommend viewing the content in Google Docs for best results.
Understanding your exports
Observations CSV exports will include the following columns:
Column | Definition |
Sketch Name | The name of the sketch |
Description | The contents of the observation |
Latitude | The latitude coordinate of the story |
Latitude | The longitude coordinate of the story |
Datetime Submitted (UTC) | The datetime the story was created |
Sites CSV exports will include the following columns:
Column | Definition |
Site Name | The name of the site |
Name | The user-entered name of the site |
Creator | The user-entered creator of the site |
Description | The user-entered description of the site |
Remedies | A comma-delineated list of remedies in the site |
Footprint (sqft) | The total area of the site |
Roof Cover (sqft) | The area of roof cover on the site |
Land Cover: [Category] | The percentage area of the site for each land cover category (see link) |
Land Use: [Category] | The percentage area of the site for each land use category (see link) |
Land Ownership | A comma-delineated list of parcel owners (see link) |
Coordinates | The latitude and longitude of the center point of the site |
Census Tract | A comma-delineated list of census tracts overlapping the site (see link) |
Disadvantaged Community? | Whether the site overlaps or is within a 1/3-mile walkshed of a CalEnviroScreen-designated Disadvantaged Community (see link) |
Neighborhood | A comma-delineated list of neighborhoods overlapping the site (see link) |
Municipality | A comma-delineated list of municipalities overlapping the site (see link) |
Supervisorial District | A comma-delineated list of supervisorial districts overlapping the site (see link) |
SCWP Watershed Area | A comma-delineated list of SCWP watershed areas overlapping the site (see link) |
Watershed | A comma-delineated list of hydrologic watersheds overlapping the site (see link) |
Historic Habitat | A comma-delineated list of historic habitats overlapping the site (see link) |
Tribal Area | A comma-delineated list of tribal areas overlapping the site (see link) |
Heat (extreme heat days in an average year) | The average annual extreme heat days for overlapping census tracts (see link ) |
Flooding (flood days in an average year) | The average annual flood days for overlapping census tracts (see link) |
Fire (acres burned in an average year) | The average annual acres burned for overlapping census tracts (see link) |
Air Pollution (percentile for traffic impact) | The statewide percentile for traffic impacts for overlapping census tracts (see link) |
Water Pollution (percentile for drinking water contaminants) | The statewide percentile for drinking water contaminants for overlapping census tracts (see link) |
Soil Pollution (percentile for clean-up sites) | The statewide percentile for cleanup sites for overlapping census tracts (see link) |
Income (median household income) | The median household income for overlapping census tracts (see link) |
CalEnviroScreen (percentile for CalEnviroScreen score) | The CalEnviroScreen score for overlapping census tracts (see link ) |
Social Sensitivity (third for social sensitivity index) | The social sensitivity tier for overlapping census tracts (see link) |
Roof Rainfall: Average Year (gallons) | The average annual rainfall over roofs on the site |
Roof Rainfall: 85th Percentile Storm (gallons) | The amount of rainfall over roofs during an 85th-percentile storm |
Site Rainfall: Average Year (gallons) | The average annual rainfall over the site |
Site Rainfall: 85th Percentile Storm (gallons) | The amount of rainfall over the site during an 85th-percentile storm |
Offsite Runoff: Average Year (gallons) | The average annual rainfall funneling to the highest-volume location within a 250-ft radius of the site for stormwater diversion |
Offsite Runoff: 85th Percentile Storm (gallons) | The amount rainfall funneling to the highest-volume location within a 250-ft radius of the site for stormwater diversion during an 85th-percentile storm |
Offsite Runoff Contribution Area: Total (acres) | The area funneling water to the highest-volume location within a 250-ft radius of the site for stormwater diversion |
Offsite Runoff Contribution Area: Impervious (acres) | The impervious area funneling water to the highest-volume location within a 250-ft radius of the site for stormwater diversion |
Offsite Runoff Contribution Area: Pervious (acres) | The pervious area funneling water to the highest-volume location within a 250-ft radius of the site for stormwater diversion |
Infiltration (in/hr) | For sites above a groundwater basin, the rate of infiltration for overlying soils |
Transit Stops (bus and rail stops) | The number of bus and rail stops within a 1/3-mile walkshed of the site (see link) |
Bikeways (share stations) | The number of bike share stations within a 1/3-mile walkshed of the site (see link) |
Storm Drains (inlets) | The number of storm drain inlets within a 1/3-mile walkshed of the site (see link) |
Community Spaces | The number of community spaces within a 1/3-mile walkshed of the site (see link) |
Parks | The number of parks within a 1/3-mile walkshed of the site |
Existing Projects | The number of existing infrastructure projects within a 1/3-mile walkshed of the site (see link) |
Datetime Created (UTC) | The datetime the sketch was created |