units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 7,528
- Recreation/Parks District 979
- County Agency 911
- State Agency 821
- Non Profit - Land Trust 506
- Federal Agency 377
- Open Space District 278
- Water District 200
- Community Services District 195
- Home Owners Association 183
- County Agency - Parks 164
- Non Profit - Conservation 130
- Flood District 84
- Irrigation District 39
- School District 35
- Non Profit - Other 34
- Cemetery District 27
- Port/Harbor District 21
- County Agency - Other 20
- Commercial 12
- Special District - Other 11
- Joint Powers Authority 9
- Sanitation District 5
- Other 5
- Transportation Agency 5
- Mitigation Bank 4
- Conservation District 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- Airport District 1
- …
MNG_AGENCY >30
- San Diego, City of 329
- California Department of Fish and Wildlife 289
- California Department of Parks and Recreation 283
- Los Angeles, City of 264
- Sacramento, City of 220
- Mountains Recreation and Conservation Authority 210
- San Jose, City of 177
- Ventura, City of 141
- East Bay Regional Park District 138
- Roseville, City of 130
- Oakland, City of 117
- San Francisco, City and County of 102
- United States Bureau of Land Management 100
- Los Angeles, County of 99
- Consumnes Community Services District 94
- United States Forest Service 85
- Irvine, City of 85
- Modesto, City of 85
- Santa Barbara, County of 82
- Stockton, City of 81
- Napa, City of 81
- California State Lands Commission 78
- Hayward Area Recreation and Park District 74
- Tracy, City of 73
- Long Beach, City of 71
- Orange, County of 69
- Valley-Wide Recreation and Park District 66
- Davis, City of 65
- Bakersfield, City of 61
- Clovis, City of 61
- …
DES_TP >30
- Local Park 6,711
- Local Recreation Area 1,363
- Local Other or Unknown 1,095
- Private Conservation 529
- Local Conservation Area 336
- State Conservation Area 250
- Private Recreation or Education 235
- State Park 148
- State Resource Management Area 131
- State Recreation Area 101
- National Forest 75
- Local Historic or Cultural Area 73
- National Public Lands 69
- State Other or Unknown 60
- National Wildlife Refuge 56
- State Historic or Cultural Area 50
- Private Other or Unknown 46
- Recreation Management Area 40
- National Recreation Area 27
- National Monument or Landmark 26
- Local Resource Management Area 22
- Federal Other or Unknown 20
- Resource Management Area 17
- Private Agricultural 12
- National Park 11
- Conservation Area 5
- Area of Critical Environmental Concern 5
- Historic or Cultural Area 4
- Wilderness Area 3
- State Wilderness 2
- …
ACCESS_TYP 4
- Open Access 10,478
- Restricted Access 984
- No Public Access 804
- Unknown Access 329
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1610 | 1610 | 1609 | {"type": "Polygon", "coordinates": [[[-122.30482, 38.00195], [-122.3047, 38.0025], [-122.30429, 38.00259], [-122.30396, 38.00258], [-122.30412, 38.00193], [-122.30482, 38.00195]]]} | Open Access 1 | 12309 | Meadow Park | 22073 | 1252 | Pinole, City of 357 | City 2 | City Agency 2 | http://www.ci.pinole.ca.us/recreation/parks.html | City 2 | 1252 | Pinole, City of 354 | City 2 | City Agency 2 | Contra Costa 12 | 1.081 | Meadow Park | 0 | Local Park 2 | 4 | |
1611 | 1611 | 1610 | {"type": "Polygon", "coordinates": [[[-117.79664, 33.7004], [-117.79645, 33.70059], [-117.79646, 33.70063], [-117.79639, 33.70077], [-117.79622, 33.70094], [-117.79604, 33.70079], [-117.7955, 33.70028], [-117.79537, 33.70008], [-117.79535, 33.69985], [-117.79537, 33.69985], [-117.79556, 33.69966], [-117.79612, 33.70005], [-117.7964, 33.70021], [-117.79664, 33.7004]]]} | Open Access 1 | 12310 | Flagstone Park | 18936 | 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.963 | Flagstone Park | 0 | Local Park 2 | 4 | |
8132 | 8132 | 8131 | {"type": "Polygon", "coordinates": [[[-117.77, 33.72949], [-117.76927, 33.73023], [-117.76857, 33.72975], [-117.7671, 33.73126], [-117.76614, 33.73217], [-117.76609, 33.73227], [-117.76603, 33.73226], [-117.76578, 33.7325], [-117.76622, 33.73283], [-117.766, 33.73305], [-117.76601, 33.7331], [-117.76591, 33.73314], [-117.76546, 33.73359], [-117.76539, 33.73359], [-117.76473, 33.73312], [-117.76553, 33.73233], [-117.76558, 33.73235], [-117.76664, 33.73127], [-117.76728, 33.73066], [-117.76908, 33.72884], [-117.76966, 33.72923], [-117.76999, 33.72947], [-117.77, 33.72949]]]} | Restricted Access 2 | 12311 | Forest Glen Park | 18992 | 6011 | Northpark Maintenance Association 886 | Private 7 | Home Owners Association 16 | http://www.crummackhuseby.com/northpark/ | Private 14 | 6011 | Northpark Maintenance Association 862 | Private 7 | Home Owners Association 15 | Orange 3 | 8.214 | Forest Glen Park | 0 | Private Recreation or Education 65 | 4 | |
8133 | 8133 | 8132 | {"type": "Polygon", "coordinates": [[[-117.71925, 33.56722], [-117.71925, 33.56736], [-117.71915, 33.56784], [-117.71894, 33.5685], [-117.71855, 33.56855], [-117.71852, 33.56887], [-117.71822, 33.56895], [-117.71714, 33.56676], [-117.71752, 33.56632], [-117.71893, 33.56711], [-117.71925, 33.56722]]]} | Open Access 1 | 12312 | Foxborough Park | 19036 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 7.537 | Foxborough Park | 0 | Local Park 2 | 4 | |
16090 | 16090 | 16089 | {"type": "Polygon", "coordinates": [[[-118.75338, 34.07449], [-118.74918, 34.07468], [-118.74905, 34.06713], [-118.74903, 34.06346], [-118.74927, 34.06345], [-118.74935, 34.06348], [-118.74943, 34.06353], [-118.74951, 34.06364], [-118.74963, 34.06373], [-118.75017, 34.06398], [-118.75031, 34.06401], [-118.75074, 34.06406], [-118.75082, 34.0641], [-118.75083, 34.06419], [-118.75066, 34.06433], [-118.75064, 34.06438], [-118.75064, 34.06447], [-118.75066, 34.06452], [-118.75065, 34.06456], [-118.7505, 34.06477], [-118.75045, 34.06487], [-118.75046, 34.065], [-118.75048, 34.06506], [-118.75051, 34.06511], [-118.75062, 34.0652], [-118.75078, 34.06526], [-118.7509, 34.06526], [-118.75097, 34.06524], [-118.75153, 34.06497], [-118.7516, 34.06497], [-118.75165, 34.065], [-118.7519, 34.06549], [-118.75197, 34.06556], [-118.75207, 34.0656], [-118.75251, 34.06555], [-118.75257, 34.0656], [-118.75272, 34.06593], [-118.75277, 34.06598], [-118.75285, 34.06602], [-118.75296, 34.06602], [-118.75316, 34.06595], [-118.75321, 34.06595], [-118.75324, 34.06794], [-118.75319, 34.06799], [-118.75317, 34.06807], [-118.75319, 34.06813], [-118.75325, 34.06821], [-118.75334, 34.07273], [-118.75328, 34.07283], [-118.75327, 34.07292], [-118.75329, 34.073], [-118.75335, 34.07314], [-118.75338, 34.07449]]]} | Open Access 1 | 12313 | Gage Open Space | 14219 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 103.318 | Gage OS | 0 | Recreation Management Area 49 | 4 | |
8134 | 8134 | 8133 | {"type": "Polygon", "coordinates": [[[-117.16972, 32.67545], [-117.16931, 32.67587], [-117.16903, 32.67574], [-117.16873, 32.67547], [-117.16831, 32.67527], [-117.16806, 32.6752], [-117.16822, 32.67506], [-117.16781, 32.67471], [-117.16835, 32.67424], [-117.16972, 32.67545]]]} | Open Access 1 | 12316 | Glorietta Bay Park | 19347 | 1069 | Coronado, City of 105 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 1069 | Coronado, City of 102 | City 2 | City Agency 2 | https://www.coronado.ca.us/cms/one.aspx?portalId=746090&pageId=3814937 | San Diego 4 | 3.382 | Glorietta Bay Park | 0 | Local Park 2 | 4 |
8135 | 8135 | 8134 | {"type": "Polygon", "coordinates": [[[-117.6702, 33.56906], [-117.66956, 33.56956], [-117.6689, 33.56945], [-117.6687, 33.5694], [-117.6685, 33.56933], [-117.66786, 33.56901], [-117.66799, 33.56889], [-117.66836, 33.56863], [-117.66868, 33.56851], [-117.66882, 33.56849], [-117.66905, 33.56848], [-117.66928, 33.56852], [-117.66961, 33.56864], [-117.66971, 33.56869], [-117.6702, 33.56906]]]} | Open Access 1 | 12317 | Granada Park | 19420 | 1207 | Mission Viejo, City of 182 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | Orange 3 | 4.005 | Granada Park | 0 | Local Park 2 | 4 | |
8136 | 8136 | 8135 | {"type": "Polygon", "coordinates": [[[-117.2968, 33.04049], [-117.29618, 33.04056], [-117.29616, 33.04042], [-117.29669, 33.04039], [-117.2968, 33.04049]]]} | Open Access 1 | 12319 | H Street Viewpoint | 19582 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches | San Diego 4 | 0.181 | H Street Viewpoint | None 678 | ||
8138 | 8138 | 8137 | {"type": "Polygon", "coordinates": [[[-122.3162, 38.00019], [-122.31587, 38.00046], [-122.31532, 38.00043], [-122.31486, 38.00056], [-122.31446, 38.00022], [-122.31488, 37.99995], [-122.3162, 38.00019]]]} | Open Access 1 | 12320 | Louis Francis Park | 21547 | 1252 | Pinole, City of 357 | City 2 | City Agency 2 | http://www.ci.pinole.ca.us/recreation/parks.html | City 2 | 1252 | Pinole, City of 354 | City 2 | City Agency 2 | Contra Costa 12 | 1.468 | Louis Francis Park | 0 | Local Park 2 | 4 | |
8141 | 8141 | 8140 | {"type": "Polygon", "coordinates": [[[-117.70692, 33.65013], [-117.70605, 33.65112], [-117.70593, 33.65114], [-117.70455, 33.65042], [-117.70383, 33.65063], [-117.70301, 33.65015], [-117.70212, 33.64924], [-117.69958, 33.64878], [-117.69879, 33.64883], [-117.69849, 33.64914], [-117.69675, 33.64944], [-117.69591, 33.64907], [-117.69401, 33.64891], [-117.69335, 33.64903], [-117.69258, 33.64884], [-117.69199, 33.64856], [-117.69134, 33.6483], [-117.69111, 33.64823], [-117.69083, 33.64829], [-117.69028, 33.6487], [-117.69003, 33.64895], [-117.68951, 33.64967], [-117.68867, 33.64928], [-117.68883, 33.64922], [-117.68916, 33.64905], [-117.68924, 33.64895], [-117.68934, 33.64875], [-117.68946, 33.64858], [-117.68958, 33.64847], [-117.6898, 33.64834], [-117.69027, 33.6482], [-117.69094, 33.64786], [-117.6911, 33.64784], [-117.69129, 33.64785], [-117.69167, 33.64757], [-117.69174, 33.64727], [-117.69291, 33.64742], [-117.69348, 33.64751], [-117.69519, 33.64804], [-117.6956, 33.64809], [-117.69602, 33.6481], [-117.69643, 33.64805], [-117.69752, 33.64774], [-117.69803, 33.64758], [-117.69803, 33.64756], [-117.69825, 33.64752], [-117.69857, 33.64749], [-117.69884, 33.6475], [-117.69934, 33.64756], [-117.69997, 33.64774], [-117.69995, 33.64783], [-117.7003, 33.64792], [-117.70069, 33.64796], [-117.70095, 33.64794], [-117.70102, 33.64818], [-117.70259, 33.64881], [-117.70283, 33.64899], [-117.70335, 33.64954], [-117.70364, 33.64956], [-117.70371, 33.64927], [-117.70391, 33.64907], [-117.70413, 33.64908], [-117.70428, 33.64921], [-117.70443, 33.64961], [-117.70452, 33.64962], [-117.7045, 33.64969], [-117.70484, 33.64974], [-117.70489, 33.64967], [-117.70527, 33.64971], [-117.7056, 33.64934], [-117.70609, 33.64954], [-117.70691, 33.65], [-117.70692, 33.65013]]]} | Open Access 1 | 12321 | Serrano Creek Park | 25318 | 1167 | Lake Forest, City of 235 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | Orange 3 | 49.689 | Serrano Creek Park | 0 | Local Park 2 | 4 | |
8142 | 8142 | 8141 | {"type": "Polygon", "coordinates": [[[-121.78313, 37.69647], [-121.78294, 37.69671], [-121.78269, 37.69652], [-121.78244, 37.69671], [-121.78216, 37.69661], [-121.78191, 37.69646], [-121.78147, 37.69581], [-121.78116, 37.69502], [-121.7811, 37.6949], [-121.78114, 37.6946], [-121.78146, 37.69477], [-121.78146, 37.69499], [-121.78202, 37.69526], [-121.78275, 37.69572], [-121.78277, 37.69579], [-121.78303, 37.69579], [-121.78313, 37.69647]]]} | Open Access 1 | 12322 | Livermore Downs | 21380 | 2062 | Livermore Area Recreation and Park District 394 | Special District 4 | Recreation/Parks District 4 | http://www.larpd.dst.ca.us/ | Special District 4 | 2062 | Livermore Area Recreation and Park District 388 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 4.683 | Livermore Downs | None 680 | |||
8143 | 8143 | 8142 | {"type": "Polygon", "coordinates": [[[-118.96447, 34.16851], [-118.96427, 34.16919], [-118.9638, 34.16917], [-118.96314, 34.16943], [-118.96249, 34.16866], [-118.9617, 34.16812], [-118.96204, 34.16722], [-118.96404, 34.16787], [-118.96447, 34.16851]]]} | Open Access 1 | 12323 | Cypress Park - CRPD | 17882 | 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 | 8.864 | Cypress Park - CRPD | None 681 | |||
8144 | 8144 | 8143 | {"type": "Polygon", "coordinates": [[[-117.34865, 33.20849], [-117.34781, 33.2094], [-117.34673, 33.20972], [-117.34594, 33.20913], [-117.34634, 33.20881], [-117.34648, 33.20864], [-117.34654, 33.20853], [-117.34673, 33.20775], [-117.34746, 33.20617], [-117.34817, 33.2049], [-117.34822, 33.20486], [-117.3483, 33.20489], [-117.34855, 33.20525], [-117.34865, 33.20535], [-117.34865, 33.20849]]]} | Open Access 1 | 12325 | Buddy Todd Memorial Park | 16481 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#24 | San Diego 4 | 17.845 | Buddy Todd Memorial Park | 0 | Local Park 2 | 4 |
8145 | 8145 | 8144 | {"type": "MultiPolygon", "coordinates": [[[[-117.80234, 33.70103], [-117.80135, 33.70203], [-117.80127, 33.702], [-117.80126, 33.70198], [-117.8009, 33.70174], [-117.80202, 33.70065], [-117.80226, 33.70096], [-117.80234, 33.70103]]], [[[-117.80509, 33.69821], [-117.80475, 33.69858], [-117.80343, 33.69991], [-117.80262, 33.70065], [-117.80253, 33.7006], [-117.80232, 33.7003], [-117.80472, 33.69788], [-117.80495, 33.69803], [-117.80508, 33.69813], [-117.80509, 33.69821]]], [[[-117.81234, 33.69243], [-117.81224, 33.69249], [-117.81107, 33.69284], [-117.81049, 33.69311], [-117.81021, 33.69326], [-117.80983, 33.69354], [-117.80921, 33.69405], [-117.80835, 33.69488], [-117.80592, 33.69736], [-117.80528, 33.69796], [-117.80487, 33.69768], [-117.80662, 33.69598], [-117.80771, 33.69487], [-117.80827, 33.69466], [-117.80911, 33.69378], [-117.80955, 33.69341], [-117.80989, 33.69319], [-117.81018, 33.69302], [-117.8106, 33.69281], [-117.81076, 33.69271], [-117.81092, 33.69265], [-117.81149, 33.69246], [-117.81184, 33.69237], [-117.8123, 33.69228], [-117.81234, 33.69243]]], [[[-117.81821, 33.68858], [-117.8159, 33.69082], [-117.81523, 33.6914], [-117.81484, 33.69165], [-117.8145, 33.69184], [-117.81401, 33.69206], [-117.81367, 33.69218], [-117.81288, 33.69237], [-117.81274, 33.69234], [-117.81268, 33.69218], [-117.81322, 33.69206], [-117.81382, 33.69189], [-117.81414, 33.69176], [-117.81448, 33.6916], [-117.81491, 33.69134], [-117.81526, 33.69109], [-117.81542, 33.69095], [-117.81809, 33.68842], [-117.81819, 33.68848], [-117.81821, 33.68858]]]]} | Open Access 1 | 12326 | Harvard Avenue Bike Path | 19714 | 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 | 18.358 | Harvard Avenue Bike Path | 0 | Local Recreation Area 3 | 4 | |
8146 | 8146 | 8145 | {"type": "Polygon", "coordinates": [[[-117.80197, 33.70714], [-117.80175, 33.70745], [-117.80131, 33.7079], [-117.79986, 33.70899], [-117.79916, 33.70961], [-117.79838, 33.71045], [-117.79672, 33.71026], [-117.79707, 33.70831], [-117.79725, 33.70768], [-117.79754, 33.7069], [-117.7979, 33.70702], [-117.79818, 33.70707], [-117.80197, 33.70714]]]} | Open Access 1 | 12327 | Harvard Community Athletic Park | 19715 | 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 | 26.774 | Harvard Community Athletic Park | 0 | Local Recreation Area 3 | 4 | |
8147 | 8147 | 8146 | {"type": "Polygon", "coordinates": [[[-117.32183, 33.23493], [-117.32157, 33.23502], [-117.32141, 33.23512], [-117.32132, 33.2352], [-117.32114, 33.23539], [-117.32106, 33.23554], [-117.32101, 33.2357], [-117.32099, 33.23434], [-117.32144, 33.23434], [-117.32144, 33.23451], [-117.32183, 33.23474], [-117.32183, 33.23493]]]} | Open Access 1 | 12328 | Heritage Park | 19853 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#10 | San Diego 4 | 1.507 | Heritage Park | 0 | Local Park 2 | 4 |
1613 | 1613 | 1612 | {"type": "Polygon", "coordinates": [[[-117.77216, 33.72465], [-117.77188, 33.72493], [-117.77189, 33.72518], [-117.77188, 33.7253], [-117.77184, 33.72545], [-117.77215, 33.72568], [-117.77145, 33.72639], [-117.77131, 33.72639], [-117.77106, 33.72619], [-117.77081, 33.72577], [-117.77063, 33.72553], [-117.77048, 33.72538], [-117.77025, 33.72522], [-117.7701, 33.72513], [-117.76989, 33.72504], [-117.76961, 33.72496], [-117.76876, 33.72484], [-117.76849, 33.72476], [-117.76815, 33.72458], [-117.76814, 33.72448], [-117.76855, 33.7241], [-117.76874, 33.72388], [-117.76968, 33.72299], [-117.76979, 33.72298], [-117.77216, 33.72465]]]} | Open Access 1 | 12329 | Hicks Canyon Community Park | 19899 | 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.997 | Hicks Canyon Community Park | 0 | Local Park 2 | 4 | |
2454 | 2454 | 2453 | {"type": "Polygon", "coordinates": [[[-117.66179, 33.49999], [-117.66168, 33.50071], [-117.66109, 33.50064], [-117.66106, 33.50059], [-117.66064, 33.50046], [-117.6607, 33.5], [-117.66083, 33.50002], [-117.66099, 33.49984], [-117.66179, 33.49999]]]} | Open Access 1 | 12330 | Historic Town Center (HTC) Park | 20008 | 1305 | San Juan Capistrano, City of 92 | City 2 | City Agency 2 | http://www.sanjuancapistrano.org/ | City 2 | 1305 | San Juan Capistrano, City of 90 | City 2 | City Agency 2 | Orange 3 | 1.879 | Historic Town Ctr. (HTC) Park | 0 | Local Historic or Cultural Area 19 | 4 | |
8150 | 8150 | 8149 | {"type": "Polygon", "coordinates": [[[-117.77725, 33.68548], [-117.77669, 33.68604], [-117.77658, 33.68597], [-117.77641, 33.68596], [-117.77634, 33.68598], [-117.77629, 33.68606], [-117.77634, 33.68613], [-117.77641, 33.68616], [-117.77655, 33.68618], [-117.77583, 33.6869], [-117.77339, 33.68522], [-117.77379, 33.68482], [-117.77524, 33.68582], [-117.77619, 33.68487], [-117.77644, 33.68504], [-117.77653, 33.68497], [-117.77725, 33.68548]]]} | Open Access 1 | 12331 | Hoeptner Park | 20020 | 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.29 | Hoeptner Park | 0 | Local Park 2 | 4 | |
1614 | 1614 | 1613 | {"type": "Polygon", "coordinates": [[[-118.65024, 34.1181], [-118.65024, 34.11939], [-118.6502, 34.12172], [-118.64565, 34.1217], [-118.64568, 34.1181], [-118.65024, 34.1181]]]} | Open Access 1 | 12332 | Secret Valley | 32667 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 41.753 | Secret Valley | None 129 |
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]);