units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10,524 rows where MNG_AG_TYP = 2 sorted by PARK_URL descending
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
DES_TP >30
- Local Park 7,486
- Local Recreation Area 1,440
- Local Other or Unknown 663
- Local Conservation Area 143
- Local Historic or Cultural Area 37
- Local Resource Management Area 6
- National Monument or Landmark 5
- None 1
- None 1
- National Forest 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
ACCESS_TYP 4
- Open Access 9,925
- Restricted Access 363
- No Public Access 207
- Unknown Access 29
MNG_AG_TYP 1
- City Agency · 10,524 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3110 | 3110 | 3109 | {"type": "Polygon", "coordinates": [[[-118.368, 34.09588], [-118.36753, 34.09588], [-118.36753, 34.09577], [-118.36799, 34.09577], [-118.368, 34.09588]]]} | Open Access 1 | 47991 | Havenhurst Park | 32412 | 6103 | Private Landowner 584 | Private 7 | Other 25 | Private 14 | 1375 | West Hollywood, City of 331 | City 2 | City Agency 2 | https://www.weho.org/Home/Components/FacilityDirectory/FacilityDirectory/19/773 | Los Angeles 6 | 0.129 | Havenhurst Park | 0 | Local Park 2 | 4 | |
11164 | 11164 | 11163 | {"type": "Polygon", "coordinates": [[[-118.34615, 34.09177], [-118.34615, 34.09186], [-118.34569, 34.09186], [-118.3457, 34.09177], [-118.34615, 34.09177]]]} | Open Access 1 | 47993 | Formosa Park | 32414 | 6103 | Private Landowner 584 | Private 7 | Other 25 | Private 14 | 1375 | West Hollywood, City of 331 | City 2 | City Agency 2 | https://www.weho.org/Home/Components/FacilityDirectory/FacilityDirectory/17/773 | Los Angeles 6 | 0.105 | Formosa Park | 2008 | Local Park 2 | 4 | |
10599 | 10599 | 10598 | {"type": "Polygon", "coordinates": [[[-122.44502, 37.45285], [-122.44494, 37.45344], [-122.44494, 37.45451], [-122.445, 37.45532], [-122.44411, 37.45541], [-122.44406, 37.4546], [-122.44284, 37.45476], [-122.4428, 37.4546], [-122.44263, 37.45462], [-122.44257, 37.45432], [-122.44041, 37.4546], [-122.43992, 37.4531], [-122.43998, 37.45304], [-122.43987, 37.4527], [-122.44219, 37.45241], [-122.44233, 37.45225], [-122.44492, 37.45192], [-122.44504, 37.4527], [-122.44502, 37.45285]]]} | Open Access 1 | 48637 | Poplar Beach | 33340 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 1128 | Half Moon Bay, City of 433 | City 2 | City Agency 2 | https://www.visithalfmoonbay.org/discover/poplar-beach | San Mateo 15 | 28.39 | Poplar Beach | 0 | Local Park 2 | 4 |
10621 | 10621 | 10620 | {"type": "Polygon", "coordinates": [[[-122.44604, 37.46514], [-122.44474, 37.46502], [-122.4448, 37.46461], [-122.44379, 37.46451], [-122.44452, 37.45959], [-122.44451, 37.45958], [-122.44382, 37.45967], [-122.44354, 37.45826], [-122.44345, 37.45827], [-122.44343, 37.45813], [-122.44351, 37.45811], [-122.44284, 37.45476], [-122.44407, 37.4546], [-122.44411, 37.45541], [-122.445, 37.45532], [-122.44514, 37.45654], [-122.44514, 37.45732], [-122.44526, 37.45784], [-122.44528, 37.45827], [-122.44461, 37.45834], [-122.4446, 37.45835], [-122.44481, 37.45961], [-122.445, 37.45984], [-122.4452, 37.46089], [-122.44544, 37.46227], [-122.44546, 37.46308], [-122.44557, 37.46346], [-122.44573, 37.46377], [-122.44593, 37.46432], [-122.44604, 37.46514]]]} | Open Access 1 | 48636 | Poplar Beach | 33340 | 1128 | Half Moon Bay, City of 439 | City 2 | City Agency 2 | http://www.half-moon-bay.ca.us/ | City 2 | 1128 | Half Moon Bay, City of 433 | City 2 | City Agency 2 | https://www.visithalfmoonbay.org/discover/poplar-beach | San Mateo 15 | 35.36 | Poplar Beach | 0 | Local Park 2 | 4 |
11453 | 11453 | 11452 | {"type": "Polygon", "coordinates": [[[-119.64146, 36.86082], [-119.64061, 36.86083], [-119.64054, 36.86081], [-119.64033, 36.86071], [-119.64039, 36.86063], [-119.64038, 36.86058], [-119.64034, 36.86054], [-119.64039, 36.86048], [-119.64043, 36.86049], [-119.64051, 36.8604], [-119.64048, 36.86038], [-119.64055, 36.86031], [-119.64068, 36.86025], [-119.64076, 36.86015], [-119.64076, 36.86006], [-119.64074, 36.85999], [-119.64069, 36.85994], [-119.6406, 36.85989], [-119.64045, 36.85988], [-119.64032, 36.85992], [-119.64025, 36.86], [-119.64022, 36.8601], [-119.64016, 36.86016], [-119.64014, 36.86015], [-119.64003, 36.86026], [-119.64004, 36.86027], [-119.63998, 36.86031], [-119.63993, 36.86029], [-119.63989, 36.86028], [-119.63977, 36.86035], [-119.63963, 36.86019], [-119.63964, 36.86015], [-119.64081, 36.85949], [-119.64109, 36.85938], [-119.64137, 36.85932], [-119.64141, 36.85934], [-119.64141, 36.85936], [-119.64144, 36.85937], [-119.64146, 36.86082]]]} | Open Access 1 | 48696 | Harlan Ranch Community Park | 33431 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | https://www.visitclovis.com/clovis-parks/ | Fresno 9 | 3.576 | Harlan Ranch Community Park | 0 | Local Park 2 | 4 |
12662 | 12662 | 12661 | {"type": "Polygon", "coordinates": [[[-121.20155, 37.78832], [-121.20155, 37.78832], [-121.19838, 37.78833], [-121.20016, 37.78641], [-121.20028, 37.78642], [-121.20056, 37.78639], [-121.20061, 37.78634], [-121.2015, 37.78686], [-121.20155, 37.78832]]]} | Open Access 1 | 48800 | Spreckels Park BMX | 33522 | 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 | https://www.usabmx.com/tracks/1770/pages/24 | San Joaquin 39 | 9.989 | Spreckels Park BMX | None 1098 | ||
1062 | 1062 | 1061 | {"type": "MultiPolygon", "coordinates": [[[[-118.45673, 35.11371], [-118.45597, 35.11371], [-118.45593, 35.11377], [-118.45581, 35.11377], [-118.45578, 35.11371], [-118.45496, 35.11372], [-118.45493, 35.11377], [-118.45481, 35.11377], [-118.45478, 35.11372], [-118.45396, 35.11372], [-118.45393, 35.11377], [-118.45381, 35.11378], [-118.45377, 35.11372], [-118.4533, 35.11373], [-118.4533, 35.11405], [-118.45325, 35.1142], [-118.45294, 35.11456], [-118.45264, 35.11437], [-118.45246, 35.11418], [-118.45238, 35.11404], [-118.45233, 35.11388], [-118.45231, 35.11363], [-118.45234, 35.11342], [-118.45246, 35.11307], [-118.45265, 35.11274], [-118.45281, 35.11254], [-118.45313, 35.11274], [-118.45334, 35.11296], [-118.45335, 35.11356], [-118.45376, 35.11356], [-118.45378, 35.11354], [-118.45388, 35.11355], [-118.45395, 35.11353], [-118.45397, 35.11355], [-118.45476, 35.11355], [-118.45478, 35.11353], [-118.45488, 35.11355], [-118.45495, 35.11353], [-118.45497, 35.11355], [-118.45573, 35.11355], [-118.45575, 35.11353], [-118.45582, 35.11354], [-118.45592, 35.11353], [-118.45594, 35.11354], [-118.45672, 35.11354], [-118.45673, 35.11371]]], [[[-118.45822, 35.1139], [-118.45803, 35.11388], [-118.45779, 35.11378], [-118.45764, 35.11374], [-118.45703, 35.11373], [-118.45698, 35.11369], [-118.45698, 35.11358], [-118.45822, 35.11358], [-118.45822, 35.1139]]]]} | Open Access 1 | 48916 | Warrior Park | 33637 | 1467 | Tehachapi, City of 310 | City 2 | City Agency 2 | http://www.tehachapicityhall.com/ | City 2 | 1467 | Tehachapi, City of 307 | City 2 | City Agency 2 | https://www.tvrpd.org/ | Kern 36 | 5.909 | Warrior Park | 0 | Local Park 2 | 4 |
14220 | 14220 | 14219 | {"type": "Polygon", "coordinates": [[[-117.81871, 33.70241], [-117.81877, 33.70265], [-117.81878, 33.70282], [-117.81875, 33.70298], [-117.81862, 33.70333], [-117.81797, 33.70315], [-117.81755, 33.70299], [-117.81691, 33.70264], [-117.81689, 33.70253], [-117.81721, 33.70226], [-117.81758, 33.70204], [-117.81798, 33.70187], [-117.8183, 33.70178], [-117.8184, 33.70183], [-117.81843, 33.70182], [-117.81845, 33.70186], [-117.81843, 33.70189], [-117.81854, 33.70221], [-117.81852, 33.70225], [-117.81856, 33.70238], [-117.81863, 33.70238], [-117.81865, 33.70242], [-117.81871, 33.70241]]]} | Open Access 1 | 48852 | Victory Park | 33572 | 1360 | Tustin, City of 278 | City 2 | City Agency 2 | http://www.tustinca.org/departments/parksrec/index.html | City 2 | 1360 | Tustin, City of 274 | City 2 | City Agency 2 | https://www.tustinca.org/Facilities/Facility/Details/Victory-Park-6 | Orange 3 | 4.505 | Victory Park | 0 | Local Park 2 | 4 |
14131 | 14131 | 14130 | {"type": "Polygon", "coordinates": [[[-119.32522, 36.15647], [-119.32197, 36.1564], [-119.32208, 36.15273], [-119.32208, 36.15273], [-119.32522, 36.15647]]]} | Open Access 1 | 48851 | Elk Bayou Soccer Complex | 33571 | 1398 | Tulare, City of 163 | City 2 | City Agency 2 | http://www.ci.tulare.ca.us/local_government/departments/rec_parks_library/parks.htm | City 2 | 1398 | Tulare, City of 159 | City 2 | City Agency 2 | https://www.tulare.ca.gov/Home/Components/FacilityDirectory/FacilityDirectory/22/155 | Tulare 29 | 14.659 | Elk Bayou Soccer Complex | 0 | Local Recreation Area 3 | 4 |
14702 | 14702 | 14701 | {"type": "Polygon", "coordinates": [[[-118.24012, 33.93118], [-118.24012, 33.93118], [-118.2401, 33.93246], [-118.23934, 33.931], [-118.23943, 33.93111], [-118.23957, 33.93117], [-118.24012, 33.93118]]]} | Open Access 1 | 45057 | Watts Serenity Park | 28919 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | https://www.tpl.org/our-work/parks-for-people/fitness-zones/monitor-avenue-park | Los Angeles 6 | 1.147 | Watts Serenity Park | 0 | Local Park 2 | 4 |
15050 | 15050 | 15049 | {"type": "Polygon", "coordinates": [[[-118.31903, 34.101], [-118.31887, 34.101], [-118.31887, 34.10054], [-118.31903, 34.10054], [-118.31903, 34.101]]]} | Open Access 1 | 45719 | Carlton Way Pocket Park | 28612 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | https://www.tpl.org/our-work/parks-for-people/carlton-way-pocket-park | Los Angeles 6 | 0.191 | Carlton Way PP | 0 | Local Park 2 | 4 |
4131 | 4131 | 4130 | {"type": "Polygon", "coordinates": [[[-118.54299, 34.19064], [-118.54284, 34.19074], [-118.54242, 34.19049], [-118.54196, 34.1903], [-118.54174, 34.19014], [-118.54291, 34.18966], [-118.54291, 34.19054], [-118.54299, 34.19064]]]} | Open Access 1 | 47400 | Los Angeles River and Aliso Creek Confluence Park | 31121 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | https://www.tpl.org/our-work/los-angeles-river-aliso-creek-confluence-project | Los Angeles 6 | 1.682 | Los Angeles River and Aliso Creek Confluence Park | 2016 | Local Park 2 | 4 |
16245 | 16245 | 16244 | {"type": "Polygon", "coordinates": [[[-118.32437, 33.83122], [-118.32371, 33.83123], [-118.32371, 33.83073], [-118.32329, 33.83036], [-118.32348, 33.83021], [-118.32436, 33.83102], [-118.32437, 33.83122]]]} | Restricted Access 2 | 35907 | ATTIC Teen Center | 32631 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | https://www.torranceca.gov/our-city/recreation/attic | Los Angeles 6 | 1.086 | ATTIC Teen Ctr. | 0 | Local Recreation Area 3 | 4 |
11279 | 11279 | 11278 | {"type": "Polygon", "coordinates": [[[-118.15783, 34.11516], [-118.15741, 34.1155], [-118.15725, 34.11565], [-118.15722, 34.11553], [-118.15722, 34.11543], [-118.15741, 34.11524], [-118.15742, 34.11513], [-118.15783, 34.11513], [-118.15783, 34.11516]]]} | Open Access 1 | 48041 | Ironwork Historical Museum and Park | 32534 | 1340 | South Pasadena, City of 309 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/ | City 2 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | https://www.southpasadenaca.gov/government/departments/community-services/administration/south-pasadena-historical-museum | Los Angeles 6 | 0.327 | Ironwork Historical Museum and Park | 0 | Local Historic or Cultural Area 19 | 4 |
11165 | 11165 | 11164 | {"type": "Polygon", "coordinates": [[[-118.15596, 34.11789], [-118.15596, 34.11836], [-118.15571, 34.11836], [-118.15572, 34.11789], [-118.15596, 34.11789]]]} | Open Access 1 | 47994 | South Pasadena Community Garden and Demonstration Garden | 32415 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | https://www.southpasadenaca.gov/government/departments/community-services/administration/community-garden | Los Angeles 6 | 0.293 | South Pasadena Community Garden and Demonstration Garden | 2015 | 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 |
7202 | 7202 | 7201 | {"type": "MultiPolygon", "coordinates": [[[[-122.08675, 37.42707], [-122.08665, 37.42777], [-122.0866, 37.42777], [-122.08652, 37.42829], [-122.08642, 37.42853], [-122.08634, 37.42879], [-122.08634, 37.4303], [-122.08631, 37.4319], [-122.08627, 37.43212], [-122.08618, 37.43232], [-122.07998, 37.43227], [-122.07998, 37.43132], [-122.07863, 37.43129], [-122.07818, 37.43017], [-122.07811, 37.42836], [-122.0782, 37.42835], [-122.07825, 37.42808], [-122.07871, 37.42822], [-122.07869, 37.42827], [-122.0787, 37.42828], [-122.07905, 37.42837], [-122.07918, 37.42839], [-122.07931, 37.42835], [-122.07941, 37.42831], [-122.07951, 37.42824], [-122.0796, 37.42813], [-122.0797, 37.42809], [-122.08017, 37.42808], [-122.08018, 37.42802], [-122.08101, 37.42802], [-122.08132, 37.42798], [-122.08163, 37.4279], [-122.08192, 37.42776], [-122.08196, 37.4278], [-122.08199, 37.42778], [-122.08212, 37.42768], [-122.08222, 37.42756], [-122.0823, 37.42743], [-122.08236, 37.42729], [-122.08235, 37.42727], [-122.0823, 37.42726], [-122.08232, 37.42705], [-122.08231, 37.42687], [-122.08227, 37.42669], [-122.08222, 37.42655], [-122.08214, 37.42641], [-122.08206, 37.4263], [-122.08198, 37.42634], [-122.0819, 37.4262], [-122.08171, 37.42594], [-122.0814, 37.42575], [-122.08137, 37.42576], [-122.08116, 37.42567], [-122.08118, 37.42556], [-122.08056, 37.42392], [-122.08052, 37.42331], [-122.08252, 37.42314], [-122.08323, 37.42312], [-122.08368, 37.42312], [-122.08438, 37.42316], [-122.08484, 37.42321], [-122.08644, 37.42349], [-122.08643, 37.4251], [-122.08648, 37.42532], [-122.08658, 37.42552], [-122.08658, 37.42554], [-122.08664, 37.42566], [-122.08667, 37.42578], [-122.08672, 37.42643], [-122.08671, 37.42644], [-122.08675, 37.42707]], [[-122.08565, 37.42951], [-122.08582, 37.42933], [-122.08576, 37.42914], [-122.0844, 37.4291], [-122.08442, 37.4296], [-122.08422, 37.42967], [-122.08298, 37.42981], [-122.08175, 37.43038], [-122.08106, 37.43059], [-122.08118, 37.43081], [-122.08189, 37.43067], [-122.08301, 37.43019], [-122.08385, 37.43006], [-122.08567, 37.42997], [-122.08565, 37.42951]]], [[[-122.09679, 37.43194], [-122.09677, 37.43202], [-122.09523, 37.43188], [-122.09523, 37.4321], [-122.09529, 37.43234], [-122.09543, 37.43261], [-122.0956, 37.43281], [-122.09581, 37.43298], [-122.09607, 37.43312], [-122.09633, 37.4332], [-122.09662, 37.43324], [-122.09647, 37.43436], [-122.09557, 37.43461], [-122.09481, 37.43405], [-122.09451, 37.43353], [-122.09493, 37.43321], [-122.09492, 37.43296], [-122.09465, 37.43263], [-122.09358, 37.43242], [-122.09288, 37.43266], [-122.09258, 37.43252], [-122.08673, 37.43233], [-122.08677, 37.43221], [-122.0868, 37.43188], [-122.08683, 37.42881], [-122.08695, 37.42803], [-122.08691, 37.428], [-122.087, 37.42744], [-122.08702, 37.42715], [-122.08701, 37.42662], [-122.08698, 37.42661], [-122.08698, 37.42595], [-122.08709, 37.42469], [-122.09056, 37.42473], [-122.09126, 37.42477], [-122.09197, 37.42493], [-122.09235, 37.42504], [-122.09272, 37.42518], [-122.09314, 37.42536], [-122.09353, 37.42559], [-122.09379, 37.42577], [-122.09422, 37.42612], [-122.09449, 37.4264], [-122.0947, 37.42666], [-122.09497, 37.42707], [-122.09512, 37.42725], [-122.09526, 37.42758], [-122.09537, 37.42794], [-122.09543, 37.4283], [-122.09545, 37.42873], [-122.09524, 37.43178], [-122.09679, 37.43194]], [[-122.09321, 37.42862], [-122.09353, 37.4287], [-122.09364, 37.42845], [-122.09299, 37.42828], [-122.09295, 37.4287], [-122.09319, 37.42876], [-122.09324, 37.42867], [-122.09321, 37.42862]], [[-122.09427, 37.42776], [-122.09428, 37.42775], [-122.09427, 37.42758], [-122.09406, 37.42767], [-122.09427, 37.42776]]]]} | Restricted Access 2 | 48420 | Shoreline Golf Links | 33080 | 1218 | Mountain View, City of 460 | City 2 | City Agency 2 | http://www.ci.mtnview.ca.us/services/parks/default.asp | City 2 | 1218 | Mountain View, City of 453 | City 2 | City Agency 2 | https://www.shorelinelinks.com/ | Santa Clara 19 | 289.243 | Shoreline Golf Links | 1986 | None 590 | |
1746 | 1746 | 1745 | {"type": "Polygon", "coordinates": [[[-119.2751, 35.50217], [-119.2748, 35.50242], [-119.27445, 35.50212], [-119.27474, 35.50188], [-119.2751, 35.50217]]]} | Open Access 1 | 48487 | Town Square Park | 33197 | 1668 | Shafter, City of 418 | City 2 | City Agency 2 | http://www.shafter.com/73/Parks | City 2 | 1668 | Shafter, City of 412 | City 2 | City Agency 2 | https://www.shafter.com/73/Parks | Kern 36 | 0.43 | Town Square Park | 0 | Local Park 2 | 4 |
11163 | 11163 | 11162 | {"type": "Polygon", "coordinates": [[[-122.43003, 37.77971], [-122.42876, 37.77987], [-122.42861, 37.77913], [-122.42988, 37.77897], [-122.43003, 37.77971]]]} | Open Access 1 | 48006 | Ella Hill Hutch Center | 32433 | 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 | https://www.sfparksalliance.org/our-parks/parks/ella-hill-hutch-center | San Francisco 13 | 2.344 | Ella Hill Hutch Ctr. | 0 | Local Recreation Area 3 | 4 |
4434 | 4434 | 4433 | {"type": "Polygon", "coordinates": [[[-121.95471, 37.32693], [-121.95432, 37.327], [-121.95364, 37.327], [-121.95364, 37.32676], [-121.95367, 37.32675], [-121.95377, 37.32665], [-121.95387, 37.32661], [-121.95415, 37.32662], [-121.95426, 37.3266], [-121.95437, 37.32654], [-121.95445, 37.32662], [-121.95471, 37.32662], [-121.95471, 37.32693]]]} | Open Access 1 | 48912 | Thomas Barrett Park | 33633 | 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 | https://www.santaclaraca.gov/Home/Components/ServiceDirectory/ServiceDirectory/4116/2654 | Santa Clara 19 | 0.948 | Thomas Barrett 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]);