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 113
- Ventura, City of 96
- Los Angeles, City of 95
- 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
- Midpeninsula Regional Open Space District 37
- Orange, County of 36
- Lake, County of 32
- San Jose, City of 31
- San Diego, County of 31
- Irvine, City of 31
- El Dorado, County of 31
- United States National Park Service 30
- Torrance, City of 29
- 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,297
- Local Recreation Area 769
- Local Other or Unknown 667
- State Conservation Area 184
- Local Conservation Area 181
- Private Conservation 153
- State Park 124
- Private Recreation or Education 119
- 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,088
- State Agency 517
- County Agency 349
- Recreation/Parks District 347
- Federal Agency 172
- Open Space District 151
- Non Profit - Land Trust 129
- Home Owners Association 94
- 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,300
- Restricted Access 474
- No Public Access 264
- 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12883 | 12883 | 12882 | {"type": "Polygon", "coordinates": [[[-118.05595, 33.80071], [-118.05595, 33.80122], [-118.05562, 33.80122], [-118.05562, 33.80071], [-118.05595, 33.80071]]]} | Open Access 1 | 30334 | Labourdette Park | 20816 | 1185 | Los Alamitos, City of 295 | City 2 | City Agency 2 | http://cityoflosalamitos.org/ | City 2 | 1185 | Los Alamitos, City of 291 | City 2 | City Agency 2 | Orange 3 | 0.43 | Labourdette Park | 0 | Local Park 2 | 4 | |
12884 | 12884 | 12883 | {"type": "Polygon", "coordinates": [[[-118.07043, 33.8054], [-118.07043, 33.80554], [-118.06993, 33.80554], [-118.06994, 33.8054], [-118.07043, 33.8054]]]} | Open Access 1 | 30335 | Soroptimist Park | 25629 | 1185 | Los Alamitos, City of 295 | City 2 | City Agency 2 | http://cityoflosalamitos.org/ | City 2 | 1185 | Los Alamitos, City of 291 | City 2 | City Agency 2 | Orange 3 | 0.179 | Soroptimist Park | 0 | Local Park 2 | 4 | |
12885 | 12885 | 12884 | {"type": "Polygon", "coordinates": [[[-118.06529, 33.80004], [-118.06507, 33.80004], [-118.06506, 33.79953], [-118.06529, 33.79953], [-118.06529, 33.80004]]]} | Open Access 1 | 30336 | Sterns Park | 25836 | 1185 | Los Alamitos, City of 295 | City 2 | City Agency 2 | http://cityoflosalamitos.org/ | City 2 | 1185 | Los Alamitos, City of 291 | City 2 | City Agency 2 | Orange 3 | 0.295 | Sterns Park | 0 | Local Park 2 | 4 | |
12886 | 12886 | 12885 | {"type": "Polygon", "coordinates": [[[-117.99563, 33.79989], [-117.99561, 33.80001], [-117.99485, 33.80055], [-117.994, 33.80056], [-117.99397, 33.79913], [-117.99512, 33.79946], [-117.99514, 33.79958], [-117.99563, 33.79989]]]} | Open Access 1 | 30337 | Norm Ross Sports Complex | 22793 | 1342 | Stanton, City of 745 | City 2 | City Agency 2 | http://www.ci.stanton.ca.us/Departments/Parks-and-Recreation | City 2 | 1342 | Stanton, City of 731 | City 2 | City Agency 2 | Orange 3 | 4.12 | Norm Ross Sports Complex | 0 | Local Recreation Area 3 | 4 | |
12887 | 12887 | 12886 | {"type": "Polygon", "coordinates": [[[-117.76711, 33.82831], [-117.76638, 33.82832], [-117.7663, 33.82829], [-117.76611, 33.82829], [-117.76603, 33.82832], [-117.76546, 33.82832], [-117.76488, 33.82837], [-117.7643, 33.82849], [-117.76422, 33.82848], [-117.76403, 33.82854], [-117.76397, 33.82858], [-117.76349, 33.82876], [-117.76334, 33.8288], [-117.76307, 33.82894], [-117.76295, 33.82892], [-117.76292, 33.82894], [-117.76286, 33.82886], [-117.76283, 33.82876], [-117.76283, 33.82872], [-117.76276, 33.82868], [-117.7628, 33.82863], [-117.76285, 33.82859], [-117.76375, 33.8282], [-117.76397, 33.82823], [-117.76402, 33.82792], [-117.76711, 33.82831]]]} | Open Access 1 | 30346 | Fred Barrera Park | 19072 | 1233 | Orange, City of 306 | City 2 | City Agency 2 | http://www.cityoforange.org/ | City 2 | 1233 | Orange, City of 302 | City 2 | City Agency 2 | http://www.cityoforange.org/civicax/filebank/blobdload.aspx?BlobID=5410 | Orange 3 | 3.204 | Fred Barrera Park | 0 | Local Park 2 | 4 |
12888 | 12888 | 12887 | {"type": "Polygon", "coordinates": [[[-117.9936, 33.79068], [-117.9936, 33.79081], [-117.9932, 33.79081], [-117.9932, 33.79069], [-117.9936, 33.79068]]]} | Open Access 1 | 30338 | Stanton Community Services Center Park | 25792 | 1342 | Stanton, City of 745 | City 2 | City Agency 2 | http://www.ci.stanton.ca.us/Departments/Parks-and-Recreation | City 2 | 1342 | Stanton, City of 731 | City 2 | City Agency 2 | Orange 3 | 0.124 | Stanton Community Services Ctr. Park | 0 | Local Park 2 | 4 | |
12889 | 12889 | 12888 | {"type": "Polygon", "coordinates": [[[-117.7818, 33.82905], [-117.78166, 33.82921], [-117.78004, 33.82881], [-117.77954, 33.82862], [-117.77952, 33.82849], [-117.77946, 33.82848], [-117.77913, 33.82789], [-117.77888, 33.82762], [-117.77894, 33.82756], [-117.77925, 33.82778], [-117.77952, 33.82794], [-117.78015, 33.82825], [-117.7803, 33.82835], [-117.78036, 33.82838], [-117.78046, 33.82838], [-117.78051, 33.82835], [-117.7807, 33.82818], [-117.78093, 33.82801], [-117.78119, 33.82825], [-117.78129, 33.8284], [-117.7816, 33.82867], [-117.78165, 33.82869], [-117.78173, 33.82867], [-117.7818, 33.82905]]]} | Open Access 1 | 30347 | Serrano Park | 25319 | 1233 | Orange, City of 306 | City 2 | City Agency 2 | http://www.cityoforange.org/ | City 2 | 1233 | Orange, City of 302 | City 2 | City Agency 2 | http://www.cityoforange.org/civicax/filebank/blobdload.aspx?blobid=2670 | Orange 3 | 4.346 | Serrano Park | 0 | Local Park 2 | 4 |
12890 | 12890 | 12889 | {"type": "Polygon", "coordinates": [[[-117.97433, 33.78835], [-117.97248, 33.78836], [-117.97246, 33.7879], [-117.97181, 33.78791], [-117.97177, 33.78617], [-117.9738, 33.78616], [-117.97382, 33.78667], [-117.9743, 33.78667], [-117.97433, 33.78835]]]} | Restricted Access 2 | 30348 | Hare School Park | 31617 | 1116 | Garden Grove, City of 62 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | Orange 3 | 12.599 | Hare School Park | 0 | Local Park 2 | 4 | |
12891 | 12891 | 12890 | {"type": "Polygon", "coordinates": [[[-117.94093, 33.77908], [-117.9409, 33.77908], [-117.94088, 33.77918], [-117.94084, 33.77929], [-117.94072, 33.77928], [-117.94037, 33.77891], [-117.93998, 33.77859], [-117.93998, 33.77855], [-117.93993, 33.77855], [-117.93965, 33.77834], [-117.93963, 33.77784], [-117.93954, 33.77784], [-117.93952, 33.77713], [-117.93944, 33.77712], [-117.93943, 33.777], [-117.94042, 33.77699], [-117.94043, 33.77688], [-117.94048, 33.77687], [-117.94048, 33.77642], [-117.94085, 33.77642], [-117.94087, 33.77777], [-117.94083, 33.77778], [-117.94083, 33.77789], [-117.94089, 33.7779], [-117.94089, 33.77808], [-117.94086, 33.77809], [-117.94086, 33.77826], [-117.94091, 33.77827], [-117.94093, 33.77908]]]} | Open Access 1 | 30349 | Village Green Park | 27114 | 1116 | Garden Grove, City of 62 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | Orange 3 | 6.647 | Village Green Park | 0 | Local Park 2 | 4 | |
12892 | 12892 | 12891 | {"type": "Polygon", "coordinates": [[[-117.7258, 33.60011], [-117.72572, 33.60011], [-117.72564, 33.60004], [-117.72557, 33.60001], [-117.72545, 33.60001], [-117.72537, 33.60003], [-117.72526, 33.6002], [-117.72524, 33.60039], [-117.72521, 33.60042], [-117.72497, 33.6005], [-117.72469, 33.60032], [-117.72468, 33.59997], [-117.72493, 33.59999], [-117.72564, 33.59994], [-117.72561, 33.59959], [-117.72576, 33.59958], [-117.7258, 33.60011]]]} | Open Access 1 | 30356 | Vista Park | 27180 | 1004 | Aliso Viejo, City of 758 | City 2 | City Agency 2 | http://www.cityofalisoviejo.com/CityHall/Departments/EconomicDevelopment/InteractiveMap.aspx?category=1 | City 2 | 1004 | Aliso Viejo, City of 743 | City 2 | City Agency 2 | Orange 3 | 0.941 | Vista Park | 0 | Local Park 2 | 4 | |
12893 | 12893 | 12892 | {"type": "MultiPolygon", "coordinates": [[[[-117.74601, 33.59723], [-117.74593, 33.59737], [-117.74582, 33.5975], [-117.74562, 33.59773], [-117.74559, 33.59771], [-117.74544, 33.598], [-117.74534, 33.59805], [-117.74504, 33.59797], [-117.74493, 33.59791], [-117.74488, 33.59775], [-117.74489, 33.5977], [-117.74495, 33.59761], [-117.74497, 33.59754], [-117.74475, 33.59747], [-117.74435, 33.59725], [-117.74419, 33.59724], [-117.74399, 33.59726], [-117.74396, 33.59721], [-117.74398, 33.59712], [-117.74396, 33.59703], [-117.7438, 33.59691], [-117.74378, 33.59685], [-117.74383, 33.59669], [-117.74446, 33.59687], [-117.74601, 33.59723]]], [[[-117.74709, 33.59749], [-117.74705, 33.59764], [-117.74687, 33.59767], [-117.7468, 33.59776], [-117.74678, 33.59786], [-117.7467, 33.59788], [-117.74663, 33.59799], [-117.7465, 33.59798], [-117.74646, 33.598], [-117.7464, 33.59814], [-117.74662, 33.59827], [-117.74664, 33.59832], [-117.74596, 33.59815], [-117.7459, 33.59823], [-117.74563, 33.59814], [-117.74561, 33.59806], [-117.74578, 33.59778], [-117.74602, 33.59749], [-117.74616, 33.59726], [-117.74709, 33.59749]]]]} | Open Access 1 | 30357 | Hummingbird Park | 20148 | 1004 | Aliso Viejo, City of 758 | City 2 | City Agency 2 | http://www.cityofalisoviejo.com/CityHall/Departments/EconomicDevelopment/InteractiveMap.aspx?category=1 | City 2 | 1004 | Aliso Viejo, City of 743 | City 2 | City Agency 2 | Orange 3 | 5.295 | Hummingbird Park | 0 | Local Park 2 | 4 | |
12894 | 12894 | 12893 | {"type": "Polygon", "coordinates": [[[-115.46973, 32.6904], [-115.46973, 32.69168], [-115.46968, 32.69172], [-115.46807, 32.69172], [-115.46807, 32.69039], [-115.46973, 32.6904]]]} | Open Access 1 | 30423 | Ceasar Chavez Park | 16989 | 1451 | Calexico, City of 607 | City 2 | City Agency 2 | http://www.calexicorecreation.org/parks | City 2 | 1451 | Calexico, City of 596 | City 2 | City Agency 2 | Imperial 20 | 5.651 | Ceasar Chavez Park | 0 | Local Park 2 | 4 | |
12895 | 12895 | 12894 | {"type": "Polygon", "coordinates": [[[-120.40911, 39.31635], [-120.3998, 39.31639], [-120.38819, 39.31639], [-120.38819, 39.31604], [-120.38589, 39.31601], [-120.3859, 39.31548], [-120.38236, 39.31549], [-120.38235, 39.31597], [-120.38113, 39.31596], [-120.38111, 39.31642], [-120.3797, 39.31643], [-120.37969, 39.31657], [-120.3572, 39.31661], [-120.35657, 39.31635], [-120.35629, 39.31625], [-120.35591, 39.31615], [-120.35562, 39.31609], [-120.35522, 39.31605], [-120.35491, 39.31605], [-120.35347, 39.31612], [-120.35355, 39.31568], [-120.35331, 39.31568], [-120.35309, 39.31565], [-120.35282, 39.31559], [-120.35257, 39.3155], [-120.34747, 39.31352], [-120.34676, 39.31319], [-120.3461, 39.31281], [-120.34687, 39.31155], [-120.348, 39.31059], [-120.35097, 39.30932], [-120.35356, 39.30891], [-120.35348, 39.30538], [-120.35344, 39.30192], [-120.36257, 39.30197], [-120.3625, 39.29483], [-120.36247, 39.28761], [-120.3717, 39.28755], [-120.3766, 39.28742], [-120.38127, 39.28733], [-120.38122, 39.28047], [-120.38111, 39.27337], [-120.3905, 39.27317], [-120.39981, 39.27301], [-120.39979, 39.28736], [-120.38591, 39.28734], [-120.38588, 39.29096], [-120.38573, 39.29461], [-120.39037, 39.29461], [-120.39034, 39.29821], [-120.39495, 39.29823], [-120.39507, 39.30178], [-120.40436, 39.30181], [-120.40899, 39.30184], [-120.4091, 39.30542], [-120.40911, 39.31635]], [[-120.39242, 39.30178], [-120.39229, 39.30118], [-120.39082, 39.30033], [-120.39015, 39.30029], [-120.38933, 39.29924], [-120.38879, 39.29932], [-120.38846, 39.29897], [-120.38809, 39.29829], [-120.3885, 39.29781], [-120.38776, 39.29688], [-120.38598, 39.29709], [-120.38586, 39.29696], [-120.38577, 39.2961], [-120.38605, 39.29609], [-120.38598, 39.29531], [-120.38571, 39.29485], [-120.38542, 39.29445], [-120.3849, 39.29492], [-120.38476, 39.29482], [-120.38557, 39.29408], [-120.38384, 39.29319], [-120.38346, 39.29358], [-120.38332, 39.29446], [-120.38325, 39.29446], [-120.38324, 39.29431], [-120.38281, 39.29379], [-120.38197, 39.29382], [-120.38136, 39.29497], [-120.38184, 39.29536], [-120.38151, 39.29557], [-120.38097, 39.29582], [-120.38101, 39.296], [-120.38006, 39.29642], [-120.38001, 39.29635], [-120.37993, 39.29638], [-120.37997, 39.29646], [-120.37977, 39.29656], [-120.37959, 39.29669], [-120.37945, 39.2968], [-120.37927, 39.29698], [-120.37869, 39.29776], [-120.37857, 39.29795], [-120.3785, 39.29811], [-120.37845, 39.29826], [-120.37842, 39.29854], [-120.37845, 39.2997], [-120.37851, 39.30002], [-120.37867, 39.30053], [-120.37883, 39.30086], [-120.37905, 39.30119], [-120.37956, 39.30181], [-120.37885, 39.30183], [-120.37864, 39.30155], [-120.37803, 39.3004], [-120.37671, 39.30042], [-120.3767, 39.30043], [-120.37684, 39.30188], [-120.3728, 39.30198], [-120.37286, 39.30016], [-120.37174, 39.30015], [-120.37155, 39.30201], [-120.36714, 39.30196], [-120.36258, 39.30198], [-120.3627, 39.30559], [-120.36275, 39.30916], [-120.36733, 39.3092], [-120.37193, 39.3092], [-120.37655, 39.30918], [-120.38119, 39.30905], [-120.38116, 39.3122], [-120.38137, 39.31224], [-120.38125, 39.31265], [-120.38324, 39.31297], [-120.38476, 39.31239], [-120.38495, 39.31209], [-120.38601, 39.31212], [-120.38684, 39.31226], [-120.38727, 39.31242], [-120.38853, 39.31306], [-120.38845, 39.31316], [-120.38734, 39.31261], [-120.38707, 39.31318], [-120.38796, 39.31363], [-120.38792, 39.31401], [-120.3889, 39.31409], [-120.38949, 39.31395], [-120.38949, 39.3133], [-120.3892, 39.31329], [-120.38919, 39.31316], [-120.38906, 39.31315], [-120.38905, 39.31287], [-120.3888, 39.31273], [-120.38972, 39.31161], [-120.38983, 39.31103], [-120.38984, 39.31089], [-120.38985, 39.31088], [-120.38985, 39.30892], [-120.38989, 39.30856], [-120.39, 39.3082], [-120.39031, 39.30772], [-120.39057, 39.30739], [-120.39107, 39.30693], [-120.39129, 39.30652], [-120.39141, 39.30604], [-120.39133, 39.30565], [-120.39135, 39.30546], [-120.39149, 39.30501], [-120.39148, 39.305], [-120.3915, 39.30491], [-120.39204, 39.30337], [-120.39242, 39.30214], [-120.39248, 39.30213], [-120.39242, 39.30178]], [[-120.3859, 39.31298], [-120.38591, 39.31297], [-120.38583, 39.31277], [-120.38515, 39.31292], [-120.38523, 39.31312], [-120.3859, 39.31298]]]} | Open Access 1 | 44701 | Royal Gorge | 13417 | 3104 | Truckee Donner Land Trust 673 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tdlandtrust.org/ | Non Governmental Organization 10 | 3104 | Truckee Donner Land Trust 663 | Non Profit 6 | Non Profit - Land Trust 10 | http://tdlandtrust.org/royal-gorge | Placer 35 | 2782.195 | Royal Gorge | 0 | Private Conservation 16 | 2 |
12896 | 12896 | 12895 | {"type": "Polygon", "coordinates": [[[-118.06, 33.71724], [-118.05953, 33.71725], [-118.05952, 33.71646], [-118.05955, 33.71643], [-118.05972, 33.71641], [-118.05999, 33.71707], [-118.06, 33.71724]]]} | Open Access 1 | 30351 | Booster Park | 16274 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/booster-park.cfm | Orange 3 | 0.752 | Booster Park | 0 | Local Park 2 | 4 |
12897 | 12897 | 12896 | {"type": "Polygon", "coordinates": [[[-117.73646, 33.57601], [-117.73647, 33.57611], [-117.73593, 33.5772], [-117.73522, 33.57626], [-117.73566, 33.57542], [-117.7358, 33.57549], [-117.73618, 33.57575], [-117.73646, 33.57601]]]} | Open Access 1 | 30367 | Acorn Park | 15249 | 1004 | Aliso Viejo, City of 758 | City 2 | City Agency 2 | http://www.cityofalisoviejo.com/CityHall/Departments/EconomicDevelopment/InteractiveMap.aspx?category=1 | City 2 | 1004 | Aliso Viejo, City of 743 | City 2 | City Agency 2 | Orange 3 | 3.041 | Acorn Park | 0 | Local Park 2 | 4 | |
12898 | 12898 | 12897 | {"type": "Polygon", "coordinates": [[[-121.12848, 37.73487], [-121.12639, 37.73485], [-121.1264, 37.73394], [-121.12796, 37.73396], [-121.12797, 37.73439], [-121.12847, 37.7344], [-121.12848, 37.73487]]]} | Open Access 1 | 36301 | Ripon holding 3 | 24399 | 1277 | Ripon, City of 534 | City 2 | City Agency 2 | http://www.cityofripon.org/ | City 2 | 1277 | Ripon, City of 527 | City 2 | City Agency 2 | San Joaquin 39 | 4.033 | Ripon holding 3 | 0 | Local Other or Unknown 14 | 4 | |
12899 | 12899 | 12898 | {"type": "Polygon", "coordinates": [[[-118.06828, 33.72459], [-118.06804, 33.72464], [-118.06803, 33.72458], [-118.06796, 33.72452], [-118.06789, 33.72451], [-118.0678, 33.72454], [-118.06773, 33.72449], [-118.06743, 33.72457], [-118.06714, 33.7247], [-118.06707, 33.72464], [-118.06699, 33.72463], [-118.06694, 33.72464], [-118.06688, 33.72468], [-118.06685, 33.72474], [-118.06655, 33.72482], [-118.0666, 33.72492], [-118.06633, 33.72499], [-118.06631, 33.72503], [-118.06623, 33.72502], [-118.06616, 33.72505], [-118.06612, 33.72508], [-118.06609, 33.72514], [-118.06612, 33.72522], [-118.06592, 33.7253], [-118.06555, 33.7253], [-118.06555, 33.72559], [-118.06499, 33.72559], [-118.065, 33.72549], [-118.06519, 33.72548], [-118.06531, 33.72529], [-118.06529, 33.72524], [-118.06536, 33.7252], [-118.06539, 33.72515], [-118.06546, 33.72516], [-118.06572, 33.72507], [-118.06594, 33.7249], [-118.06594, 33.72485], [-118.066, 33.72483], [-118.06605, 33.7248], [-118.0662, 33.72481], [-118.06648, 33.72463], [-118.06662, 33.7244], [-118.06668, 33.72441], [-118.06676, 33.72439], [-118.0668, 33.72437], [-118.06683, 33.72431], [-118.06696, 33.72427], [-118.06712, 33.72403], [-118.06733, 33.72412], [-118.06749, 33.72388], [-118.06775, 33.72403], [-118.06759, 33.72427], [-118.06828, 33.72459]]]} | Open Access 1 | 30352 | Conrad Park | 17595 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/conrad-park.cfm | Orange 3 | 2.752 | Conrad Park | 0 | Local Park 2 | 4 |
12900 | 12900 | 12899 | {"type": "Polygon", "coordinates": [[[-118.00009, 33.6893], [-117.99911, 33.69028], [-117.99831, 33.68971], [-117.99828, 33.68967], [-117.99828, 33.68963], [-117.9983, 33.6896], [-117.99894, 33.68898], [-117.99921, 33.68877], [-117.99957, 33.68859], [-118.00009, 33.6893]]]} | Open Access 1 | 30353 | Green Park | 19465 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/green-park.cfm | Orange 3 | 3.999 | Green Park | 0 | Local Park 2 | 4 |
12901 | 12901 | 12900 | {"type": "Polygon", "coordinates": [[[-118.07112, 33.7252], [-118.07073, 33.72527], [-118.07071, 33.72521], [-118.07066, 33.72516], [-118.07086, 33.72496], [-118.07101, 33.72503], [-118.07104, 33.72506], [-118.07109, 33.72512], [-118.07112, 33.7252]]]} | Open Access 1 | 30354 | Prince Park | 24007 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 0.218 | Prince Park | 0 | Local Park 2 | 4 | |
12902 | 12902 | 12901 | {"type": "Polygon", "coordinates": [[[-118.06732, 33.72058], [-118.06761, 33.721], [-118.06762, 33.72106], [-118.06761, 33.7211], [-118.06754, 33.72114], [-118.06743, 33.72114], [-118.06703, 33.72096], [-118.06732, 33.72058]]]} | Open Access 1 | 30355 | Tarbox Park | 26189 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 0.434 | Tarbox Park | 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]);