units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where ACCESS_TYP = 2, MNG_AG_TYP = 2 and UNIT_NAME = "City Open Space"
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10204 | 10204 | 10203 | {"type": "MultiPolygon", "coordinates": [[[[-122.1346, 37.06255], [-122.13451, 37.0627], [-122.13429, 37.06276], [-122.13374, 37.06259], [-122.13341, 37.06193], [-122.13294, 37.06186], [-122.13091, 37.06209], [-122.1309, 37.06153], [-122.13169, 37.06153], [-122.1317, 37.06106], [-122.13204, 37.06106], [-122.1321, 37.06072], [-122.13132, 37.06049], [-122.13068, 37.0605], [-122.13014, 37.06066], [-122.12952, 37.06065], [-122.12907, 37.06031], [-122.12856, 37.06022], [-122.12792, 37.06045], [-122.12727, 37.06045], [-122.12681, 37.06035], [-122.12634, 37.05999], [-122.12639, 37.05903], [-122.12629, 37.05849], [-122.12619, 37.05834], [-122.12609, 37.05826], [-122.12591, 37.05819], [-122.1257, 37.05817], [-122.12543, 37.05823], [-122.12522, 37.05822], [-122.12508, 37.05819], [-122.12448, 37.05799], [-122.1244, 37.05325], [-122.13417, 37.05311], [-122.13419, 37.05491], [-122.1341, 37.05949], [-122.13395, 37.05944], [-122.13369, 37.05948], [-122.13361, 37.0596], [-122.13358, 37.05977], [-122.13367, 37.06026], [-122.13366, 37.06066], [-122.1336, 37.06095], [-122.13366, 37.06107], [-122.13367, 37.06118], [-122.1346, 37.06255]]], [[[-122.13411, 37.06163], [-122.1338, 37.06118], [-122.1338, 37.06105], [-122.13374, 37.06093], [-122.1338, 37.06066], [-122.1338, 37.06025], [-122.13372, 37.05976], [-122.13374, 37.05963], [-122.13378, 37.05958], [-122.13394, 37.05956], [-122.1341, 37.05961], [-122.13411, 37.06163]]]]} | Restricted Access 2 | 36504 | City Open Space | 17339 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 171.465 | City OS | 0 | Local Recreation Area 3 | 4 | |
10273 | 10273 | 10272 | {"type": "Polygon", "coordinates": [[[-122.13821, 37.06755], [-122.13322, 37.06753], [-122.13183, 37.06688], [-122.13102, 37.06801], [-122.12911, 37.06708], [-122.12964, 37.06632], [-122.13212, 37.06207], [-122.13294, 37.06197], [-122.13331, 37.06202], [-122.13364, 37.06268], [-122.13429, 37.06288], [-122.13446, 37.06283], [-122.13478, 37.06318], [-122.13482, 37.06364], [-122.13514, 37.06422], [-122.1355, 37.06454], [-122.13589, 37.06459], [-122.13612, 37.06485], [-122.13613, 37.06527], [-122.13632, 37.06576], [-122.13658, 37.0661], [-122.13692, 37.06633], [-122.13711, 37.06668], [-122.13776, 37.06698], [-122.13807, 37.06725], [-122.13821, 37.06755]]]} | Restricted Access 2 | 36628 | City Open Space | 17339 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 68.884 | City OS | 0 | Local Recreation Area 3 | 4 | |
12473 | 12473 | 12472 | {"type": "Polygon", "coordinates": [[[-122.12679, 37.0632], [-122.12622, 37.06347], [-122.12578, 37.06404], [-122.1257, 37.0644], [-122.12562, 37.06438], [-122.12569, 37.06402], [-122.1245, 37.06403], [-122.12448, 37.06146], [-122.12678, 37.06144], [-122.12679, 37.0632]]]} | Restricted Access 2 | 36506 | City Open Space | 17339 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 13.248 | City OS | 0 | Local Recreation Area 3 | 4 | |
13908 | 13908 | 13907 | {"type": "Polygon", "coordinates": [[[-122.12623, 37.05938], [-122.12623, 37.05938], [-122.12447, 37.06105], [-122.12446, 37.05993], [-122.12455, 37.05981], [-122.12461, 37.05968], [-122.12464, 37.05948], [-122.12461, 37.05927], [-122.1245, 37.05908], [-122.1245, 37.05812], [-122.12503, 37.05829], [-122.12519, 37.05833], [-122.12545, 37.05833], [-122.12567, 37.05829], [-122.12578, 37.05828], [-122.12595, 37.05832], [-122.12604, 37.05837], [-122.12611, 37.05845], [-122.12616, 37.05853], [-122.12625, 37.05903], [-122.12623, 37.05938]]]} | Restricted Access 2 | 36507 | City Open Space | 17339 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 7.916 | City 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]);