units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
110 rows where COUNTY = 10 and MNG_AG_TYP = 4 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, MNG_AG_ID, YR_EST, GAP_STS
DES_TP 6
MNG_AGENCY 5
ACCESS_TYP 2
- Open Access 108
- Restricted Access 2
MNG_AG_TYP 1
- Recreation/Parks District · 110 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16385 | 16385 | 16384 | {"type": "Polygon", "coordinates": [[[-117.42159, 33.98048], [-117.42081, 33.98144], [-117.41987, 33.9818], [-117.41783, 33.98249], [-117.41783, 33.98251], [-117.41846, 33.98293], [-117.41668, 33.98402], [-117.4151, 33.98494], [-117.41511, 33.98495], [-117.41679, 33.98621], [-117.41677, 33.98622], [-117.41647, 33.98611], [-117.41616, 33.98602], [-117.41589, 33.98597], [-117.41561, 33.98594], [-117.41415, 33.98593], [-117.41401, 33.98606], [-117.4138, 33.98591], [-117.41345, 33.9859], [-117.41311, 33.98586], [-117.41278, 33.9858], [-117.41244, 33.98569], [-117.41217, 33.98558], [-117.41188, 33.98542], [-117.40831, 33.98323], [-117.40796, 33.98304], [-117.40754, 33.98284], [-117.40716, 33.98271], [-117.40677, 33.9826], [-117.40638, 33.98252], [-117.40581, 33.98246], [-117.40524, 33.98246], [-117.4046, 33.98253], [-117.40404, 33.98265], [-117.40351, 33.98283], [-117.40295, 33.98309], [-117.40268, 33.98325], [-117.40243, 33.98342], [-117.40202, 33.98376], [-117.40249, 33.98324], [-117.40324, 33.98249], [-117.40376, 33.98201], [-117.40431, 33.98155], [-117.40525, 33.98081], [-117.40543, 33.98095], [-117.40598, 33.98057], [-117.40598, 33.98055], [-117.40584, 33.98039], [-117.40712, 33.97953], [-117.40517, 33.97713], [-117.4044, 33.97762], [-117.40329, 33.97839], [-117.40257, 33.97893], [-117.40154, 33.97979], [-117.40088, 33.98038], [-117.39995, 33.9813], [-117.39801, 33.98342], [-117.40257, 33.97667], [-117.40275, 33.97634], [-117.40381, 33.97674], [-117.40711, 33.97636], [-117.40986, 33.97527], [-117.41045, 33.97568], [-117.41297, 33.97467], [-117.41986, 33.97931], [-117.41979, 33.97937], [-117.41979, 33.97939], [-117.42056, 33.97987], [-117.42099, 33.98007], [-117.42159, 33.98048]]]} | Open Access 1 | 30003 | Ranch Jurupa Regional Park | 9395 | 2123 | Riverside County Regional Park and Open Space District 262 | Special District 4 | Recreation/Parks District 4 | http://www.riversidecountyparks.org/ | Special District 4 | 2123 | Riverside County Regional Park and Open Space District 258 | Special District 4 | Recreation/Parks District 4 | http://www.rivcoparks.org/parks/rancho-jurupa/rancho-jurupa-park-home/ | Riverside 10 | 309.352 | Ranch Jurupa RP | 0 | Local Park 2 | 4 |
15591 | 15591 | 15590 | {"type": "Polygon", "coordinates": [[[-117.30212, 33.52516], [-117.30028, 33.52911], [-117.29792, 33.53406], [-117.29703, 33.53775], [-117.29677, 33.53867], [-117.29553, 33.54139], [-117.29365, 33.54205], [-117.29295, 33.54294], [-117.28821, 33.54579], [-117.28777, 33.54435], [-117.28727, 33.54342], [-117.2852, 33.54184], [-117.28378, 33.54002], [-117.28221, 33.53975], [-117.27324, 33.54364], [-117.27138, 33.54321], [-117.2717, 33.54223], [-117.27183, 33.54172], [-117.27195, 33.54103], [-117.27201, 33.54033], [-117.27209, 33.53702], [-117.27206, 33.53615], [-117.27192, 33.53432], [-117.27192, 33.53403], [-117.27197, 33.53357], [-117.27205, 33.53314], [-117.27267, 33.53064], [-117.27278, 33.53023], [-117.27297, 33.52969], [-117.27346, 33.52855], [-117.27706, 33.52778], [-117.27748, 33.52772], [-117.27781, 33.5277], [-117.27813, 33.52771], [-117.27977, 33.52793], [-117.28008, 33.52795], [-117.28038, 33.52794], [-117.28039, 33.52793], [-117.2807, 33.5279], [-117.28101, 33.52785], [-117.28201, 33.5276], [-117.28234, 33.52753], [-117.28272, 33.52749], [-117.2831, 33.52748], [-117.28584, 33.5276], [-117.28614, 33.52763], [-117.28646, 33.52768], [-117.28692, 33.52781], [-117.28726, 33.52796], [-117.28882, 33.52881], [-117.28926, 33.529], [-117.28963, 33.5291], [-117.29, 33.52916], [-117.29044, 33.52918], [-117.29083, 33.52916], [-117.29109, 33.52913], [-117.29141, 33.52905], [-117.29181, 33.52892], [-117.29205, 33.52881], [-117.29233, 33.52865], [-117.29254, 33.5285], [-117.29273, 33.52834], [-117.29291, 33.52817], [-117.29315, 33.52786], [-117.2933, 33.52762], [-117.29422, 33.52577], [-117.29437, 33.5255], [-117.29462, 33.52513], [-117.29514, 33.52451], [-117.29576, 33.5249], [-117.296, 33.525], [-117.2964, 33.52509], [-117.29671, 33.5251], [-117.29697, 33.52508], [-117.29806, 33.52484], [-117.29827, 33.52483], [-117.29844, 33.52484], [-117.29873, 33.52491], [-117.29901, 33.52503], [-117.29924, 33.52519], [-117.29937, 33.52531], [-117.29972, 33.52575], [-117.29988, 33.52589], [-117.30011, 33.52601], [-117.30029, 33.52607], [-117.30048, 33.52609], [-117.30067, 33.5261], [-117.30082, 33.52608], [-117.30097, 33.52604], [-117.30117, 33.52596], [-117.30141, 33.52579], [-117.30185, 33.52533], [-117.30212, 33.52516]]]} | Open Access 1 | 12824 | Santa Rosa Plateau Ecological Reserve | 9398 | 2123 | Riverside County Regional Park and Open Space District 262 | Special District 4 | Recreation/Parks District 4 | http://www.riversidecountyparks.org/ | Special District 4 | 2123 | Riverside County Regional Park and Open Space District 258 | Special District 4 | Recreation/Parks District 4 | http://www.rivcoparks.org/education/santa-rosa-plateau/santa-rosa-plateau/ | Riverside 10 | 986.313 | Santa Rosa Plateau ER | 1994 | Local Conservation Area 4 | 2 |
1590 | 1590 | 1589 | {"type": "Polygon", "coordinates": [[[-117.47515, 34.00095], [-117.47513, 34.00167], [-117.47122, 34.00165], [-117.47122, 34.00115], [-117.4713, 34.00114], [-117.4713, 34.00095], [-117.47179, 34.00095], [-117.4718, 34.00091], [-117.47184, 34.0009], [-117.47184, 34.00052], [-117.47179, 34.00051], [-117.47179, 34.00047], [-117.47226, 34.00036], [-117.47229, 34.00042], [-117.4726, 34.00035], [-117.47259, 34.00028], [-117.47323, 34.00012], [-117.47323, 34.00094], [-117.47515, 34.00095]]]} | Open Access 1 | 12150 | Agate Park | 15285 | 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 | 9.349 | Agate Park | 0 | Local Park 2 | 4 | |
14076 | 14076 | 14075 | {"type": "Polygon", "coordinates": [[[-117.15686, 33.69873], [-117.15685, 33.69915], [-117.1563, 33.69916], [-117.15626, 33.69919], [-117.15628, 33.69997], [-117.15634, 33.70004], [-117.15639, 33.70004], [-117.1564, 33.70034], [-117.15589, 33.70031], [-117.15545, 33.70012], [-117.15443, 33.69945], [-117.15435, 33.69919], [-117.15465, 33.69866], [-117.15483, 33.69828], [-117.15493, 33.69823], [-117.15632, 33.69856], [-117.15633, 33.69861], [-117.15637, 33.69863], [-117.15674, 33.69872], [-117.15686, 33.69873]]]} | Open Access 1 | 39114 | Aldergate Park | 15348 | 2171 | Valley-Wide Recreation and Park District 160 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 8.124 | Aldergate Park | 0 | Local Park 2 | 4 | |
14071 | 14071 | 14070 | {"type": "Polygon", "coordinates": [[[-117.16253, 33.66383], [-117.16252, 33.66493], [-117.16247, 33.66497], [-117.16218, 33.66497], [-117.16213, 33.66493], [-117.16211, 33.66466], [-117.16205, 33.66446], [-117.16195, 33.66425], [-117.16181, 33.66408], [-117.16181, 33.66403], [-117.16204, 33.6639], [-117.1621, 33.66382], [-117.16253, 33.66383]]]} | Open Access 1 | 39108 | Autumn Breeze Park | 15715 | 2171 | Valley-Wide Recreation and Park District 160 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 1.484 | Autumn Breeze Park | 0 | Local Park 2 | 4 | |
6859 | 6859 | 6858 | {"type": "Polygon", "coordinates": [[[-117.39388, 34.01558], [-117.39303, 34.01723], [-117.39281, 34.01754], [-117.39105, 34.01644], [-117.39205, 34.01531], [-117.39225, 34.01543], [-117.39257, 34.01508], [-117.39254, 34.01505], [-117.39262, 34.0148], [-117.39388, 34.01558]]]} | Open Access 1 | 5493 | Avalon Park | 15722 | 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 | http://www.ssf.net/377/Parks-Recreation | Riverside 10 | 10.008 | Avalon Park | 0 | Local Park 2 | 4 |
5547 | 5547 | 5546 | {"type": "Polygon", "coordinates": [[[-116.91484, 33.75491], [-116.91479, 33.75495], [-116.91369, 33.75495], [-116.91368, 33.75334], [-116.9141, 33.7533], [-116.91482, 33.7533], [-116.91484, 33.75491]]]} | Open Access 1 | 39087 | Bill Gray Park | 16105 | 2171 | Valley-Wide Recreation and Park District 160 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 4.762 | Bill Gray Park | 0 | Local Park 2 | 4 | |
1421 | 1421 | 1420 | {"type": "Polygon", "coordinates": [[[-117.47044, 34.01823], [-117.46999, 34.0192], [-117.46848, 34.01888], [-117.46878, 34.0179], [-117.47044, 34.01823]]]} | Open Access 1 | 9051 | Boulder Hill Park | 16296 | 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 | 4.195 | Boulder Hill Park | 0 | Local Park 2 | 4 | |
3242 | 3242 | 3241 | {"type": "Polygon", "coordinates": [[[-116.40815, 33.71547], [-116.40162, 33.71552], [-116.40161, 33.71553], [-116.40039, 33.71552], [-116.39994, 33.71426], [-116.39994, 33.7139], [-116.40007, 33.71412], [-116.40008, 33.71415], [-116.40812, 33.71417], [-116.40815, 33.71547]]]} | Open Access 1 | 13235 | Cahuilla Hills Park | 16662 | 1240 | Palm Desert, City of 215 | City 2 | City Agency 2 | http://www.cityofpalmdesert.org/Index.aspx?page=174 | City 2 | 2216 | Desert Recreation District 282 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 27.295 | Cahuilla Hills Park | 0 | Local Park 2 | 4 | |
14555 | 14555 | 14554 | {"type": "Polygon", "coordinates": [[[-117.55619, 33.9885], [-117.55587, 33.98861], [-117.55562, 33.9881], [-117.55595, 33.98799], [-117.55619, 33.9885]]]} | Open Access 1 | 44680 | Cambria Park | 16750 | 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.491 | Cambria Park | 0 | Local Park 2 | 4 | |
1583 | 1583 | 1582 | {"type": "Polygon", "coordinates": [[[-117.44667, 34.00615], [-117.44289, 34.00706], [-117.44289, 34.00515], [-117.44331, 34.00483], [-117.44348, 34.00473], [-117.44506, 34.00402], [-117.44583, 34.0036], [-117.44659, 34.00317], [-117.44661, 34.00468], [-117.44667, 34.00615]]]} | Open Access 1 | 12177 | Centennial Park | 17032 | 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 | 23.351 | Centennial Park | 0 | Local Park 2 | 4 | |
8113 | 8113 | 8112 | {"type": "Polygon", "coordinates": [[[-117.4594, 33.9728], [-117.45935, 33.97284], [-117.45884, 33.97285], [-117.45849, 33.97291], [-117.45815, 33.97305], [-117.45777, 33.97331], [-117.45771, 33.97331], [-117.45756, 33.97315], [-117.45746, 33.97301], [-117.45737, 33.97282], [-117.45733, 33.97265], [-117.45732, 33.97245], [-117.45742, 33.97147], [-117.45748, 33.97143], [-117.45792, 33.97147], [-117.45815, 33.97145], [-117.45844, 33.9714], [-117.45849, 33.97143], [-117.45857, 33.97166], [-117.45867, 33.97182], [-117.4588, 33.97196], [-117.45905, 33.97217], [-117.45924, 33.97239], [-117.45934, 33.9726], [-117.4594, 33.9728]]]} | Open Access 1 | 12271 | Clay Park | 17399 | 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 | 6.49 | Clay Park | 0 | Local Park 2 | 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 | |
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 | |
16960 | 16960 | 16959 | {"type": "Polygon", "coordinates": [[[-116.29414, 33.63314], [-116.29374, 33.63312], [-116.29303, 33.63303], [-116.29229, 33.63274], [-116.29198, 33.6328], [-116.29181, 33.63296], [-116.29177, 33.63273], [-116.29161, 33.63256], [-116.29145, 33.63266], [-116.29156, 33.6332], [-116.2917, 33.63327], [-116.29175, 33.63341], [-116.29154, 33.63335], [-116.29091, 33.63264], [-116.29061, 33.6326], [-116.2906, 33.63261], [-116.29062, 33.6329], [-116.29086, 33.63326], [-116.2908, 33.63331], [-116.28992, 33.63292], [-116.28859, 33.63282], [-116.28847, 33.63297], [-116.28825, 33.6329], [-116.28798, 33.63302], [-116.2879, 33.63307], [-116.28777, 33.63302], [-116.28763, 33.63324], [-116.28748, 33.63326], [-116.28757, 33.63265], [-116.28734, 33.63194], [-116.287, 33.6318], [-116.28664, 33.63125], [-116.28663, 33.63084], [-116.28641, 33.63086], [-116.28628, 33.63084], [-116.28539, 33.63048], [-116.2853, 33.62754], [-116.29396, 33.62747], [-116.29354, 33.62749], [-116.29358, 33.62755], [-116.29385, 33.62779], [-116.29385, 33.62785], [-116.29324, 33.62779], [-116.29306, 33.62806], [-116.29306, 33.62825], [-116.29344, 33.62838], [-116.29369, 33.62858], [-116.29376, 33.62868], [-116.29324, 33.6286], [-116.29315, 33.62898], [-116.29256, 33.62915], [-116.29256, 33.62926], [-116.29306, 33.62973], [-116.2932, 33.62982], [-116.29318, 33.62999], [-116.29412, 33.63079], [-116.29414, 33.63314]]]} | Open Access 1 | 24264 | Coral Mountain Regional Park | 17631 | 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 | 104.632 | Coral Mtn. RP | 0 | Local Park 2 | 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 | |
14074 | 14074 | 14073 | {"type": "Polygon", "coordinates": [[[-117.15164, 33.6899], [-117.15158, 33.69017], [-117.15137, 33.69015], [-117.1511, 33.69024], [-117.15102, 33.69011], [-117.15102, 33.69006], [-117.15117, 33.68993], [-117.15129, 33.68976], [-117.15164, 33.6899]]]} | Open Access 1 | 39111 | Desert Green | 18111 | 2171 | Valley-Wide Recreation and Park District 160 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 0.454 | Desert Green | 0 | Local Park 2 | 4 | |
3472 | 3472 | 3471 | {"type": "Polygon", "coordinates": [[[-116.97601, 33.97243], [-116.97466, 33.97406], [-116.97417, 33.97481], [-116.97355, 33.97529], [-116.97366, 33.97499], [-116.97373, 33.97474], [-116.97393, 33.97458], [-116.9744, 33.97369], [-116.97556, 33.97245], [-116.97558, 33.97244], [-116.97601, 33.97243]]]} | Open Access 1 | 25787 | Edgar Canyon Nature Park | 18432 | 2205 | Beaumont-Cherry Valley Recreation and Park District 646 | Special District 4 | Recreation/Parks District 4 | http://www.bcvparks.com/ | Special District 4 | 2205 | Beaumont-Cherry Valley Recreation and Park District 636 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 3.121 | Edgar Canyon Nature Park | 0 | Local Park 2 | 4 | |
14077 | 14077 | 14076 | {"type": "Polygon", "coordinates": [[[-117.14763, 33.70309], [-117.14757, 33.70315], [-117.14622, 33.70314], [-117.14544, 33.70307], [-117.14539, 33.70302], [-117.14538, 33.70279], [-117.14577, 33.70264], [-117.14604, 33.70252], [-117.14638, 33.70233], [-117.14665, 33.70216], [-117.1468, 33.70229], [-117.14703, 33.70238], [-117.1471, 33.70244], [-117.14715, 33.70251], [-117.14719, 33.70262], [-117.14724, 33.70309], [-117.14763, 33.70309]]]} | Open Access 1 | 39115 | Eldorado Park | 18552 | 2171 | Valley-Wide Recreation and Park District 160 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 3.128 | Eldorado Park | 0 | Local Park 2 | 4 | |
14090 | 14090 | 14089 | {"type": "Polygon", "coordinates": [[[-117.14793, 33.70508], [-117.14765, 33.70532], [-117.14748, 33.70518], [-117.14733, 33.70503], [-117.14766, 33.70484], [-117.14793, 33.70508]]]} | Open Access 1 | 39119 | Eldorado Pocket Park | 18553 | 2171 | Valley-Wide Recreation and Park District 160 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 0.371 | Eldorado PP | 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]);