units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 1, DES_TP = 3 and MNG_AGENCY = 96
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, DES_TP
MNG_AG_TYP 1
ACCESS_TYP 1
- Open Access · 2 ✖
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4105 | 4105 | 4104 | {"type": "Polygon", "coordinates": [[[-122.33426, 37.52088], [-122.33353, 37.52137], [-122.33341, 37.52122], [-122.33305, 37.52137], [-122.33302, 37.52132], [-122.33338, 37.52116], [-122.33334, 37.52099], [-122.33315, 37.52069], [-122.33336, 37.5206], [-122.33307, 37.52029], [-122.33287, 37.51998], [-122.33303, 37.51991], [-122.33426, 37.52088]]]} | Open Access 1 | 47228 | Timberland Open Space | 30936 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 1.894 | Timberland OS | 0 | Local Recreation Area 3 | 4 | |
15993 | 15993 | 15992 | {"type": "Polygon", "coordinates": [[[-122.29376, 37.57208], [-122.29375, 37.5721], [-122.29368, 37.57216], [-122.29354, 37.57217], [-122.29315, 37.57217], [-122.29283, 37.57201], [-122.29283, 37.57196], [-122.29274, 37.57193], [-122.29272, 37.5719], [-122.29252, 37.57204], [-122.29247, 37.5721], [-122.29245, 37.57219], [-122.29245, 37.57227], [-122.29249, 37.57238], [-122.29247, 37.57244], [-122.2924, 37.57248], [-122.29229, 37.57248], [-122.29218, 37.57251], [-122.29215, 37.57255], [-122.29214, 37.57261], [-122.29216, 37.57276], [-122.29209, 37.57288], [-122.29195, 37.57302], [-122.29189, 37.57315], [-122.2919, 37.57329], [-122.29219, 37.57352], [-122.29226, 37.57353], [-122.29231, 37.57357], [-122.29233, 37.57364], [-122.29229, 37.57372], [-122.29217, 37.57387], [-122.29196, 37.57404], [-122.29188, 37.57416], [-122.2918, 37.57434], [-122.29169, 37.57447], [-122.29148, 37.57462], [-122.29127, 37.57475], [-122.29105, 37.57486], [-122.29093, 37.57488], [-122.28789, 37.5746], [-122.28789, 37.57075], [-122.28998, 37.57076], [-122.29112, 37.57112], [-122.29202, 37.57144], [-122.29283, 37.57162], [-122.29327, 37.57176], [-122.29349, 37.57185], [-122.2937, 37.57196], [-122.29375, 37.57201], [-122.29376, 37.57208]]]} | Open Access 1 | 47230 | Bay Marshes Open Space | 30938 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 40.282 | Bay Marshes OS | 0 | Local Recreation Area 3 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);