units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15 rows where ACCESS_TYP = 1, AGNCY_TYP = 2, DES_TP = 2 and YR_EST = 2017
This data as json, copyable, CSV (advanced)
MNG_AGENCY 15
- San Francisco, City and County of 1
- Santa Rosa, City of 1
- San Jose, City of 1
- Glendora, City of 1
- Visalia, City of 1
- San Bernardino, City of 1
- Alameda, City of 1
- Santa Monica, City of 1
- Rancho Cucamonga, City of 1
- Palmdale, City of 1
- Hawthorne, City of 1
- Lomita, City of 1
- Manteca, City of 1
- Rocklin, City of 1
- Desert Hot Springs, City of 1
MNG_AG_TYP 1
- City Agency 15
DES_TP 1
- Local Park · 15 ✖
ACCESS_TYP 1
- Open Access · 15 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1432 | 1432 | 1431 | {"type": "Polygon", "coordinates": [[[-121.88594, 37.31445], [-121.88536, 37.31483], [-121.88518, 37.31455], [-121.88449, 37.31485], [-121.88433, 37.31463], [-121.88552, 37.31397], [-121.88594, 37.31445]]]} | Open Access 1 | 48980 | Tamien Park | 33676 | 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 | https://www.mercurynews.com/2017/06/21/tamien-park-opens-after-22-years-of-planning/ | Santa Clara 19 | 1.588 | Tamien Park | 2017 | Local Park 2 | 4 |
2140 | 2140 | 2139 | {"type": "Polygon", "coordinates": [[[-118.33945, 33.91357], [-118.33843, 33.91357], [-118.33843, 33.91322], [-118.33945, 33.91321], [-118.33945, 33.91357]]]} | Open Access 1 | 6180 | Bicentennial Park | 33375 | 1130 | Hawthorne, City of 299 | City 2 | City Agency 2 | http://www.cityofhawthorne.com/ | City 2 | 1130 | Hawthorne, City of 295 | City 2 | City Agency 2 | Los Angeles 6 | 0.911 | Bicentennial Park | 2017 | Local Park 2 | 4 | |
3297 | 3297 | 3296 | {"type": "Polygon", "coordinates": [[[-119.29982, 36.32794], [-119.29965, 36.32791], [-119.2994, 36.32779], [-119.29924, 36.32763], [-119.29911, 36.32757], [-119.29892, 36.32754], [-119.29892, 36.32746], [-119.29982, 36.32746], [-119.29982, 36.32794]]]} | Open Access 1 | 48209 | Miki City Park | 32749 | 1368 | Visalia, City of 156 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | Tulare 29 | 0.631 | Miki City Park | 2017 | Local Park 2 | 4 | |
3429 | 3429 | 3428 | {"type": "Polygon", "coordinates": [[[-122.28869, 37.78989], [-122.28434, 37.79], [-122.28434, 37.78999], [-122.2844, 37.78926], [-122.28472, 37.78911], [-122.28521, 37.78928], [-122.28707, 37.78929], [-122.28729, 37.78923], [-122.28753, 37.78908], [-122.28867, 37.78906], [-122.28869, 37.78989]]]} | Open Access 1 | 48739 | Estuary Park | 33465 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | https://www.alamedaca.gov/Departments/Recreation-Parks/Estuary-Park | Alameda 17 | 7.72 | Estuary Park | 2017 | Local Park 2 | 4 |
3671 | 3671 | 3670 | {"type": "Polygon", "coordinates": [[[-122.72799, 38.42185], [-122.72623, 38.4222], [-122.72621, 38.422], [-122.72615, 38.42201], [-122.72601, 38.42086], [-122.7278, 38.42042], [-122.72799, 38.42185]]]} | Open Access 1 | 29698 | Bayer Neighborhood Park and Gardens | 32509 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 6.16 | Bayer Neighborhood Park and Gardens | 2017 | Local Park 2 | 4 | |
6753 | 6753 | 6752 | {"type": "Polygon", "coordinates": [[[-121.21194, 37.76483], [-121.21187, 37.76508], [-121.21159, 37.76557], [-121.21149, 37.76586], [-121.21144, 37.76588], [-121.21108, 37.76588], [-121.21081, 37.76585], [-121.21064, 37.76579], [-121.21042, 37.76566], [-121.2103, 37.76555], [-121.21018, 37.76536], [-121.21014, 37.76514], [-121.21014, 37.76454], [-121.21015, 37.7644], [-121.21024, 37.7642], [-121.21033, 37.76408], [-121.21046, 37.76397], [-121.2106, 37.76389], [-121.21085, 37.76381], [-121.21153, 37.76374], [-121.21157, 37.76377], [-121.21178, 37.76409], [-121.21187, 37.76427], [-121.21194, 37.76455], [-121.21194, 37.76483]]]} | Open Access 1 | 48417 | Evans Estates Park | 33014 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 7.541 | Evans Estates Park | 2017 | Local Park 2 | 4 | |
10073 | 10073 | 10072 | {"type": "Polygon", "coordinates": [[[-121.28222, 38.81572], [-121.28171, 38.81595], [-121.28168, 38.81588], [-121.28158, 38.8158], [-121.28132, 38.81542], [-121.28105, 38.81507], [-121.28097, 38.81499], [-121.28084, 38.81488], [-121.2808, 38.81481], [-121.28072, 38.81477], [-121.28065, 38.81477], [-121.28057, 38.81481], [-121.28053, 38.81488], [-121.28047, 38.81488], [-121.28041, 38.8148], [-121.28124, 38.81442], [-121.28222, 38.81572]]]} | Open Access 1 | 49035 | Wickman Park | 33742 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 2.226 | Wickman Park | 2017 | Local Park 2 | 4 | |
11232 | 11232 | 11231 | {"type": "Polygon", "coordinates": [[[-118.46481, 34.02853], [-118.4639, 34.02872], [-118.46352, 34.02864], [-118.46131, 34.02909], [-118.46102, 34.02931], [-118.46054, 34.02941], [-118.46045, 34.02911], [-118.46466, 34.02825], [-118.46471, 34.02825], [-118.46473, 34.02828], [-118.46481, 34.02853]]]} | Open Access 1 | 48030 | Ishihara Park | 32517 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | https://www.smgov.net/Departments/CCS/content.aspx?id=53687098200 | Los Angeles 6 | 2.358 | Ishihara Park | 2017 | Local Park 2 | 4 |
11435 | 11435 | 11434 | {"type": "Polygon", "coordinates": [[[-117.8668, 34.11468], [-117.86563, 34.11468], [-117.86563, 34.11404], [-117.86679, 34.11404], [-117.8668, 34.11468]]]} | Open Access 1 | 48128 | Arboretum And Botanic Garden | 32644 | 1120 | Glendora, City of 76 | City 2 | City Agency 2 | http://www.ci.glendora.ca.us/departments-services/parks-recreation-senior-services | City 2 | 1120 | Glendora, City of 74 | City 2 | City Agency 2 | Los Angeles 6 | 1.867 | Arboretum And Botanic Garden | 2017 | Local Park 2 | 4 | |
11440 | 11440 | 11439 | {"type": "Polygon", "coordinates": [[[-118.31128, 33.78746], [-118.31096, 33.78747], [-118.31095, 33.78696], [-118.31128, 33.78696], [-118.31128, 33.78746]]]} | Open Access 1 | 48135 | Louis and William J. Teuchert Park | 32662 | 1182 | Lomita, City of 461 | City 2 | City Agency 2 | http://www.lomita.com/cityhall/government/parksrec/index.cfm | City 2 | 1182 | Lomita, City of 454 | City 2 | City Agency 2 | http://www.lomita.com/cityhall/government/parksrec/index.cfm?p=Teuchert/Teuchert.cfm&h=m | Los Angeles 6 | 0.42 | Louis and William J. Teuchert Park | 2017 | Local Park 2 | 4 |
13055 | 13055 | 13054 | {"type": "Polygon", "coordinates": [[[-116.46046, 33.95158], [-116.4604, 33.95167], [-116.45955, 33.95175], [-116.45948, 33.95163], [-116.45951, 33.95157], [-116.45952, 33.9515], [-116.4595, 33.95145], [-116.45946, 33.95142], [-116.45931, 33.95138], [-116.45924, 33.95117], [-116.45937, 33.95129], [-116.45982, 33.9515], [-116.46046, 33.95158]]]} | Open Access 1 | 34912 | Rotary Dog Park | 32625 | 1670 | Desert Hot Springs, City of 641 | City 2 | City Agency 2 | http://www.cityofdhs.org/ | City 2 | 1670 | Desert Hot Springs, City of 630 | City 2 | City Agency 2 | Riverside 10 | 0.555 | Rotary Dog Park | 2017 | Local Park 2 | 4 | |
14691 | 14691 | 14690 | {"type": "Polygon", "coordinates": [[[-122.41621, 37.76434], [-122.41587, 37.76436], [-122.41587, 37.76447], [-122.41537, 37.7645], [-122.41531, 37.76377], [-122.41615, 37.76372], [-122.41621, 37.76434]]]} | Open Access 1 | 45018 | In Chan Kaajal Park | 31768 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/project/proposed-park-site-at-17th-and-folsom/ | San Francisco 13 | 1.398 | In Chan Kaajal Park | 2017 | Local Park 2 | 4 |
14692 | 14692 | 14691 | {"type": "Polygon", "coordinates": [[[-117.29529, 34.11701], [-117.2948, 34.11701], [-117.29479, 34.11703], [-117.2943, 34.11703], [-117.2943, 34.11635], [-117.29453, 34.11634], [-117.29454, 34.11612], [-117.29467, 34.11611], [-117.29467, 34.11591], [-117.29529, 34.1159], [-117.29529, 34.11701]]]} | Open Access 1 | 45039 | Bryce Edward Hanes Park | 31758 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 2.45 | Bryce Edward Hanes Park | 2017 | Local Park 2 | 4 | |
14728 | 14728 | 14727 | {"type": "Polygon", "coordinates": [[[-117.61755, 34.09674], [-117.61753, 34.09759], [-117.61599, 34.09759], [-117.61599, 34.09673], [-117.61755, 34.09674]]]} | Open Access 1 | 45080 | Los Amigos Park | 32565 | 1263 | Rancho Cucamonga, City of 196 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parkdev/whatsnew/southwest_cucamonga_pk.asp | San Bernardino 22 | 3.359 | Los Amigos Park | 2017 | Local Park 2 | 4 |
15206 | 15206 | 15205 | {"type": "Polygon", "coordinates": [[[-118.04141, 34.55562], [-118.04139, 34.55792], [-118.03668, 34.55791], [-118.03664, 34.55789], [-118.03665, 34.55766], [-118.03669, 34.5572], [-118.03669, 34.55572], [-118.03703, 34.55572], [-118.03704, 34.55582], [-118.03989, 34.55581], [-118.04119, 34.55562], [-118.04141, 34.55562]]]} | Open Access 1 | 46092 | Sam Yellen Community Park | 29441 | 1242 | Palmdale, City of 205 | City 2 | City Agency 2 | http://www.cityofpalmdale.org/Residents/Recreation-and-Culture | City 2 | 1242 | Palmdale, City of 201 | City 2 | City Agency 2 | Los Angeles 6 | 25.456 | Sam Yellen Community Park | 2017 | 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]);