units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where ACCESS_TYP = 1, MNG_AG_TYP = 2 and YR_EST = 1968
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_NAME
These facets timed out: MNG_AGENCY
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2347 | 2347 | 2346 | {"type": "Polygon", "coordinates": [[[-122.16402, 37.44949], [-122.16354, 37.44998], [-122.16245, 37.44929], [-122.16293, 37.4488], [-122.16402, 37.44949]]]} | Open Access 1 | 17102 | Johnson Park | 20478 | 1243 | Palo Alto, City of 161 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | Santa Clara 19 | 2.092 | Johnson Park | 1968 | Local Park 2 | 4 | |
2589 | 2589 | 2588 | {"type": "Polygon", "coordinates": [[[-121.99104, 37.31833], [-121.99006, 37.31807], [-121.98956, 37.31796], [-121.98887, 37.31783], [-121.98886, 37.31751], [-121.9889, 37.31748], [-121.98891, 37.31744], [-121.98887, 37.3173], [-121.98888, 37.31598], [-121.9893, 37.31588], [-121.9898, 37.31567], [-121.98985, 37.31569], [-121.9901, 37.31583], [-121.99032, 37.3159], [-121.99056, 37.31593], [-121.99093, 37.31593], [-121.99095, 37.31829], [-121.99104, 37.3183], [-121.99104, 37.31833]]]} | Open Access 1 | 17931 | Mise | 22290 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 10.988 | Mise | 1968 | None 213 | ||
7355 | 7355 | 7354 | {"type": "Polygon", "coordinates": [[[-118.10496, 33.76788], [-118.10478, 33.76807], [-118.10463, 33.76829], [-118.10453, 33.76851], [-118.10446, 33.76881], [-118.10442, 33.76956], [-118.1044, 33.77172], [-118.10433, 33.77169], [-118.10426, 33.7717], [-118.1042, 33.77174], [-118.10417, 33.77181], [-118.1042, 33.77187], [-118.10426, 33.77192], [-118.10435, 33.77192], [-118.10441, 33.77189], [-118.1044, 33.77411], [-118.10409, 33.77412], [-118.10408, 33.77402], [-118.10409, 33.76939], [-118.10411, 33.76887], [-118.10418, 33.76857], [-118.1043, 33.76826], [-118.10441, 33.76807], [-118.10453, 33.7679], [-118.10471, 33.76769], [-118.10488, 33.76753], [-118.10488, 33.76751], [-118.10482, 33.76748], [-118.10486, 33.76746], [-118.105, 33.76749], [-118.10504, 33.76752], [-118.10503, 33.76755], [-118.10488, 33.7677], [-118.10487, 33.76774], [-118.10488, 33.76781], [-118.10496, 33.76788]]]} | Open Access 1 | 6680 | Channel View Park | 17123 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 5.302 | Channel View Park | 1968 | Local Park 2 | 4 | |
8792 | 8792 | 8791 | {"type": "Polygon", "coordinates": [[[-122.3999, 37.58571], [-122.39987, 37.58599], [-122.3996, 37.58686], [-122.39943, 37.58705], [-122.39939, 37.58702], [-122.39902, 37.58728], [-122.39888, 37.58699], [-122.39867, 37.58671], [-122.39849, 37.58655], [-122.39799, 37.58618], [-122.39778, 37.58598], [-122.39862, 37.58586], [-122.39976, 37.58546], [-122.3999, 37.58571]]]} | Open Access 1 | 14303 | Mills Estates Park | 32592 | 1205 | Millbrae, City of 404 | City 2 | City Agency 2 | http://www.ci.millbrae.ca.us/ | City 2 | 1205 | Millbrae, City of 398 | City 2 | City Agency 2 | https://www.ci.millbrae.ca.us/departments-services/public-works/parks-division/mills-estates-park | San Mateo 15 | 4.612 | Mills Estates Park | 1968 | Local Park 2 | 4 |
8881 | 8881 | 8880 | {"type": "Polygon", "coordinates": [[[-121.94013, 37.28614], [-121.93949, 37.28697], [-121.93833, 37.28699], [-121.93878, 37.28638], [-121.93884, 37.28638], [-121.93913, 37.28596], [-121.93937, 37.28575], [-121.93964, 37.28558], [-121.93985, 37.2855], [-121.93957, 37.28586], [-121.94013, 37.28614]]]} | Open Access 1 | 14509 | Campbell Park | 16779 | 1043 | Campbell, City of 448 | City 2 | City Agency 2 | http://www.ci.campbell.ca.us/226/Recreation-Parks | City 2 | 1043 | Campbell, City of 442 | City 2 | City Agency 2 | Santa Clara 19 | 3.04 | Campbell Park | 1968 | Local Park 2 | 4 | |
8921 | 8921 | 8920 | {"type": "Polygon", "coordinates": [[[-122.03638, 37.25821], [-122.03593, 37.25874], [-122.03597, 37.25918], [-122.03594, 37.25923], [-122.03589, 37.25925], [-122.03554, 37.25925], [-122.03493, 37.25809], [-122.03453, 37.25824], [-122.03448, 37.25815], [-122.03424, 37.25825], [-122.03421, 37.25833], [-122.03411, 37.25826], [-122.03489, 37.25761], [-122.03528, 37.2575], [-122.03535, 37.25755], [-122.03534, 37.25757], [-122.03535, 37.25758], [-122.03543, 37.25755], [-122.03563, 37.25759], [-122.03569, 37.25752], [-122.03636, 37.25777], [-122.03625, 37.25777], [-122.03609, 37.25782], [-122.0361, 37.25788], [-122.0362, 37.25811], [-122.03638, 37.25821]]]} | Open Access 1 | 14636 | Wildwood Park | 27522 | 1326 | Saratoga, City of 520 | City 2 | City Agency 2 | http://www.saratoga.ca.us/cityhall/pw/parks/default.asp | City 2 | 1326 | Saratoga, City of 513 | City 2 | City Agency 2 | Santa Clara 19 | 4.484 | Wildwood Park | 1968 | Local Park 2 | 4 | |
9422 | 9422 | 9421 | {"type": "Polygon", "coordinates": [[[-121.96948, 37.42504], [-121.96911, 37.42631], [-121.96897, 37.42625], [-121.96621, 37.4255], [-121.96617, 37.42548], [-121.96616, 37.42544], [-121.96616, 37.42534], [-121.96674, 37.42526], [-121.9667, 37.42508], [-121.96711, 37.42501], [-121.96722, 37.42537], [-121.96863, 37.42514], [-121.96837, 37.42417], [-121.96898, 37.42432], [-121.96891, 37.42471], [-121.96948, 37.42504]]]} | Open Access 1 | 15752 | Alviso Park | 15432 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 6.581 | Alviso Park | 1968 | Local Park 2 | 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]);