units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
19 rows where ACCESS_TYP = 1, DES_TP = 2 and LABEL_NAME = "Civic Ctr. Park"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
MNG_AGENCY 19
- Newport Beach, City of 1
- Garden Grove, City of 1
- Costa Mesa, City of 1
- Vista, City of 1
- Davis, City of 1
- San Marcos, City of 1
- Fairfield, City of 1
- Sanger, City of 1
- Livermore, City of 1
- Apple Valley Recreation and Park District 1
- Palos Verdes Estates, City of 1
- Benicia, City of 1
- Hanford, City of 1
- Newark, City of 1
- Santa Clara, City of 1
- Sunnyvale, City of 1
- West Side Recreation and Park District 1
- Lemon Grove, City of 1
- Bradbury, City of 1
DES_TP 1
- Local Park · 19 ✖
ACCESS_TYP 1
- Open Access · 19 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1431 | 1431 | 1430 | {"type": "Polygon", "coordinates": [[[-119.64751, 36.3284], [-119.64751, 36.32857], [-119.6471, 36.32857], [-119.64708, 36.32947], [-119.64617, 36.32947], [-119.64618, 36.32839], [-119.64751, 36.3284]]]} | Open Access 1 | 9161 | Civic Center Park | 17358 | 1129 | Hanford, City of 349 | City 2 | City Agency 2 | http://www.ci.hanford.ca.us/depts/rec/default.asp | City 2 | 1129 | Hanford, City of 346 | City 2 | City Agency 2 | Kings 44 | 2.62 | Civic Ctr. Park | 0 | Local Park 2 | 4 | |
5963 | 5963 | 5962 | {"type": "Polygon", "coordinates": [[[-119.5626, 36.70623], [-119.56221, 36.70623], [-119.56221, 36.70595], [-119.5626, 36.70595], [-119.5626, 36.70623]]]} | Open Access 1 | 48245 | Civic Center Park | 32800 | 1315 | Sanger, City of 231 | City 2 | City Agency 2 | http://www.ci.sanger.ca.us/parks-rec.asp | City 2 | 1315 | Sanger, City of 227 | City 2 | City Agency 2 | Fresno 9 | 0.261 | Civic Ctr. Park | 0 | Local Park 2 | 4 | |
6321 | 6321 | 6320 | {"type": "MultiPolygon", "coordinates": [[[[-117.87072, 33.61203], [-117.86969, 33.61297], [-117.86943, 33.61322], [-117.8692, 33.61349], [-117.86893, 33.61389], [-117.86882, 33.6139], [-117.86845, 33.61374], [-117.86875, 33.61344], [-117.86902, 33.61312], [-117.86938, 33.61262], [-117.86949, 33.61244], [-117.86946, 33.61223], [-117.8698, 33.61162], [-117.86988, 33.6116], [-117.87012, 33.61165], [-117.87035, 33.61172], [-117.87057, 33.61181], [-117.87059, 33.61194], [-117.87072, 33.61203]], [[-117.86977, 33.61244], [-117.86973, 33.61238], [-117.8696, 33.61245], [-117.86957, 33.6125], [-117.86957, 33.61257], [-117.86951, 33.6127], [-117.86945, 33.61277], [-117.86927, 33.61293], [-117.86916, 33.6131], [-117.86909, 33.61318], [-117.86899, 33.61325], [-117.86895, 33.61331], [-117.86896, 33.61336], [-117.86901, 33.61339], [-117.86907, 33.61336], [-117.86915, 33.61328], [-117.86918, 33.6132], [-117.86932, 33.61303], [-117.86936, 33.61299], [-117.86956, 33.61288], [-117.86967, 33.61278], [-117.86973, 33.61271], [-117.86975, 33.61264], [-117.86977, 33.61252], [-117.86979, 33.61245], [-117.86977, 33.61244]]], [[[-117.87349, 33.60827], [-117.87244, 33.60984], [-117.87214, 33.61027], [-117.87164, 33.61089], [-117.87109, 33.61149], [-117.87106, 33.61148], [-117.87097, 33.61156], [-117.87087, 33.61158], [-117.87063, 33.61147], [-117.87025, 33.61134], [-117.87021, 33.61125], [-117.87084, 33.6101], [-117.87188, 33.60836], [-117.87236, 33.60747], [-117.87279, 33.60778], [-117.87277, 33.60781], [-117.87299, 33.60797], [-117.87303, 33.60794], [-117.87349, 33.60827]]]]} | Open Access 1 | 47412 | Civic Center Park | 31128 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 16.286 | Civic Ctr. Park | 0 | Local Park 2 | 4 | |
7992 | 7992 | 7991 | {"type": "Polygon", "coordinates": [[[-122.1561, 38.05304], [-122.15563, 38.05378], [-122.15414, 38.05302], [-122.15466, 38.05235], [-122.1561, 38.05304]]]} | Open Access 1 | 10886 | Civic Center Park | 17352 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 3.335 | Civic Ctr. Park | 0 | Local Park 2 | 4 | |
8717 | 8717 | 8716 | {"type": "Polygon", "coordinates": [[[-121.95423, 37.35323], [-121.95394, 37.35323], [-121.95366, 37.35326], [-121.95353, 37.35304], [-121.95364, 37.35294], [-121.95358, 37.35256], [-121.95439, 37.35255], [-121.95447, 37.35257], [-121.95476, 37.35308], [-121.95477, 37.35316], [-121.95473, 37.35322], [-121.95465, 37.35326], [-121.95423, 37.35323]]]} | Open Access 1 | 14149 | Civic Center Park | 17364 | 1318 | Santa Clara, City of 401 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | Santa Clara 19 | 1.735 | Civic Ctr. Park | 1954 | Local Park 2 | 4 | |
8829 | 8829 | 8828 | {"type": "Polygon", "coordinates": [[[-119.44907, 35.14063], [-119.44765, 35.14064], [-119.44764, 35.13981], [-119.44907, 35.1398], [-119.44907, 35.14063]]]} | Open Access 1 | 14406 | Civic Center Park | 17367 | 2178 | West Side Recreation and Park District 467 | Special District 4 | Recreation/Parks District 4 | http://www.wsrpd.com/ | Special District 4 | 2178 | West Side Recreation and Park District 460 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 2.953 | Civic Ctr. Park | 0 | Local Park 2 | 4 | |
9090 | 9090 | 9089 | {"type": "Polygon", "coordinates": [[[-122.03847, 37.37063], [-122.03889, 37.37071], [-122.03904, 37.37077], [-122.03911, 37.37084], [-122.03916, 37.37091], [-122.03923, 37.37111], [-122.03922, 37.37115], [-122.03918, 37.37118], [-122.03881, 37.37126], [-122.03784, 37.37171], [-122.03757, 37.37178], [-122.03729, 37.3718], [-122.03711, 37.37179], [-122.0364, 37.37164], [-122.03635, 37.37161], [-122.03635, 37.37158], [-122.03678, 37.37032], [-122.03682, 37.37029], [-122.03687, 37.37028], [-122.0375, 37.37042], [-122.03739, 37.37074], [-122.03752, 37.37084], [-122.03831, 37.37101], [-122.03833, 37.37101], [-122.03847, 37.37091], [-122.03849, 37.37077], [-122.03847, 37.37063]]]} | Open Access 1 | 15052 | Civic Center Park | 17365 | 1345 | Sunnyvale, City of 419 | City 2 | City Agency 2 | http://sunnyvale.ca.gov/Departments/CommunityServices/Parks.aspx | City 2 | 1345 | Sunnyvale, City of 413 | City 2 | City Agency 2 | Santa Clara 19 | 5.83 | Civic Ctr. Park | 1961 | Local Park 2 | 4 | |
11861 | 11861 | 11860 | {"type": "Polygon", "coordinates": [[[-117.21516, 34.52544], [-117.2149, 34.52567], [-117.21459, 34.52587], [-117.21431, 34.52599], [-117.21392, 34.52613], [-117.21357, 34.5263], [-117.21326, 34.52651], [-117.21302, 34.52673], [-117.21227, 34.52624], [-117.2121, 34.52604], [-117.21002, 34.52408], [-117.21079, 34.52352], [-117.21273, 34.5235], [-117.21274, 34.52388], [-117.21516, 34.52544]]]} | Open Access 1 | 24298 | Civic Center Park | 17368 | 2200 | Apple Valley Recreation and Park District 267 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 21.171 | Civic Ctr. Park | 0 | Local Park 2 | 4 | ||
11969 | 11969 | 11968 | {"type": "Polygon", "coordinates": [[[-117.90689, 33.6632], [-117.90688, 33.66376], [-117.90604, 33.66374], [-117.90486, 33.66375], [-117.90486, 33.66326], [-117.90643, 33.66326], [-117.90644, 33.6632], [-117.90689, 33.6632]]]} | Open Access 1 | 24587 | Civic Center Park | 17353 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | Orange 3 | 2.585 | Civic Ctr. Park | 0 | Local Park 2 | 4 | |
12453 | 12453 | 12452 | {"type": "Polygon", "coordinates": [[[-117.03207, 32.73998], [-117.03207, 32.74041], [-117.03161, 32.74041], [-117.03162, 32.74024], [-117.03164, 32.74023], [-117.03165, 32.73992], [-117.03127, 32.73991], [-117.03127, 32.73983], [-117.03125, 32.73982], [-117.03126, 32.73967], [-117.03193, 32.73967], [-117.03194, 32.73962], [-117.03207, 32.73962], [-117.03207, 32.73998]]]} | Open Access 1 | 28090 | Civic Center Park | 17359 | 1173 | Lemon Grove, City of 597 | City 2 | City Agency 2 | http://www.lemongrove.ca.gov/departments/community-services/parks-197 | City 2 | 1173 | Lemon Grove, City of 587 | City 2 | City Agency 2 | http://www.lemongrove.ca.gov/Home/Components/FacilityDirectory/FacilityDirectory/36/71 | San Diego 4 | 1.083 | Civic Ctr. Park | 0 | Local Park 2 | 4 |
12975 | 12975 | 12974 | {"type": "MultiPolygon", "coordinates": [[[[-117.93816, 33.77732], [-117.93814, 33.77739], [-117.93761, 33.77765], [-117.9374, 33.77772], [-117.93719, 33.77775], [-117.93704, 33.77775], [-117.93705, 33.77751], [-117.93734, 33.77751], [-117.93735, 33.77746], [-117.93758, 33.77745], [-117.93759, 33.77739], [-117.93763, 33.77738], [-117.93763, 33.77715], [-117.93606, 33.77714], [-117.93517, 33.7771], [-117.93515, 33.77735], [-117.93443, 33.77735], [-117.93442, 33.77689], [-117.93713, 33.7769], [-117.93713, 33.77649], [-117.93698, 33.77648], [-117.93697, 33.77616], [-117.93771, 33.77615], [-117.93776, 33.77619], [-117.93781, 33.7765], [-117.93788, 33.77674], [-117.93798, 33.777], [-117.93816, 33.77732]]], [[[-117.93857, 33.77784], [-117.93824, 33.77785], [-117.93772, 33.77786], [-117.93827, 33.77759], [-117.93834, 33.7776], [-117.93857, 33.77784]]]]} | Open Access 1 | 30453 | Civic Center Park | 17357 | 1116 | Garden Grove, City of 62 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | Orange 3 | 5.195 | Civic Ctr. Park | 0 | Local Park 2 | 4 | |
15300 | 15300 | 15299 | {"type": "Polygon", "coordinates": [[[-117.96999, 34.14575], [-117.9696, 34.14575], [-117.96915, 34.14556], [-117.96899, 34.14555], [-117.96898, 34.14547], [-117.96986, 34.1455], [-117.96996, 34.14548], [-117.96999, 34.14575]]]} | Open Access 1 | 46439 | Civic Center Park | 32522 | 1712 | Bradbury, City of 1150 | City 2 | City Agency 2 | http://cityofbradbury.org/ | City 2 | 1712 | Bradbury, City of 1097 | City 2 | City Agency 2 | Los Angeles 6 | 0.468 | Civic Ctr. Park | 0 | Local Park 2 | 4 | |
15423 | 15423 | 15422 | {"type": "Polygon", "coordinates": [[[-118.39101, 33.80004], [-118.39054, 33.80008], [-118.39043, 33.7999], [-118.39078, 33.79977], [-118.39097, 33.79972], [-118.39101, 33.80004]]]} | Open Access 1 | 46648 | Civic Center Park | 29938 | 1244 | Palos Verdes Estates, City of 293 | City 2 | City Agency 2 | http://www.pvestates.org/ | City 2 | 1244 | Palos Verdes Estates, City of 289 | City 2 | City Agency 2 | Los Angeles 6 | 0.361 | Civic Ctr. Park | 0 | Local Park 2 | 4 | |
16980 | 16980 | 16979 | {"type": "Polygon", "coordinates": [[[-121.74766, 38.54637], [-121.74766, 38.54705], [-121.74714, 38.54705], [-121.74712, 38.54786], [-121.74715, 38.54787], [-121.74714, 38.54863], [-121.74764, 38.54864], [-121.74764, 38.54923], [-121.74653, 38.54925], [-121.74642, 38.54856], [-121.74605, 38.54859], [-121.74588, 38.54762], [-121.74559, 38.54661], [-121.7456, 38.54661], [-121.74561, 38.54647], [-121.74565, 38.54641], [-121.74597, 38.54636], [-121.74766, 38.54637]]]} | Open Access 1 | 21021 | Civic Center Park | 17355 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 9.582 | Civic Ctr. Park | 0 | Local Park 2 | 4 | |
17021 | 17021 | 17020 | {"type": "Polygon", "coordinates": [[[-122.03031, 37.53412], [-122.02993, 37.53459], [-122.02988, 37.5346], [-122.02984, 37.53453], [-122.02977, 37.53448], [-122.02963, 37.53446], [-122.0295, 37.5345], [-122.02943, 37.53457], [-122.02943, 37.5346], [-122.02944, 37.53463], [-122.0294, 37.53463], [-122.02782, 37.53381], [-122.02842, 37.5331], [-122.02931, 37.53356], [-122.02929, 37.5336], [-122.03031, 37.53412]]]} | Open Access 1 | 12812 | Civic Center Park | 17361 | 1221 | Newark, City of 377 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | Alameda 17 | 4.39 | Civic Ctr. Park | 1973 | Local Park 2 | 4 | |
17023 | 17023 | 17022 | {"type": "Polygon", "coordinates": [[[-117.23516, 33.20398], [-117.2347, 33.20423], [-117.23438, 33.20391], [-117.23431, 33.20367], [-117.23415, 33.20336], [-117.23382, 33.20317], [-117.23319, 33.20309], [-117.23308, 33.20329], [-117.23293, 33.20312], [-117.23259, 33.20288], [-117.2323, 33.20278], [-117.23192, 33.20276], [-117.2321, 33.20221], [-117.23237, 33.20244], [-117.23319, 33.20271], [-117.2334, 33.20269], [-117.23376, 33.20281], [-117.23402, 33.20279], [-117.23406, 33.20295], [-117.2342, 33.20294], [-117.23423, 33.20304], [-117.23436, 33.20302], [-117.23441, 33.20304], [-117.23458, 33.20312], [-117.2347, 33.20322], [-117.23465, 33.20338], [-117.23464, 33.20356], [-117.23466, 33.20364], [-117.23471, 33.20374], [-117.23483, 33.2037], [-117.23486, 33.20375], [-117.235, 33.20369], [-117.23516, 33.20398]]]} | Open Access 1 | 12927 | Civic Center Park | 17366 | 1369 | Vista, City of 159 | City 2 | City Agency 2 | http://www.cityofvista.com/departments/parks/parks_and_facilities.cfm | City 2 | 1369 | Vista, City of 155 | City 2 | City Agency 2 | http://www.cityofvista.com/services/parks-and-facilities | San Diego 4 | 3.873 | Civic Ctr. Park | 0 | Local Park 2 | 4 |
17025 | 17025 | 17024 | {"type": "Polygon", "coordinates": [[[-121.75428, 37.67606], [-121.75112, 37.67601], [-121.75112, 37.67523], [-121.75124, 37.67524], [-121.75125, 37.67523], [-121.75128, 37.67397], [-121.75353, 37.67399], [-121.75398, 37.67351], [-121.75428, 37.67606]]]} | Open Access 1 | 12996 | Civic Center Park | 17360 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 14.935 | Civic Ctr. Park | 0 | Local Park 2 | 4 | |
17037 | 17037 | 17036 | {"type": "Polygon", "coordinates": [[[-122.049, 38.2523], [-122.04898, 38.25324], [-122.04829, 38.25323], [-122.04829, 38.25341], [-122.04822, 38.25341], [-122.04799, 38.2534], [-122.04772, 38.25335], [-122.04706, 38.25312], [-122.04688, 38.25309], [-122.04657, 38.25308], [-122.04598, 38.25321], [-122.04557, 38.25337], [-122.04533, 38.25348], [-122.04532, 38.25288], [-122.04554, 38.25289], [-122.04567, 38.25287], [-122.04568, 38.25245], [-122.04566, 38.25234], [-122.04575, 38.25233], [-122.04575, 38.25227], [-122.04584, 38.25215], [-122.04589, 38.25212], [-122.04666, 38.25213], [-122.0467, 38.2522], [-122.0473, 38.25219], [-122.04727, 38.25226], [-122.04764, 38.25227], [-122.04806, 38.25237], [-122.04832, 38.2524], [-122.04853, 38.25236], [-122.04867, 38.2523], [-122.04873, 38.25226], [-122.04875, 38.25228], [-122.049, 38.2523]]]} | Open Access 1 | 28312 | Civic Center Park | 17356 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | Solano 26 | 8.233 | Civic Ctr. Park | 0 | Local Park 2 | 4 | |
17045 | 17045 | 17044 | {"type": "Polygon", "coordinates": [[[-117.15886, 33.14153], [-117.15831, 33.14154], [-117.1577, 33.14159], [-117.15768, 33.14153], [-117.1584, 33.14106], [-117.15849, 33.1412], [-117.15861, 33.14133], [-117.15886, 33.14153]]]} | Open Access 1 | 45970 | Civic Center Park | 29119 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/150/1081 | San Diego 4 | 0.729 | Civic Ctr. Park | 0 | 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]);