superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
931 rows where ACCESS_TYP = 1 and MNG_AG_TYP = 4 sorted by YR_EST
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Hayward Area Recreation and Park District 77
- East Bay Regional Park District 73
- Valley-Wide Recreation and Park District 66
- Rancho Simi Recreation and Park District 51
- Conejo Recreation and Park District 41
- Sunrise Recreation and Park District 39
- Marin County Open Space District 38
- Southgate Recreation and Park District 38
- Cordova Recreation and Park District 36
- Greater Vallejo Recreation and Park District 32
- Pleasant Valley Recreation and Park District 31
- North of the River Recreation and Park District 27
- Midpeninsula Regional Open Space District 24
- Jurupa Area Recreation and Park District 18
- Monterey Peninsula Regional Park District 17
- Isla Vista Recreation and Park District 14
- Desert Recreation District 14
- Mission Oaks Recreation and Park District 14
- Apple Valley Recreation and Park District 13
- Pleasant Hill Recreation and Park District 12
- Carmichael Recreation and Park District 12
- Auburn Area Recreation and Park District 11
- North Highland Recreation and Park District 11
- Hesperia Recreation and Park District 10
- Miraleste Recreation and Park District 10
- Livermore Area Recreation and Park District 9
- Rio Linda Elverta Recreation and Park District 9
- Orangevale Recreation and Park District 9
- Fair Oaks Recreation and Park District 9
- Tuolumne Park and Recreation District 8
- …
MNG_AG_TYP 1
- Recreation/Parks District · 931 ✖
LAYER 1 ✖
- Special District 931
ACCESS_TYP 1
- Open Access · 931 ✖
Link | rowid | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37 | 37 | 36 | {"type": "MultiPolygon", "coordinates": [[[[-118.325, 33.74497], [-118.32496, 33.74508], [-118.32486, 33.74519], [-118.32456, 33.74533], [-118.32442, 33.74537], [-118.32395, 33.74543], [-118.32322, 33.74543], [-118.3231, 33.74545], [-118.32306, 33.74525], [-118.32227, 33.74479], [-118.32072, 33.74441], [-118.32074, 33.74434], [-118.32074, 33.74405], [-118.32121, 33.74405], [-118.32221, 33.74426], [-118.32253, 33.74419], [-118.32309, 33.74458], [-118.32347, 33.74443], [-118.32349, 33.74426], [-118.32378, 33.74428], [-118.32388, 33.74432], [-118.32395, 33.74437], [-118.32399, 33.74443], [-118.32399, 33.74446], [-118.32372, 33.74453], [-118.32355, 33.7448], [-118.32364, 33.745], [-118.32437, 33.7452], [-118.3247, 33.74515], [-118.3249, 33.74496], [-118.32482, 33.74477], [-118.32486, 33.74475], [-118.32491, 33.74475], [-118.32498, 33.74479], [-118.325, 33.74486], [-118.325, 33.74497]]], [[[-118.32439, 33.74432], [-118.32422, 33.74439], [-118.3242, 33.7443], [-118.32416, 33.74425], [-118.32407, 33.74417], [-118.32392, 33.74413], [-118.32376, 33.74413], [-118.3239, 33.74396], [-118.32439, 33.74432]]]]} | Open Access 1 | Frascati Trail | 31776 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 5.929 | Frascati Trail | ||
54 | 54 | 53 | {"type": "Polygon", "coordinates": [[[-118.32587, 33.74382], [-118.32587, 33.74461], [-118.32566, 33.74466], [-118.3256, 33.74453], [-118.3255, 33.74455], [-118.32553, 33.74468], [-118.32546, 33.7447], [-118.32526, 33.74439], [-118.3258, 33.74434], [-118.32581, 33.74381], [-118.32587, 33.74382]]]} | Open Access 1 | Frog Pond Park | 31771 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 0.44 | Frog Pond Park | ||
56 | 56 | 55 | {"type": "Polygon", "coordinates": [[[-118.32092, 33.74221], [-118.32011, 33.74356], [-118.32016, 33.74372], [-118.32001, 33.74377], [-118.31988, 33.744], [-118.31997, 33.74414], [-118.32047, 33.74413], [-118.32055, 33.74404], [-118.32057, 33.74405], [-118.32058, 33.74434], [-118.32056, 33.7444], [-118.32044, 33.74452], [-118.32027, 33.74456], [-118.32011, 33.74436], [-118.31968, 33.74442], [-118.3195, 33.74476], [-118.31966, 33.74514], [-118.31998, 33.74517], [-118.32002, 33.74548], [-118.31996, 33.74555], [-118.31991, 33.74557], [-118.31983, 33.74557], [-118.31939, 33.74542], [-118.31919, 33.74477], [-118.3197, 33.74396], [-118.32074, 33.74221], [-118.32092, 33.74221]]]} | Open Access 1 | Harter Park | 31774 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 2.954 | Harter Park | ||
57 | 57 | 56 | {"type": "Polygon", "coordinates": [[[-118.32587, 33.74145], [-118.32586, 33.74173], [-118.32563, 33.74185], [-118.32541, 33.7416], [-118.32474, 33.74161], [-118.32422, 33.74153], [-118.32393, 33.74164], [-118.32391, 33.74158], [-118.32401, 33.74154], [-118.32401, 33.74153], [-118.32329, 33.74095], [-118.32212, 33.74084], [-118.3217, 33.74095], [-118.32093, 33.74221], [-118.32075, 33.74221], [-118.32176, 33.74053], [-118.32318, 33.74066], [-118.32402, 33.74133], [-118.32477, 33.74147], [-118.32587, 33.74145]]]} | Open Access 1 | Colinita Trail | 31775 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 3.142 | Colinita Trail | ||
61 | 61 | 60 | {"type": "MultiPolygon", "coordinates": [[[[-118.32508, 33.74836], [-118.32477, 33.74839], [-118.32442, 33.74858], [-118.3242, 33.74879], [-118.32384, 33.74839], [-118.32179, 33.74742], [-118.32161, 33.74723], [-118.32105, 33.74759], [-118.32094, 33.74748], [-118.32149, 33.74711], [-118.32094, 33.7465], [-118.32031, 33.74623], [-118.3199, 33.74579], [-118.31989, 33.7457], [-118.32, 33.74568], [-118.3201, 33.74562], [-118.32024, 33.74572], [-118.32031, 33.74572], [-118.32038, 33.74575], [-118.32054, 33.74589], [-118.32066, 33.74602], [-118.32075, 33.74605], [-118.32085, 33.74605], [-118.32097, 33.74599], [-118.32102, 33.7459], [-118.32101, 33.74581], [-118.32091, 33.74564], [-118.32093, 33.74564], [-118.32142, 33.74604], [-118.32229, 33.7465], [-118.32269, 33.74631], [-118.32274, 33.74637], [-118.32236, 33.74654], [-118.32235, 33.74656], [-118.32345, 33.74762], [-118.32367, 33.74772], [-118.32395, 33.74742], [-118.32419, 33.74758], [-118.32394, 33.74788], [-118.32439, 33.74816], [-118.32474, 33.74814], [-118.32486, 33.74801], [-118.32498, 33.74812], [-118.32504, 33.74824], [-118.32508, 33.74836]]], [[[-118.32085, 33.74589], [-118.32081, 33.74592], [-118.32078, 33.74592], [-118.32066, 33.74579], [-118.32054, 33.74569], [-118.32074, 33.74566], [-118.32085, 33.74585], [-118.32085, 33.74589]]]]} | Open Access 1 | Sienna Loop Trail | 31777 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 9.939 | Sienna Loop Trail | ||
73 | 73 | 72 | {"type": "MultiPolygon", "coordinates": [[[[-118.31957, 33.74707], [-118.31942, 33.74709], [-118.31936, 33.7467], [-118.3191, 33.74575], [-118.31911, 33.7457], [-118.31924, 33.74568], [-118.31926, 33.7457], [-118.31947, 33.74646], [-118.31954, 33.74679], [-118.31957, 33.74707]]], [[[-118.31996, 33.74921], [-118.31982, 33.74928], [-118.31971, 33.74913], [-118.31966, 33.74901], [-118.31962, 33.74886], [-118.31962, 33.74877], [-118.31968, 33.74836], [-118.31968, 33.74813], [-118.31963, 33.74788], [-118.31952, 33.74756], [-118.31942, 33.74714], [-118.31959, 33.74712], [-118.31963, 33.74737], [-118.31978, 33.74782], [-118.31983, 33.74803], [-118.31984, 33.74831], [-118.3198, 33.74887], [-118.31988, 33.74908], [-118.31996, 33.74921]]], [[[-118.32135, 33.75015], [-118.3213, 33.75029], [-118.32109, 33.75022], [-118.32063, 33.75], [-118.32023, 33.74971], [-118.32002, 33.74952], [-118.31987, 33.74934], [-118.32002, 33.74926], [-118.32025, 33.74952], [-118.32053, 33.74976], [-118.32098, 33.75001], [-118.32135, 33.75015]]], [[[-118.32351, 33.7498], [-118.32345, 33.74985], [-118.32325, 33.74997], [-118.32303, 33.75005], [-118.32211, 33.7503], [-118.32178, 33.75034], [-118.32159, 33.75034], [-118.32137, 33.7503], [-118.32143, 33.75017], [-118.32165, 33.7502], [-118.32191, 33.75019], [-118.32351, 33.7498]]], [[[-118.32508, 33.74962], [-118.32433, 33.74974], [-118.32383, 33.74986], [-118.32381, 33.7498], [-118.32406, 33.74967], [-118.32419, 33.74964], [-118.32504, 33.74949], [-118.32508, 33.74962]]]]} | Open Access 1 | Miraleste Median | 31778 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 3.263 | Miraleste Median | ||
74 | 74 | 73 | {"type": "Polygon", "coordinates": [[[-118.32587, 33.74953], [-118.32572, 33.74942], [-118.32569, 33.74937], [-118.32556, 33.74827], [-118.32549, 33.74805], [-118.32543, 33.74795], [-118.32579, 33.74783], [-118.32587, 33.74783], [-118.32587, 33.74785], [-118.32587, 33.74953]]]} | Open Access 1 | Miltenberger Park | 31779 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 1.103 | Miltenberger Park | ||
75 | 75 | 74 | {"type": "Polygon", "coordinates": [[[-118.319, 33.74614], [-118.31877, 33.74618], [-118.31864, 33.74623], [-118.31846, 33.74607], [-118.31846, 33.74603], [-118.31855, 33.74586], [-118.3188, 33.74581], [-118.31892, 33.74587], [-118.319, 33.74614]]]} | Open Access 1 | Miraleste Park | 31780 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 0.395 | Miraleste Park | ||
76 | 76 | 75 | {"type": "Polygon", "coordinates": [[[-118.32588, 33.7512], [-118.32569, 33.75113], [-118.32582, 33.75079], [-118.32552, 33.75069], [-118.32515, 33.75073], [-118.32511, 33.75097], [-118.32475, 33.75096], [-118.32454, 33.75099], [-118.32427, 33.75107], [-118.32405, 33.75118], [-118.32387, 33.751], [-118.32318, 33.75133], [-118.32271, 33.75141], [-118.32253, 33.75149], [-118.32265, 33.75175], [-118.32264, 33.75176], [-118.32258, 33.75178], [-118.32243, 33.75155], [-118.32134, 33.75207], [-118.32135, 33.75226], [-118.32116, 33.75229], [-118.32107, 33.75233], [-118.32097, 33.75239], [-118.32079, 33.75224], [-118.32044, 33.75241], [-118.31947, 33.75237], [-118.31862, 33.75274], [-118.31877, 33.753], [-118.31873, 33.75321], [-118.31842, 33.75321], [-118.31842, 33.75196], [-118.3186, 33.7517], [-118.31861, 33.7518], [-118.3187, 33.7517], [-118.31875, 33.75173], [-118.31877, 33.75211], [-118.31926, 33.75203], [-118.32016, 33.75204], [-118.32047, 33.75195], [-118.32125, 33.7514], [-118.32161, 33.75107], [-118.32246, 33.75079], [-118.32384, 33.75045], [-118.32372, 33.75006], [-118.32393, 33.75001], [-118.32412, 33.75038], [-118.32457, 33.75026], [-118.32529, 33.75014], [-118.32553, 33.74992], [-118.32587, 33.75017], [-118.32588, 33.7512]]]} | Open Access 1 | Canada Park | 31781 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 13.194 | Canada Park | ||
77 | 77 | 76 | {"type": "Polygon", "coordinates": [[[-118.31871, 33.75148], [-118.3186, 33.75159], [-118.3186, 33.7517], [-118.31842, 33.75196], [-118.31843, 33.74806], [-118.31846, 33.74607], [-118.31864, 33.74623], [-118.31866, 33.74651], [-118.31866, 33.7466], [-118.31862, 33.74662], [-118.31859, 33.75137], [-118.31871, 33.75148]]]} | Open Access 1 | Lorraine Trail | 31782 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 2.558 | Lorraine Trail | ||
109 | 109 | 108 | {"type": "Polygon", "coordinates": [[[-121.9074, 36.56068], [-121.90715, 36.56057], [-121.90645, 36.56038], [-121.9058, 36.56048], [-121.90561, 36.56076], [-121.90567, 36.56101], [-121.9061, 36.56184], [-121.90658, 36.56217], [-121.9069, 36.56188], [-121.90692, 36.5619], [-121.90692, 36.56195], [-121.90682, 36.56207], [-121.90677, 36.56217], [-121.90674, 36.56228], [-121.90673, 36.56241], [-121.90259, 36.56001], [-121.90101, 36.56162], [-121.90195, 36.55734], [-121.90282, 36.55745], [-121.90344, 36.55788], [-121.90366, 36.55858], [-121.90421, 36.55869], [-121.90476, 36.55775], [-121.90484, 36.55822], [-121.90585, 36.55863], [-121.90669, 36.55928], [-121.9074, 36.56068]]]} | Open Access 1 | Hatton Canyon Open Space | 19738 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 34.94 | Hatton Canyon OS | ||
118 | 118 | 117 | {"type": "Polygon", "coordinates": [[[-121.71671, 37.72148], [-121.71669, 37.72289], [-121.71655, 37.72282], [-121.71638, 37.72284], [-121.7163, 37.72283], [-121.71614, 37.72271], [-121.71604, 37.72268], [-121.71589, 37.72271], [-121.7157, 37.7228], [-121.71557, 37.72281], [-121.71548, 37.72278], [-121.71522, 37.72262], [-121.71518, 37.72256], [-121.71517, 37.72242], [-121.71509, 37.72236], [-121.71509, 37.72164], [-121.71547, 37.72166], [-121.71605, 37.72163], [-121.71635, 37.72158], [-121.71671, 37.72148]]]} | Open Access 1 | Altamont Creek Park | 31819 | 2062 | Livermore Area Recreation and Park District 388 | Special District 4 | Recreation/Parks District 4 | http://www.larpd.dst.ca.us/ | Special District 4 | 4.385 | Altamont Creek Park | ||
384 | 384 | 383 | {"type": "Polygon", "coordinates": [[[-121.33204, 38.46376], [-121.33196, 38.46381], [-121.33192, 38.46388], [-121.33192, 38.46393], [-121.33195, 38.46402], [-121.33195, 38.46443], [-121.33194, 38.46446], [-121.3319, 38.46448], [-121.33169, 38.46449], [-121.33126, 38.46455], [-121.33095, 38.46455], [-121.33077, 38.46453], [-121.33071, 38.46454], [-121.33064, 38.46459], [-121.33061, 38.46464], [-121.33059, 38.46469], [-121.33028, 38.46469], [-121.33027, 38.46527], [-121.33022, 38.46521], [-121.33022, 38.46349], [-121.33204, 38.46348], [-121.33204, 38.46376]]]} | Open Access 1 | Bradshaw Vineyards Park | http://www.southgaterecandpark.net/parks-a-facilities/parks-information.html | 31991 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 4.593 | Bradshaw Vineyards Park | |
395 | 395 | 394 | {"type": "MultiPolygon", "coordinates": [[[[-121.32598, 38.45603], [-121.32594, 38.45607], [-121.32592, 38.45613], [-121.32599, 38.45629], [-121.32599, 38.45681], [-121.32597, 38.45684], [-121.32593, 38.45686], [-121.32555, 38.4569], [-121.32531, 38.45695], [-121.32508, 38.45702], [-121.32483, 38.45713], [-121.32478, 38.45712], [-121.32474, 38.4571], [-121.32435, 38.45667], [-121.32427, 38.45652], [-121.3242, 38.45629], [-121.32419, 38.45585], [-121.32572, 38.45585], [-121.32572, 38.45599], [-121.32587, 38.45599], [-121.32598, 38.45603]]], [[[-121.38888, 38.45574], [-121.38855, 38.45575], [-121.38854, 38.45632], [-121.38821, 38.45632], [-121.38824, 38.45615], [-121.38823, 38.4561], [-121.38818, 38.45606], [-121.38807, 38.45602], [-121.38795, 38.45605], [-121.3878, 38.45605], [-121.38776, 38.45603], [-121.38773, 38.456], [-121.38774, 38.4555], [-121.38778, 38.45545], [-121.3883, 38.45546], [-121.38838, 38.45541], [-121.38839, 38.45534], [-121.38846, 38.45534], [-121.38887, 38.45523], [-121.38888, 38.45574]]]]} | Open Access 1 | Calvine Station Park | 31996 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 6.171 | Calvine Station Park | ||
396 | 396 | 395 | {"type": "Polygon", "coordinates": [[[-121.31049, 38.47177], [-121.31046, 38.47182], [-121.31031, 38.47181], [-121.3101, 38.47176], [-121.30978, 38.47163], [-121.3095, 38.47145], [-121.30927, 38.47122], [-121.30927, 38.47117], [-121.3093, 38.47115], [-121.31037, 38.47068], [-121.31044, 38.47071], [-121.3105, 38.4709], [-121.31049, 38.47177]]]} | Open Access 1 | Little Hawke Park | 32000 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2.119 | Little Hawke Park | ||
397 | 397 | 396 | {"type": "Polygon", "coordinates": [[[-121.37598, 38.47607], [-121.37594, 38.47623], [-121.37594, 38.47651], [-121.37591, 38.47673], [-121.3759, 38.47727], [-121.37588, 38.47732], [-121.37583, 38.47733], [-121.3749, 38.47733], [-121.37466, 38.47735], [-121.37462, 38.47733], [-121.37451, 38.47719], [-121.37432, 38.47701], [-121.37433, 38.47696], [-121.37449, 38.47678], [-121.37468, 38.47651], [-121.37478, 38.47621], [-121.3748, 38.4761], [-121.37479, 38.47602], [-121.37516, 38.47603], [-121.37547, 38.47606], [-121.37598, 38.47607]]]} | Open Access 1 | Tamarindo Park | 32001 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 4.11 | Tamarindo Park | ||
439 | 439 | 438 | {"type": "Polygon", "coordinates": [[[-118.73272, 34.24524], [-118.73293, 34.24572], [-118.73331, 34.24643], [-118.73337, 34.24665], [-118.73338, 34.24681], [-118.73335, 34.24694], [-118.73328, 34.24717], [-118.73317, 34.24728], [-118.73302, 34.24738], [-118.73275, 34.24747], [-118.73251, 34.24754], [-118.73204, 34.2476], [-118.73189, 34.24704], [-118.73181, 34.24642], [-118.73194, 34.24607], [-118.73206, 34.24583], [-118.73237, 34.2458], [-118.73224, 34.24532], [-118.73272, 34.24524]]]} | Open Access 1 | Runkle Canyon Park | http://www.rsrpd.org/simi_valley/parks/runkle_canyon_park.php | 33497 | 2118 | Rancho Simi Recreation and Park District 78 | Special District 4 | Recreation/Parks District 4 | http://www.rsrpd.org/ | Special District 4 | 6.424 | Runkle Canyon Park | |
485 | 485 | 484 | {"type": "Polygon", "coordinates": [[[-117.25211, 34.38399], [-117.25224, 34.38434], [-117.25234, 34.38472], [-117.25239, 34.38511], [-117.25239, 34.3855], [-117.25228, 34.38688], [-117.25223, 34.38719], [-117.25212, 34.38763], [-117.25199, 34.38794], [-117.25184, 34.38824], [-117.25142, 34.38807], [-117.24953, 34.38869], [-117.24644, 34.39464], [-117.24169, 34.39943], [-117.24162, 34.3841], [-117.24424, 34.38408], [-117.24545, 34.38678], [-117.24655, 34.38679], [-117.24659, 34.38405], [-117.25211, 34.38399]]]} | Open Access 1 | Hesperia Lake Park | http://www.hesperiaparks.com/hesperia-lake-park/ | 4453 | 2227 | Hesperia Recreation and Park District 598 | Special District 4 | Recreation/Parks District 4 | http://www.hesperiaparks.com/ | Special District 4 | 233.919 | Hesperia Lake Park | |
491 | 491 | 490 | {"type": "Polygon", "coordinates": [[[-118.54882, 35.10774], [-118.5476, 35.10772], [-118.54761, 35.10932], [-118.54171, 35.10939], [-118.53673, 35.10941], [-118.53685, 35.10216], [-118.53716, 35.10216], [-118.53732, 35.10211], [-118.53737, 35.10207], [-118.54645, 35.102], [-118.54871, 35.10379], [-118.54882, 35.10774]]]} | Open Access 1 | Brite Lake Park | http://www.tvrpd.org/parks-facilities/brite-lake.html | 3488 | 2164 | Tehachapi Valley Recreation and Parks District 723 | Special District 4 | Recreation/Parks District 4 | http://www.tvrpd.org/ | Special District 4 | 209.842 | Brite Lake Park | |
576 | 576 | 575 | {"type": "Polygon", "coordinates": [[[-119.02281, 34.23312], [-119.02272, 34.23323], [-119.02237, 34.23354], [-119.02196, 34.23332], [-119.02167, 34.2331], [-119.02139, 34.23282], [-119.0212, 34.23254], [-119.02281, 34.23253], [-119.02281, 34.23312]]]} | Open Access 1 | Adolfo Park | 15274 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 2.698 | Adolfo Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);