units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- California Department of Parks and Recreation 212
- California Department of Fish and Wildlife 186
- San Diego, City of 128
- Mountains Recreation and Conservation Authority 114
- Los Angeles, City of 96
- Ventura, City of 96
- East Bay Regional Park District 92
- Los Angeles, County of 58
- United States Fish and Wildlife Service 58
- California State Lands Commission 57
- Long Beach, City of 54
- Roseville, City of 47
- Butte, County of 44
- Poway, City of 43
- United States Forest Service 38
- Irvine, City of 38
- Midpeninsula Regional Open Space District 37
- Orange, County of 36
- Lake, County of 32
- San Jose, City of 31
- San Diego, County of 31
- El Dorado, County of 31
- United States National Park Service 30
- Torrance, City of 30
- Conejo Open Space Conservation Agency 29
- Yuba County Water Agency 28
- San Ramon, City of 26
- Sunrise Recreation and Park District 26
- Valley-Wide Recreation and Park District 25
- Davis, City of 25
- …
DES_TP >30
- Local Park 1,383
- Local Recreation Area 780
- Local Other or Unknown 668
- State Conservation Area 184
- Local Conservation Area 182
- Private Conservation 155
- Private Recreation or Education 131
- State Park 124
- State Resource Management Area 68
- State Recreation Area 64
- National Wildlife Refuge 53
- State Historic or Cultural Area 37
- National Forest 36
- Recreation Management Area 20
- National Monument or Landmark 18
- State Other or Unknown 15
- National Recreation Area 12
- National Public Lands 11
- National Park 11
- Conservation Area 8
- Private Other or Unknown 8
- Local Historic or Cultural Area 6
- Private Agricultural 6
- Federal Other or Unknown 5
- Resource Management Area 3
- Historic or Cultural Area 3
- Local Resource Management Area 2
- Wilderness Area 1
- State Wilderness 1
- Area of Critical Environmental Concern 1
- …
MNG_AG_TYP 28
- City Agency 2,190
- State Agency 517
- County Agency 350
- Recreation/Parks District 348
- Federal Agency 172
- Open Space District 152
- Non Profit - Land Trust 130
- Home Owners Association 107
- Water District 70
- County Agency - Parks 65
- Non Profit - Conservation 62
- Community Services District 41
- Flood District 38
- Non Profit - Other 11
- Irrigation District 7
- Commercial 7
- School District 6
- County Agency - Other 5
- Transportation Agency 5
- Special District - Other 4
- Cemetery District 3
- Joint Powers Authority 3
- Other 3
- Port/Harbor District 2
- Sanitation District 2
- Mitigation Bank 2
- Conservation District 2
- Non Profit - Education 1
ACCESS_TYP 4
- Open Access 3,400
- Restricted Access 492
- No Public Access 265
- Unknown Access 148
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12764 | 12764 | 12763 | {"type": "Polygon", "coordinates": [[[-121.64045, 37.10439], [-121.64031, 37.10449], [-121.6399, 37.1043], [-121.63994, 37.10411], [-121.63996, 37.10391], [-121.63997, 37.10388], [-121.64001, 37.10386], [-121.64056, 37.10383], [-121.64063, 37.10385], [-121.64065, 37.1039], [-121.64062, 37.10398], [-121.64056, 37.10414], [-121.64046, 37.10431], [-121.64045, 37.10439]]]} | Open Access 1 | 29866 | Mill Creek Park | 22225 | 1217 | Morgan Hill, City of 416 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | Santa Clara 19 | 0.854 | Mill Creek Park | 0 | Local Park 2 | 4 | |
12765 | 12765 | 12764 | {"type": "Polygon", "coordinates": [[[-121.6469, 37.13309], [-121.64667, 37.13327], [-121.64624, 37.13293], [-121.6465, 37.13273], [-121.6468, 37.13287], [-121.64679, 37.13293], [-121.6468, 37.13298], [-121.64682, 37.13303], [-121.6469, 37.13309]]]} | Open Access 1 | 29867 | Belle Estates Park | 15983 | 1217 | Morgan Hill, City of 416 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | Santa Clara 19 | 0.451 | Belle Estates Park | 0 | Local Park 2 | 4 | |
12766 | 12766 | 12765 | {"type": "Polygon", "coordinates": [[[-121.66244, 37.12502], [-121.66156, 37.1255], [-121.66085, 37.12469], [-121.66099, 37.12461], [-121.66139, 37.12504], [-121.66161, 37.12494], [-121.66161, 37.12492], [-121.66121, 37.12449], [-121.66172, 37.12421], [-121.66186, 37.12436], [-121.6615, 37.12455], [-121.66175, 37.12485], [-121.66211, 37.12466], [-121.66244, 37.12502]]]} | Open Access 1 | 29868 | Civic Centre/City Hall | 17371 | 1217 | Morgan Hill, City of 416 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | Santa Clara 19 | 1.842 | Civic Centre/City Hall | None 1119 | |||
12767 | 12767 | 12766 | {"type": "Polygon", "coordinates": [[[-121.66901, 37.14031], [-121.66901, 37.14031], [-121.66891, 37.14072], [-121.66879, 37.1406], [-121.66882, 37.14057], [-121.66865, 37.14041], [-121.66888, 37.14025], [-121.66894, 37.14029], [-121.66901, 37.14031]]]} | Open Access 1 | 29869 | Fox Hollow Park | 19033 | 1217 | Morgan Hill, City of 416 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | Santa Clara 19 | 0.201 | Fox Hollow Park | 0 | Local Park 2 | 4 | |
12768 | 12768 | 12767 | {"type": "Polygon", "coordinates": [[[-121.67256, 37.14164], [-121.6723, 37.14182], [-121.67205, 37.14183], [-121.67193, 37.1418], [-121.67196, 37.14175], [-121.67196, 37.14169], [-121.67191, 37.14163], [-121.67184, 37.1416], [-121.67222, 37.14133], [-121.67256, 37.14164]]]} | Open Access 1 | 29870 | Murphy Spring Park | 22610 | 1217 | Morgan Hill, City of 416 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | Santa Clara 19 | 0.498 | Murphy Spring Park | 0 | Local Park 2 | 4 | |
12769 | 12769 | 12768 | {"type": "MultiPolygon", "coordinates": [[[[-117.44904, 33.97183], [-117.4458, 33.97245], [-117.44529, 33.97253], [-117.44488, 33.97256], [-117.44443, 33.97256], [-117.44384, 33.97253], [-117.44296, 33.97243], [-117.44238, 33.97232], [-117.44195, 33.97221], [-117.44112, 33.97194], [-117.44033, 33.9716], [-117.43995, 33.97141], [-117.43958, 33.97119], [-117.43981, 33.97116], [-117.43939, 33.9709], [-117.43904, 33.97065], [-117.43597, 33.96811], [-117.43615, 33.9676], [-117.43614, 33.96686], [-117.44694, 33.96686], [-117.44696, 33.96596], [-117.44747, 33.96596], [-117.44772, 33.96682], [-117.4477, 33.9676], [-117.44795, 33.9676], [-117.4483, 33.96878], [-117.44755, 33.96894], [-117.44754, 33.96895], [-117.44766, 33.96929], [-117.44829, 33.96944], [-117.44846, 33.97004], [-117.44841, 33.97003], [-117.4484, 33.97005], [-117.44904, 33.97183]]], [[[-117.46554, 33.96612], [-117.46487, 33.96657], [-117.46133, 33.9671], [-117.4598, 33.96673], [-117.45629, 33.96732], [-117.45361, 33.96876], [-117.45364, 33.97094], [-117.44952, 33.97174], [-117.44948, 33.97161], [-117.45044, 33.97142], [-117.45045, 33.97141], [-117.44992, 33.96996], [-117.44927, 33.97012], [-117.44899, 33.97009], [-117.44862, 33.96882], [-117.44845, 33.96884], [-117.44823, 33.96808], [-117.44825, 33.96761], [-117.44879, 33.9676], [-117.44883, 33.96597], [-117.44914, 33.96596], [-117.44915, 33.96506], [-117.4536, 33.96509], [-117.4536, 33.96586], [-117.45469, 33.96588], [-117.45823, 33.9649], [-117.45938, 33.96494], [-117.46012, 33.96429], [-117.46308, 33.96265], [-117.46429, 33.96193], [-117.46485, 33.96213], [-117.465, 33.96251], [-117.46512, 33.96287], [-117.46526, 33.96344], [-117.46553, 33.96548], [-117.46541, 33.9655], [-117.46554, 33.96612]]]]} | Open Access 1 | 30002 | Santa Ana River Wildlife Area | 29297 | 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 | https://riversideca.gov/publicworks/traffic/bicycleprogram/pdf/santa-ana-river-trail-map.pdf | Riverside 10 | 302.432 | Santa Ana River Wildlife Area | 0 | Local Conservation Area 4 | 2 |
12770 | 12770 | 12769 | {"type": "Polygon", "coordinates": [[[-117.78119, 33.73044], [-117.78104, 33.7306], [-117.78064, 33.73033], [-117.78042, 33.73055], [-117.78042, 33.73057], [-117.78053, 33.73064], [-117.78014, 33.73105], [-117.78022, 33.73111], [-117.78025, 33.73115], [-117.78031, 33.73116], [-117.78044, 33.73125], [-117.7804, 33.73129], [-117.78037, 33.73128], [-117.77951, 33.73068], [-117.78034, 33.72981], [-117.78073, 33.73007], [-117.78074, 33.73012], [-117.78071, 33.7302], [-117.78071, 33.73029], [-117.78074, 33.73036], [-117.78079, 33.73042], [-117.78088, 33.73047], [-117.78098, 33.73049], [-117.78109, 33.73048], [-117.78119, 33.73044]]]} | Open Access 1 | 30202 | Homestead Park | 20063 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 2.07 | Homestead Park | 0 | Local Park 2 | 4 | |
12771 | 12771 | 12770 | {"type": "Polygon", "coordinates": [[[-117.99435, 33.87165], [-117.99397, 33.87165], [-117.99397, 33.87136], [-117.99435, 33.87136], [-117.99435, 33.87165]]]} | Open Access 1 | 30326 | Lindergh Mini Park | 21296 | 1037 | Buena Park, City of 136 | City 2 | City Agency 2 | http://www.buenapark.com/ | City 2 | 1037 | Buena Park, City of 133 | City 2 | City Agency 2 | Orange 3 | 0.28 | Lindergh MP | 0 | Local Park 2 | 4 | |
12772 | 12772 | 12771 | {"type": "Polygon", "coordinates": [[[-117.82719, 33.63112], [-117.82621, 33.63118], [-117.82627, 33.63102], [-117.82636, 33.63057], [-117.82638, 33.63043], [-117.82687, 33.6304], [-117.82712, 33.63051], [-117.82719, 33.63112]]]} | Open Access 1 | 30203 | Sepulveda Vista Point | 25308 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 1.538 | Sepulveda Vista Point | None 1120 | |||
12773 | 12773 | 12772 | {"type": "Polygon", "coordinates": [[[-117.81919, 33.69143], [-117.81815, 33.69225], [-117.81662, 33.69096], [-117.81635, 33.69067], [-117.81731, 33.68984], [-117.81919, 33.69143]]]} | Open Access 1 | 30204 | Sweet Shade Park | 26103 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 8.023 | Sweet Shade Park | 0 | Local Park 2 | 4 | |
12774 | 12774 | 12773 | {"type": "Polygon", "coordinates": [[[-118.36219, 33.85184], [-118.36169, 33.85181], [-118.36169, 33.85167], [-118.36213, 33.85167], [-118.36219, 33.85184]]]} | No Public Access 3 | 35837 | Entradero Swale 4 | 29148 | 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 | Los Angeles 6 | 0.181 | Entradero Swale 4 | None 1121 | |||
12775 | 12775 | 12774 | {"type": "Polygon", "coordinates": [[[-117.77984, 33.71541], [-117.7783, 33.71699], [-117.778, 33.7168], [-117.77748, 33.71643], [-117.7774, 33.71635], [-117.77685, 33.71596], [-117.77684, 33.71585], [-117.77761, 33.7151], [-117.77826, 33.71441], [-117.77841, 33.7144], [-117.77924, 33.71497], [-117.7794, 33.715], [-117.7794, 33.7151], [-117.77984, 33.71541]]]} | Open Access 1 | 30205 | David Sills Lower Peters Canyon Park | 28280 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.cityofirvine.org/cityhall/cs/commparks/cparks/cparks_peters.asp | Orange 3 | 10.266 | David Sills Lower Peters Canyon Park | 0 | Local Park 2 | 4 |
12776 | 12776 | 12775 | {"type": "Polygon", "coordinates": [[[-117.83103, 33.66472], [-117.831, 33.66473], [-117.8309, 33.665], [-117.83032, 33.66485], [-117.83023, 33.66356], [-117.83051, 33.66373], [-117.83055, 33.66447], [-117.83101, 33.66446], [-117.83103, 33.66472]]]} | Open Access 1 | 30206 | Rancho San Joaquin Community Park | 24172 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 1.363 | Rancho San Joaquin Community Park | 0 | Local Park 2 | 4 | |
12777 | 12777 | 12776 | {"type": "Polygon", "coordinates": [[[-117.83103, 33.62905], [-117.83102, 33.62906], [-117.83101, 33.62912], [-117.83073, 33.62961], [-117.83048, 33.63027], [-117.83044, 33.63047], [-117.83041, 33.63077], [-117.8304, 33.6311], [-117.83043, 33.63125], [-117.83037, 33.63131], [-117.82867, 33.63141], [-117.82856, 33.63136], [-117.82848, 33.63049], [-117.82867, 33.63048], [-117.82872, 33.63121], [-117.82922, 33.63119], [-117.82922, 33.63113], [-117.82936, 33.63111], [-117.82926, 33.63032], [-117.82813, 33.63036], [-117.82875, 33.62809], [-117.82877, 33.6279], [-117.82917, 33.62804], [-117.82975, 33.62831], [-117.82976, 33.62837], [-117.82993, 33.62847], [-117.83003, 33.62847], [-117.83103, 33.62905]]]} | Open Access 1 | 30207 | Las Lomas Community Park | 21056 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 15.412 | Las Lomas Community Park | 0 | Local Park 2 | 4 | |
12778 | 12778 | 12777 | {"type": "Polygon", "coordinates": [[[-117.95117, 33.70777], [-117.95117, 33.70828], [-117.9504, 33.70829], [-117.9504, 33.70816], [-117.95045, 33.70811], [-117.95045, 33.70804], [-117.95053, 33.70803], [-117.95052, 33.70786], [-117.95105, 33.70785], [-117.95106, 33.70777], [-117.95117, 33.70777]]]} | Open Access 1 | 30225 | Heritage Park | 19849 | 1111 | Fountain Valley, City of 273 | City 2 | City Agency 2 | http://www.fountainvalley.org/visitors/parks/ | City 2 | 1111 | Fountain Valley, City of 268 | City 2 | City Agency 2 | Orange 3 | 0.803 | Heritage Park | 0 | Local Park 2 | 4 | |
12779 | 12779 | 12778 | {"type": "Polygon", "coordinates": [[[-117.96694, 33.71308], [-117.96687, 33.7135], [-117.96635, 33.71351], [-117.96633, 33.71282], [-117.96691, 33.71281], [-117.96691, 33.713], [-117.96694, 33.71308]]]} | Open Access 1 | 30226 | McDowell Park | 22026 | 1111 | Fountain Valley, City of 273 | City 2 | City Agency 2 | http://www.fountainvalley.org/visitors/parks/ | City 2 | 1111 | Fountain Valley, City of 268 | City 2 | City Agency 2 | Orange 3 | 1.0 | McDowell Park | 0 | Local Park 2 | 4 | |
12780 | 12780 | 12779 | {"type": "MultiPolygon", "coordinates": [[[[-117.9371, 33.6686], [-117.93478, 33.66862], [-117.93474, 33.66617], [-117.93453, 33.666], [-117.93434, 33.66577], [-117.93426, 33.66553], [-117.93425, 33.66529], [-117.93433, 33.66497], [-117.9345, 33.66461], [-117.93477, 33.66411], [-117.93485, 33.66379], [-117.93489, 33.66313], [-117.93476, 33.66312], [-117.93473, 33.66086], [-117.93497, 33.66095], [-117.93521, 33.66102], [-117.93618, 33.66122], [-117.93643, 33.66131], [-117.93665, 33.66142], [-117.93691, 33.66158], [-117.93716, 33.66179], [-117.93736, 33.66201], [-117.93752, 33.66224], [-117.93762, 33.6624], [-117.93772, 33.66267], [-117.93776, 33.66286], [-117.93777, 33.66485], [-117.93776, 33.66565], [-117.93773, 33.66589], [-117.93767, 33.66611], [-117.93755, 33.66638], [-117.93733, 33.66677], [-117.93716, 33.66716], [-117.9371, 33.66746], [-117.93709, 33.66788], [-117.9371, 33.6686]]], [[[-117.94524, 33.66565], [-117.94451, 33.66855], [-117.93744, 33.6686], [-117.93741, 33.66756], [-117.93743, 33.66739], [-117.93755, 33.66705], [-117.93791, 33.66635], [-117.93801, 33.6661], [-117.93807, 33.6659], [-117.93809, 33.66568], [-117.93811, 33.66544], [-117.93808, 33.66335], [-117.93808, 33.66306], [-117.93806, 33.66286], [-117.93791, 33.66239], [-117.93772, 33.66208], [-117.93756, 33.66186], [-117.93735, 33.66164], [-117.93691, 33.6613], [-117.93866, 33.66024], [-117.93867, 33.65964], [-117.94073, 33.65963], [-117.94071, 33.65784], [-117.94224, 33.65783], [-117.94357, 33.65784], [-117.94334, 33.66349], [-117.94294, 33.66519], [-117.94524, 33.66565]]]]} | Open Access 1 | 30212 | Fairview Park | 2844 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=247 | Orange 3 | 202.397 | Fairview Park | 0 | Local Park 2 | 4 |
12781 | 12781 | 12780 | {"type": "Polygon", "coordinates": [[[-117.97897, 33.75604], [-117.97875, 33.75605], [-117.97875, 33.75572], [-117.97897, 33.75571], [-117.97897, 33.75604]]]} | Open Access 1 | 30232 | Oasis Park | 23040 | 1378 | Westminster, City of 153 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | Orange 3 | 0.189 | Oasis Park | 0 | Local Park 2 | 4 | |
12782 | 12782 | 12781 | {"type": "Polygon", "coordinates": [[[-117.9853, 33.7564], [-117.98447, 33.75641], [-117.98446, 33.75567], [-117.98529, 33.75566], [-117.9853, 33.7564]]]} | Open Access 1 | 30233 | Sid Goldstein Freedom Park | 25438 | 1378 | Westminster, City of 153 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | Orange 3 | 1.552 | Sid Goldstein Freedom Park | 0 | Local Park 2 | 4 | |
12783 | 12783 | 12782 | {"type": "Polygon", "coordinates": [[[-117.93489, 33.66312], [-117.93485, 33.66379], [-117.93477, 33.66411], [-117.9345, 33.66461], [-117.93433, 33.66497], [-117.93425, 33.66529], [-117.93426, 33.66553], [-117.93434, 33.66577], [-117.93453, 33.666], [-117.93474, 33.66616], [-117.93478, 33.66862], [-117.92476, 33.6687], [-117.92473, 33.66822], [-117.92475, 33.66793], [-117.92484, 33.66736], [-117.92489, 33.6672], [-117.92497, 33.66701], [-117.92513, 33.66676], [-117.92522, 33.66666], [-117.92542, 33.66648], [-117.92548, 33.66643], [-117.92616, 33.66626], [-117.92641, 33.66623], [-117.92763, 33.666], [-117.92836, 33.66592], [-117.92909, 33.66525], [-117.92957, 33.66396], [-117.92835, 33.66366], [-117.92837, 33.66356], [-117.92773, 33.66339], [-117.92855, 33.66129], [-117.92855, 33.66091], [-117.92852, 33.66079], [-117.92846, 33.66068], [-117.92838, 33.66059], [-117.92826, 33.66047], [-117.92805, 33.66034], [-117.92801, 33.66028], [-117.92781, 33.66029], [-117.92391, 33.65934], [-117.92331, 33.65933], [-117.92288, 33.6595], [-117.9227, 33.65963], [-117.92122, 33.66345], [-117.92117, 33.66352], [-117.92111, 33.6636], [-117.92105, 33.66365], [-117.92095, 33.66369], [-117.92085, 33.6637], [-117.92035, 33.66362], [-117.91985, 33.66334], [-117.91972, 33.66324], [-117.91959, 33.66319], [-117.91947, 33.66318], [-117.91935, 33.6632], [-117.9193, 33.658], [-117.93043, 33.65793], [-117.93046, 33.6587], [-117.9315, 33.65867], [-117.93263, 33.66], [-117.9333, 33.65962], [-117.93389, 33.66032], [-117.93417, 33.66057], [-117.93451, 33.66076], [-117.93473, 33.66086], [-117.93476, 33.66311], [-117.93489, 33.66312]]]} | Restricted Access 2 | 30213 | Golf and Country Club | 33096 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | Orange 3 | 239.277 | Golf and Country Club | 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]);