units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
164 rows where DES_TP = 3 and MNG_AG_TYP = 4 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- East Bay Regional Park District 19
- Conejo Recreation and Park District 14
- Sunrise Recreation and Park District 12
- Rancho Simi Recreation and Park District 9
- Valley-Wide Recreation and Park District 9
- Hayward Area Recreation and Park District 6
- Desert Recreation District 6
- Isla Vista Recreation and Park District 5
- Southgate Recreation and Park District 5
- Tuolumne Park and Recreation District 4
- Miraleste Recreation and Park District 4
- Monterey Peninsula Regional Park District 3
- Pleasant Valley Recreation and Park District 3
- Apple Valley Recreation and Park District 3
- Pleasant Hill Recreation and Park District 3
- Durham Recreation and Park District 3
- Barstow Recreation and Park District 2
- Jurupa Area Recreation and Park District 2
- North of the River Recreation and Park District 2
- West Side Recreation and Park District 2
- Truckee-Donner Recreation and Park District 2
- Hesperia Recreation and Park District 2
- Orangevale Recreation and Park District 2
- Weed Recreation and Parks District 2
- Feather River Recreation and Park District 1
- Greater Vallejo Recreation and Park District 1
- Shafter Recreation and Park District 1
- Auburn Area Recreation and Park District 1
- Monterey Peninsula Recreational Trail Joint Powers 1
- Rio Linda Elverta Recreation and Park District 1
- …
ACCESS_TYP 3
MNG_AG_TYP 1
- Recreation/Parks District · 144 ✖
DES_TP 1
- Local Recreation Area · 144 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12726 | 12726 | 12725 | {"type": "MultiPolygon", "coordinates": [[[[-121.93312, 37.96917], [-121.93309, 37.9762], [-121.92397, 37.97636], [-121.92389, 37.98339], [-121.91481, 37.9835], [-121.91485, 37.97467], [-121.91541, 37.97455], [-121.91619, 37.97432], [-121.91638, 37.97432], [-121.91684, 37.97403], [-121.917, 37.97372], [-121.91739, 37.97344], [-121.91795, 37.97331], [-121.91823, 37.97315], [-121.91876, 37.97249], [-121.91908, 37.97226], [-121.91945, 37.97219], [-121.91991, 37.97201], [-121.92004, 37.97193], [-121.92076, 37.97121], [-121.92124, 37.97103], [-121.92209, 37.97065], [-121.92264, 37.97037], [-121.92271, 37.9702], [-121.9229, 37.97006], [-121.92356, 37.96996], [-121.92384, 37.9698], [-121.9245, 37.96925], [-121.93312, 37.96917]]], [[[-121.92264, 37.96928], [-121.922, 37.96996], [-121.92175, 37.97005], [-121.92152, 37.97027], [-121.92122, 37.97042], [-121.9205, 37.9709], [-121.91988, 37.97127], [-121.91761, 37.97247], [-121.91709, 37.97284], [-121.91631, 37.97367], [-121.91588, 37.97391], [-121.91493, 37.9742], [-121.91489, 37.96938], [-121.92264, 37.96928]]]]} | No Public Access 3 | 29753 | CNWS to Black Diamond | 17451 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 449.119 | CNWS to Black Diamond | 0 | Local Recreation Area 3 | 4 | |
16657 | 16657 | 16656 | {"type": "Polygon", "coordinates": [[[-116.19033, 33.67452], [-116.19033, 33.67636], [-116.19023, 33.67636], [-116.19023, 33.6764], [-116.19033, 33.67641], [-116.19032, 33.67751], [-116.1899, 33.67751], [-116.18989, 33.67761], [-116.18861, 33.6776], [-116.18862, 33.67642], [-116.18777, 33.67642], [-116.18776, 33.67815], [-116.18595, 33.67815], [-116.18597, 33.67638], [-116.18705, 33.67637], [-116.18705, 33.67459], [-116.18814, 33.67458], [-116.18815, 33.67451], [-116.19033, 33.67452]], [[-116.18991, 33.67643], [-116.18948, 33.67642], [-116.18947, 33.67702], [-116.1899, 33.67702], [-116.18991, 33.67643]]]} | Open Access 1 | 24266 | Coachella Community Center and Bagdouma Park | 17452 | 2216 | Desert Recreation District 286 | Special District 4 | Recreation/Parks District 4 | http://www.myrecreationdistrict.com | Special District 4 | 2216 | Desert Recreation District 282 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 28.13 | Coachella Community Ctr. and Bagdouma Park | 0 | Local Recreation Area 3 | 4 | |
2046 | 2046 | 2045 | {"type": "Polygon", "coordinates": [[[-118.90087, 34.21526], [-118.90083, 34.21549], [-118.90044, 34.21561], [-118.90035, 34.21547], [-118.90019, 34.21531], [-118.90026, 34.21519], [-118.90029, 34.21507], [-118.90075, 34.21508], [-118.90087, 34.21526]]]} | Open Access 1 | 15585 | Conejo Recreation and Park District | 17586 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 0.656 | Conejo Rec. and Park District | 0 | Local Recreation Area 3 | 4 | |
2047 | 2047 | 2046 | {"type": "Polygon", "coordinates": [[[-118.82311, 34.2117], [-118.82304, 34.212], [-118.82178, 34.21232], [-118.8209, 34.21284], [-118.82064, 34.2127], [-118.82024, 34.21277], [-118.81916, 34.21315], [-118.81817, 34.21344], [-118.81724, 34.21322], [-118.81664, 34.21319], [-118.81637, 34.21305], [-118.81624, 34.21296], [-118.81654, 34.21275], [-118.81686, 34.21244], [-118.817, 34.21233], [-118.81723, 34.21222], [-118.81746, 34.21215], [-118.81768, 34.21213], [-118.8179, 34.21214], [-118.82005, 34.21254], [-118.82032, 34.21256], [-118.82056, 34.21256], [-118.82089, 34.2125], [-118.82121, 34.21239], [-118.82229, 34.21176], [-118.82247, 34.21168], [-118.82275, 34.21162], [-118.82299, 34.21161], [-118.82309, 34.21163], [-118.82311, 34.21166], [-118.82311, 34.2117]]]} | Open Access 1 | 15591 | Conejo Recreation and Park District | 17586 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 10.413 | Conejo Rec. and Park District | 0 | Local Recreation Area 3 | 4 | |
5082 | 5082 | 5081 | {"type": "Polygon", "coordinates": [[[-118.85008, 34.18256], [-118.84998, 34.18289], [-118.84956, 34.1828], [-118.84971, 34.18249], [-118.85008, 34.18256]]]} | Open Access 1 | 15579 | Conejo Recreation and Park District | 17586 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 0.346 | Conejo Rec. and Park District | 0 | Local Recreation Area 3 | 4 | |
5083 | 5083 | 5082 | {"type": "Polygon", "coordinates": [[[-118.89482, 34.22828], [-118.89475, 34.22845], [-118.8946, 34.2284], [-118.8946, 34.22839], [-118.89482, 34.22828]]]} | Open Access 1 | 15581 | Conejo Recreation and Park District | 17586 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 0.041 | Conejo Rec. and Park District | 0 | Local Recreation Area 3 | 4 | |
5243 | 5243 | 5242 | {"type": "Polygon", "coordinates": [[[-118.87309, 34.18644], [-118.87297, 34.18708], [-118.87264, 34.18703], [-118.87276, 34.1864], [-118.87309, 34.18644]]]} | Open Access 1 | 15577 | Conejo Recreation and Park District | 17586 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 0.536 | Conejo Rec. and Park District | 0 | Local Recreation Area 3 | 4 | |
9344 | 9344 | 9343 | {"type": "Polygon", "coordinates": [[[-118.93287, 34.20622], [-118.93193, 34.20716], [-118.93113, 34.20679], [-118.93227, 34.2058], [-118.93257, 34.20603], [-118.93287, 34.20622]]]} | Open Access 1 | 15600 | Conejo Recreation and Park District | 17586 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 2.722 | Conejo Rec. and Park District | 0 | Local Recreation Area 3 | 4 | |
16805 | 16805 | 16804 | {"type": "Polygon", "coordinates": [[[-118.90091, 34.2165], [-118.90088, 34.21655], [-118.90042, 34.2164], [-118.90045, 34.21635], [-118.90091, 34.2165]]]} | Open Access 1 | 15583 | Conejo Recreation and Park District | 17586 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 0.068 | Conejo Rec. and Park District | 0 | Local Recreation Area 3 | 4 | |
3355 | 3355 | 3354 | {"type": "Polygon", "coordinates": [[[-116.36064, 33.7325], [-116.36064, 33.73492], [-116.35884, 33.73445], [-116.35656, 33.73376], [-116.35647, 33.73315], [-116.35647, 33.73251], [-116.36064, 33.7325]]]} | Open Access 1 | 24277 | Cook Fields Sports Complex | 17615 | 2216 | Desert Recreation District 286 | Special District 4 | Recreation/Parks District 4 | http://www.myrecreationdistrict.com | Special District 4 | 2216 | Desert Recreation District 282 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 19.46 | Cook Fields Sports Complex | 0 | Local Recreation Area 3 | 4 | |
3502 | 3502 | 3501 | {"type": "MultiPolygon", "coordinates": [[[[-121.38155, 38.45546], [-121.38133, 38.45552], [-121.38115, 38.45563], [-121.38102, 38.45578], [-121.38096, 38.45595], [-121.38097, 38.45515], [-121.38053, 38.45511], [-121.38059, 38.45505], [-121.3806, 38.45497], [-121.38057, 38.45493], [-121.38053, 38.45491], [-121.38047, 38.4549], [-121.38041, 38.4549], [-121.38041, 38.45474], [-121.38085, 38.45497], [-121.38115, 38.45506], [-121.3814, 38.45506], [-121.38155, 38.45546]]], [[[-121.38319, 38.45988], [-121.38277, 38.45988], [-121.38264, 38.4596], [-121.38272, 38.45954], [-121.38274, 38.45948], [-121.3827, 38.45937], [-121.3827, 38.45913], [-121.38268, 38.45901], [-121.38261, 38.45886], [-121.38245, 38.45861], [-121.38238, 38.45845], [-121.38224, 38.45784], [-121.38214, 38.45762], [-121.38195, 38.4573], [-121.38188, 38.45714], [-121.38182, 38.45694], [-121.38176, 38.45661], [-121.38171, 38.45649], [-121.38156, 38.45622], [-121.38155, 38.45617], [-121.38155, 38.4561], [-121.38154, 38.45606], [-121.38149, 38.45601], [-121.3814, 38.456], [-121.38131, 38.45603], [-121.38128, 38.45611], [-121.38109, 38.45611], [-121.38109, 38.45594], [-121.38113, 38.45583], [-121.38123, 38.4557], [-121.38135, 38.45562], [-121.38148, 38.45558], [-121.38159, 38.45557], [-121.38319, 38.45988]]]]} | Open Access 1 | 36025 | Danbury Parkway | 17917 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 3.905 | Danbury Parkway | 0 | Local Recreation Area 3 | 4 | |
11729 | 11729 | 11728 | {"type": "Polygon", "coordinates": [[[-121.43409, 38.49084], [-121.43187, 38.49083], [-121.4318, 38.48936], [-121.43254, 38.48936], [-121.43253, 38.48901], [-121.43257, 38.48901], [-121.43256, 38.48881], [-121.434, 38.48881], [-121.43409, 38.49084]]]} | Open Access 1 | 24024 | Daylor Sports Field | 17963 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 9.775 | Daylor Sports Field | 0 | Local Recreation Area 3 | 4 | |
14560 | 14560 | 14559 | {"type": "Polygon", "coordinates": [[[-117.55346, 33.96127], [-117.55339, 33.96134], [-117.5529, 33.96113], [-117.55289, 33.96099], [-117.55294, 33.96096], [-117.55314, 33.96096], [-117.55346, 33.96127]]]} | Open Access 1 | 44681 | Delaware Greenbelt | 18064 | 2051 | Jurupa Area Recreation and Park District 364 | Special District 4 | Recreation/Parks District 4 | http://www.jarpd.org/ | Special District 4 | 2051 | Jurupa Area Recreation and Park District 360 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 0.28 | Delaware Greenbelt | 0 | Local Recreation Area 3 | 4 | |
3269 | 3269 | 3268 | {"type": "Polygon", "coordinates": [[[-122.0528, 37.99715], [-122.05267, 37.99768], [-122.05079, 37.99735], [-122.05079, 37.99734], [-122.05051, 37.99729], [-122.05017, 37.99725], [-122.05016, 37.99724], [-122.04978, 37.99725], [-122.04887, 37.99733], [-122.04817, 37.99731], [-122.04823, 37.9969], [-122.04863, 37.99694], [-122.04888, 37.99693], [-122.04913, 37.99691], [-122.04957, 37.9968], [-122.04985, 37.99676], [-122.04986, 37.99675], [-122.05003, 37.99674], [-122.0501, 37.99681], [-122.05025, 37.99683], [-122.05029, 37.99673], [-122.05066, 37.99677], [-122.0528, 37.99715]]]} | Open Access 1 | 29407 | Delta/DeAnza Trail | 18077 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 5.445 | Delta/DeAnza Trail | 0 | Local Recreation Area 3 | 4 | |
16865 | 16865 | 16864 | {"type": "Polygon", "coordinates": [[[-122.05729, 37.69054], [-122.05732, 37.69085], [-122.05729, 37.69148], [-122.05633, 37.69209], [-122.05634, 37.6921], [-122.05717, 37.69218], [-122.05717, 37.69221], [-122.05697, 37.6922], [-122.05678, 37.69223], [-122.05659, 37.69231], [-122.05652, 37.6924], [-122.05651, 37.69247], [-122.05681, 37.69276], [-122.05683, 37.69285], [-122.054, 37.69283], [-122.05267, 37.69268], [-122.05186, 37.69251], [-122.05066, 37.6925], [-122.04958, 37.69254], [-122.04867, 37.69261], [-122.04792, 37.69283], [-122.04737, 37.69305], [-122.04695, 37.69323], [-122.04462, 37.69495], [-122.04445, 37.69518], [-122.0443, 37.69495], [-122.04441, 37.69486], [-122.0444, 37.69484], [-122.04436, 37.69484], [-122.04435, 37.69471], [-122.04447, 37.69457], [-122.04474, 37.69442], [-122.04516, 37.69407], [-122.04494, 37.69362], [-122.04498, 37.69344], [-122.04451, 37.69339], [-122.0444, 37.69311], [-122.04449, 37.69281], [-122.04454, 37.69281], [-122.04455, 37.6928], [-122.04437, 37.69253], [-122.04448, 37.69232], [-122.04501, 37.69184], [-122.0468, 37.69227], [-122.04681, 37.69226], [-122.04649, 37.69079], [-122.04436, 37.68999], [-122.0459, 37.68885], [-122.04634, 37.68978], [-122.04766, 37.69015], [-122.04857, 37.69003], [-122.04902, 37.69009], [-122.04925, 37.69005], [-122.04971, 37.68979], [-122.0496, 37.68951], [-122.05131, 37.68901], [-122.05114, 37.68863], [-122.05124, 37.68858], [-122.05202, 37.69024], [-122.0525, 37.69017], [-122.05276, 37.68967], [-122.05267, 37.6895], [-122.05299, 37.6894], [-122.05313, 37.68929], [-122.05364, 37.68902], [-122.05376, 37.68926], [-122.05485, 37.68961], [-122.05486, 37.6896], [-122.05485, 37.68952], [-122.05486, 37.68945], [-122.05493, 37.68947], [-122.05512, 37.68946], [-122.05515, 37.6897], [-122.05513, 37.6897], [-122.05511, 37.68989], [-122.0562, 37.68985], [-122.05698, 37.69056], [-122.05729, 37.69054]]]} | Open Access 1 | 49046 | Don Castro Regional Recreation Area | 18199 | 2000 | Alameda County Flood Control and Water Conservation District 771 | Special District 4 | Flood District 8 | http://acfloodcontrol.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | https://www.ebparks.org/parks/don_castro/ | Alameda 17 | 91.383 | Don Castro Reg. Rec. Area | 1969 | Local Recreation Area 3 | 4 |
13472 | 13472 | 13471 | {"type": "Polygon", "coordinates": [[[-121.80194, 39.64878], [-121.80091, 39.64895], [-121.80036, 39.64752], [-121.80032, 39.64731], [-121.80034, 39.64725], [-121.80107, 39.64708], [-121.80118, 39.64737], [-121.80146, 39.6475], [-121.80194, 39.64878]]]} | Open Access 1 | 35731 | Durham Recreation and Park District 1 | 18313 | 2030 | Durham Recreation and Park District 1060 | Special District 4 | Recreation/Parks District 4 | http://www.durhamrec.com/ | Special District 4 | 2030 | Durham Recreation and Park District 1018 | Special District 4 | Recreation/Parks District 4 | Butte 42 | 4.222 | Durham Rec. and Park District 1 | 0 | Local Recreation Area 3 | 4 | |
13473 | 13473 | 13472 | {"type": "Polygon", "coordinates": [[[-121.77925, 39.64587], [-121.77474, 39.646], [-121.77471, 39.64458], [-121.77478, 39.64455], [-121.77507, 39.64437], [-121.77532, 39.64415], [-121.77556, 39.64373], [-121.77523, 39.64316], [-121.77663, 39.64268], [-121.77925, 39.64587]]]} | Open Access 1 | 35730 | Durham Recreation and Park District 2 | 18314 | 2030 | Durham Recreation and Park District 1060 | Special District 4 | Recreation/Parks District 4 | http://www.durhamrec.com/ | Special District 4 | 2030 | Durham Recreation and Park District 1018 | Special District 4 | Recreation/Parks District 4 | Butte 42 | 21.557 | Durham Rec. and Park District 2 | 0 | Local Recreation Area 3 | 4 | |
16829 | 16829 | 16828 | {"type": "Polygon", "coordinates": [[[-121.76741, 39.55063], [-121.76703, 39.55071], [-121.76672, 39.54986], [-121.76666, 39.54986], [-121.76665, 39.54988], [-121.76696, 39.55072], [-121.76658, 39.55081], [-121.76622, 39.54984], [-121.76705, 39.54966], [-121.76741, 39.55063]]]} | Open Access 1 | 35629 | Durham Recreation and Park District 3 | 18315 | 2030 | Durham Recreation and Park District 1060 | Special District 4 | Recreation/Parks District 4 | http://www.durhamrec.com/ | Special District 4 | 2030 | Durham Recreation and Park District 1018 | Special District 4 | Recreation/Parks District 4 | Butte 42 | 1.89 | Durham Rec. and Park District 3 | 0 | Local Recreation Area 3 | 4 | |
9491 | 9491 | 9490 | {"type": "MultiPolygon", "coordinates": [[[[-122.09248, 37.63911], [-122.0841, 37.6505], [-122.08146, 37.65183], [-122.07932, 37.65272], [-122.07691, 37.65391], [-122.07795, 37.65562], [-122.07648, 37.65631], [-122.07596, 37.6575], [-122.07548, 37.65686], [-122.0758, 37.65603], [-122.07718, 37.65545], [-122.07612, 37.65385], [-122.07844, 37.65278], [-122.07985, 37.65207], [-122.08117, 37.65159], [-122.08237, 37.65106], [-122.0835, 37.65035], [-122.09167, 37.63886], [-122.09176, 37.63896], [-122.09222, 37.63912], [-122.09248, 37.63911]]], [[[-122.09853, 37.63425], [-122.09587, 37.63524], [-122.0951, 37.63524], [-122.09477, 37.63517], [-122.09827, 37.63389], [-122.09853, 37.63425]]], [[[-122.10894, 37.62975], [-122.10565, 37.63124], [-122.0989, 37.63411], [-122.09867, 37.63374], [-122.10872, 37.62921], [-122.10894, 37.62975]]]]} | Open Access 1 | 15886 | Eden Greenway | 18427 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 54.736 | Eden Greenway | 1970 | Local Recreation Area 3 | 4 | |
16206 | 16206 | 16205 | {"type": "MultiPolygon", "coordinates": [[[[-121.25745, 38.71827], [-121.25706, 38.71836], [-121.25661, 38.71824], [-121.25604, 38.71835], [-121.25531, 38.7183], [-121.25481, 38.7183], [-121.25458, 38.71785], [-121.25377, 38.71788], [-121.25328, 38.7182], [-121.25312, 38.71819], [-121.25286, 38.71813], [-121.25264, 38.71812], [-121.25257, 38.71784], [-121.25237, 38.71788], [-121.25149, 38.71703], [-121.25155, 38.717], [-121.25163, 38.71644], [-121.25132, 38.71635], [-121.25131, 38.71616], [-121.2509, 38.71615], [-121.25093, 38.71604], [-121.25088, 38.71596], [-121.25078, 38.71592], [-121.25061, 38.71591], [-121.25062, 38.71554], [-121.25014, 38.71543], [-121.25015, 38.71537], [-121.24976, 38.71477], [-121.24969, 38.71478], [-121.24951, 38.71459], [-121.24941, 38.71442], [-121.24946, 38.71417], [-121.24989, 38.714], [-121.24981, 38.71437], [-121.25022, 38.71465], [-121.25022, 38.71501], [-121.25049, 38.71539], [-121.25132, 38.71542], [-121.25177, 38.71557], [-121.25215, 38.71577], [-121.2526, 38.71618], [-121.25276, 38.71637], [-121.25277, 38.71658], [-121.25261, 38.71688], [-121.25297, 38.71734], [-121.25333, 38.71738], [-121.25374, 38.71722], [-121.25376, 38.71752], [-121.25438, 38.71751], [-121.25463, 38.71726], [-121.2548, 38.71733], [-121.25492, 38.71737], [-121.25509, 38.7178], [-121.25531, 38.7178], [-121.2561, 38.71779], [-121.25611, 38.71739], [-121.25646, 38.71738], [-121.25695, 38.7173], [-121.25696, 38.71737], [-121.25722, 38.71769], [-121.2574, 38.71774], [-121.25738, 38.71787], [-121.25739, 38.71803], [-121.25745, 38.71827]]], [[[-121.26254, 38.71962], [-121.26116, 38.71952], [-121.26128, 38.71921], [-121.26101, 38.71881], [-121.26072, 38.71861], [-121.26024, 38.71858], [-121.26019, 38.71897], [-121.25863, 38.71886], [-121.25863, 38.71854], [-121.25823, 38.71839], [-121.25818, 38.71824], [-121.2577, 38.7182], [-121.25763, 38.71822], [-121.25758, 38.71806], [-121.25757, 38.71792], [-121.25758, 38.71779], [-121.25762, 38.71768], [-121.25763, 38.71764], [-121.25811, 38.71778], [-121.25821, 38.71765], [-121.25843, 38.7178], [-121.25868, 38.71794], [-121.25896, 38.71806], [-121.25924, 38.71814], [-121.25971, 38.71822], [-121.26008, 38.71788], [-121.2606, 38.71806], [-121.26089, 38.71821], [-121.26131, 38.71847], [-121.26162, 38.71861], [-121.26184, 38.71867], [-121.26209, 38.71872], [-121.26253, 38.71873], [-121.26254, 38.71962]]]]} | Open Access 1 | 44064 | Edgecliff/Cripple Creek Open Space | 18434 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 24.487 | Edgecliff/Cripple Creek 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]);