units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,196 rows where COUNTY = 3 sorted by GAP_STS
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, MNG_AG_LEV, YR_EST, GAP_STS
MNG_AGENCY >30
- Irvine, City of 101
- Orange, County of 95
- Huntington Beach, City of 76
- Newport Beach, City of 65
- Anaheim, City of 59
- Fullerton, City of 58
- Mission Viejo, City of 47
- Santa Ana, City of 46
- Costa Mesa, City of 32
- Lake Forest, City of 31
- Woodbridge Village Association 31
- Yorba Linda, City of 30
- Laguna Niguel, City of 29
- San Juan Capistrano, City of 24
- Westminster, City of 24
- San Clemente, City of 24
- Dana Point, City of 22
- La Habra, City of 22
- Fountain Valley, City of 21
- Orange, City of 20
- Garden Grove, City of 19
- Cypress, City of 19
- Rancho Santa Margarita Landscape and Recreation Corporation 18
- Laguna Beach, City of 17
- Aliso Viejo, City of 17
- Placentia, City of 16
- Tustin, City of 16
- Brea, City of 15
- Seal Beach, City of 13
- Laguna Hills, City of 13
- …
DES_TP >30
- Local Park 793
- Private Recreation or Education 143
- Local Recreation Area 92
- Local Other or Unknown 70
- Local Conservation Area 25
- Private Conservation 11
- State Park 8
- State Conservation Area 7
- Local Historic or Cultural Area 4
- National Forest 1
- None 1
- None 1
- State Resource Management Area 1
- National Wildlife Refuge 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 12
ACCESS_TYP 4
- Open Access 1,011
- Restricted Access 178
- Unknown Access 4
- No Public Access 3
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
346 | 346 | 345 | {"type": "Polygon", "coordinates": [[[-117.83498, 33.59186], [-117.83357, 33.592], [-117.83332, 33.59203], [-117.83324, 33.59168], [-117.83368, 33.59129], [-117.8341, 33.59125], [-117.83427, 33.59117], [-117.83438, 33.59126], [-117.83475, 33.59141], [-117.83496, 33.59132], [-117.83498, 33.59186]]]} | Open Access 1 | 47415 | Los Trancos Canyon View Park (Upper) | 31132 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 2.623 | Los Trancos Canyon View Park (Upper) | None 35 | |||
395 | 395 | 394 | {"type": "Polygon", "coordinates": [[[-117.87117, 33.60242], [-117.87116, 33.60245], [-117.8711, 33.60256], [-117.87077, 33.60296], [-117.86932, 33.60201], [-117.86916, 33.60225], [-117.86863, 33.60202], [-117.86867, 33.60194], [-117.86798, 33.60161], [-117.86806, 33.60149], [-117.86816, 33.60138], [-117.86847, 33.60115], [-117.86847, 33.60114], [-117.86778, 33.60071], [-117.86707, 33.60032], [-117.86748, 33.5999], [-117.86751, 33.59989], [-117.86759, 33.59991], [-117.86785, 33.60009], [-117.86788, 33.60012], [-117.86788, 33.60016], [-117.86794, 33.6002], [-117.86799, 33.60018], [-117.86804, 33.6002], [-117.86887, 33.60078], [-117.869, 33.60082], [-117.86968, 33.60129], [-117.86963, 33.60134], [-117.86963, 33.60135], [-117.87103, 33.60229], [-117.87117, 33.60242]]]} | Open Access 1 | 1168 | Grant Howald Park & CYC | 19435 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 9.005 | Grant Howald Park & CYC | None 40 | |||
1360 | 1360 | 1359 | {"type": "Polygon", "coordinates": [[[-117.62078, 33.42109], [-117.62003, 33.42156], [-117.61976, 33.42148], [-117.61981, 33.42138], [-117.61982, 33.42131], [-117.61979, 33.42119], [-117.62004, 33.42112], [-117.62017, 33.42104], [-117.62036, 33.42098], [-117.62055, 33.42103], [-117.62065, 33.42104], [-117.62071, 33.42102], [-117.62078, 33.42109]]]} | Open Access 1 | 8023 | Parque Del Mar | 23479 | 1296 | San Clemente, City of 353 | City 2 | City Agency 2 | http://ci.san-clemente.ca.us/recreation-community | City 2 | 1296 | San Clemente, City of 350 | City 2 | City Agency 2 | Orange 3 | 0.782 | Parque Del Mar | None 117 | |||
1681 | 1681 | 1680 | {"type": "Polygon", "coordinates": [[[-117.56495, 33.66821], [-117.5606, 33.66822], [-117.56061, 33.67181], [-117.55625, 33.67183], [-117.55624, 33.66465], [-117.56493, 33.66461], [-117.56495, 33.66821]]]} | Unknown Access 4 | 12688 | Trabuco Canyon Water District lands | 26502 | 2166 | Trabuco Canyon Water District 406 | Special District 4 | Water District 13 | http://www.tcwd.ca.gov/ | Special District 4 | 2166 | Trabuco Canyon Water District 400 | Special District 4 | Water District 13 | Orange 3 | 119.276 | Trabuco Canyon Water District lands | None 135 | |||
2916 | 2916 | 2915 | {"type": "Polygon", "coordinates": [[[-117.6896, 33.88394], [-117.68375, 33.88034], [-117.68317, 33.87542], [-117.68394, 33.87576], [-117.68402, 33.8764], [-117.68761, 33.87755], [-117.68832, 33.87765], [-117.68955, 33.87758], [-117.6896, 33.88394]]]} | Open Access 1 | 19015 | Chino Hills State Park | 17209 | 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 | http://www.parks.ca.gov/?page_id=648 | Orange 3 | 77.249 | Chino Hills SP | 1981 | None 242 | |
3914 | 3914 | 3913 | {"type": "Polygon", "coordinates": [[[-117.97841, 33.64277], [-117.97662, 33.64365], [-117.97445, 33.64427], [-117.9734, 33.64289], [-117.97087, 33.64141], [-117.96566, 33.63891], [-117.96324, 33.6366], [-117.96422, 33.63562], [-117.97333, 33.63989], [-117.97502, 33.64075], [-117.97841, 33.64277]]]} | Open Access 1 | 2026 | Huntington Beach Wetlands Addition | 20157 | 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 | 93.375 | Huntington Beach Wetlands Addition | None 336 | |||
3979 | 3979 | 3978 | {"type": "Polygon", "coordinates": [[[-117.85936, 33.75016], [-117.85918, 33.75024], [-117.85907, 33.75004], [-117.85927, 33.75002], [-117.85936, 33.75016]]]} | Open Access 1 | 48845 | Garfield Exercise | 33565 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | https://www.santa-ana.org/parks/parks-location/garfield-exercise | Orange 3 | 0.096 | Garfield Exercise | None 344 | ||
4152 | 4152 | 4151 | {"type": "Polygon", "coordinates": [[[-117.97658, 33.91104], [-117.97658, 33.91143], [-117.97591, 33.91182], [-117.97546, 33.91214], [-117.96943, 33.91722], [-117.96887, 33.91721], [-117.97303, 33.91372], [-117.97303, 33.9137], [-117.97384, 33.91309], [-117.9751, 33.91199], [-117.97561, 33.91162], [-117.97658, 33.91104]]]} | Open Access 1 | 48288 | Coyote Creek Bikeway | 32861 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.lhcm.org/386/Bikeways | Orange 3 | 8.381 | Coyote Creek Bikeway | 2011 | None 358 | |
4291 | 4291 | 4290 | {"type": "Polygon", "coordinates": [[[-117.96399, 33.63508], [-117.96237, 33.63687], [-117.96074, 33.63584], [-117.95743, 33.63372], [-117.958, 33.63182], [-117.96399, 33.63508]]]} | Unknown Access 4 | 14646 | Talbert Marsh | 26170 | 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 | 34.691 | Talbert Marsh | None 375 | |||
4843 | 4843 | 4842 | {"type": "Polygon", "coordinates": [[[-117.8722, 33.59222], [-117.87161, 33.59281], [-117.87148, 33.59262], [-117.87135, 33.59248], [-117.87115, 33.59212], [-117.87162, 33.59175], [-117.8722, 33.59222]]]} | Open Access 1 | 2168 | Inspiration Point | 20222 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 1.448 | Inspiration Point | None 405 | |||
5270 | 5270 | 5269 | {"type": "Polygon", "coordinates": [[[-117.78541, 33.90474], [-117.7852, 33.90483], [-117.78511, 33.90484], [-117.78479, 33.9047], [-117.78462, 33.90466], [-117.78444, 33.90463], [-117.78409, 33.90462], [-117.78399, 33.90459], [-117.78389, 33.90453], [-117.78375, 33.90428], [-117.78342, 33.9044], [-117.78343, 33.90367], [-117.78306, 33.90367], [-117.78344, 33.90343], [-117.78346, 33.90345], [-117.78358, 33.90344], [-117.78388, 33.9037], [-117.78402, 33.90378], [-117.78417, 33.90384], [-117.78457, 33.90395], [-117.78477, 33.90406], [-117.78488, 33.90416], [-117.78532, 33.90462], [-117.78541, 33.90474]]]} | Open Access 1 | 47381 | Quarterhorse Staging Area | 31104 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 3.406 | Quarterhorse Staging Area | None 425 | |||
5510 | 5510 | 5509 | {"type": "Polygon", "coordinates": [[[-117.83634, 33.58461], [-117.83594, 33.58498], [-117.83559, 33.58538], [-117.8353, 33.58581], [-117.83507, 33.58626], [-117.83418, 33.58568], [-117.83411, 33.58547], [-117.83418, 33.58524], [-117.83466, 33.58521], [-117.83482, 33.58515], [-117.83517, 33.58471], [-117.83546, 33.58475], [-117.83576, 33.58467], [-117.83598, 33.58445], [-117.83609, 33.5844], [-117.83634, 33.58461]]]} | Open Access 1 | 47417 | Los Trancos Canyon View Park (Lower) | 31134 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 4.083 | Los Trancos Canyon View Park (Lower) | None 447 | |||
5615 | 5615 | 5614 | {"type": "Polygon", "coordinates": [[[-117.76036, 33.6333], [-117.76003, 33.63457], [-117.75946, 33.63534], [-117.75959, 33.6366], [-117.75799, 33.63627], [-117.75777, 33.63505], [-117.75816, 33.6341], [-117.75829, 33.63301], [-117.75797, 33.63238], [-117.75941, 33.63136], [-117.7596, 33.63046], [-117.75905, 33.62932], [-117.75748, 33.62811], [-117.75568, 33.62795], [-117.75455, 33.62681], [-117.75287, 33.62703], [-117.75232, 33.62772], [-117.75125, 33.62754], [-117.75066, 33.62795], [-117.75052, 33.62877], [-117.75004, 33.62956], [-117.75011, 33.62997], [-117.75038, 33.63063], [-117.75039, 33.63152], [-117.75084, 33.63193], [-117.75088, 33.63311], [-117.75252, 33.63418], [-117.75221, 33.63484], [-117.75027, 33.63452], [-117.74936, 33.63421], [-117.7489, 33.63359], [-117.74782, 33.63285], [-117.74759, 33.63246], [-117.74669, 33.63253], [-117.74542, 33.63182], [-117.74514, 33.63121], [-117.74443, 33.63138], [-117.74373, 33.6308], [-117.74323, 33.63067], [-117.74136, 33.63063], [-117.74312, 33.6255], [-117.74522, 33.62259], [-117.74536, 33.6226], [-117.74545, 33.62255], [-117.7455, 33.6224], [-117.74551, 33.62219], [-117.74782, 33.61898], [-117.75092, 33.62051], [-117.75177, 33.62228], [-117.75343, 33.62336], [-117.75265, 33.62571], [-117.75349, 33.62666], [-117.75634, 33.62553], [-117.75672, 33.6262], [-117.75716, 33.62638], [-117.75796, 33.62735], [-117.75843, 33.62773], [-117.76007, 33.62971], [-117.76009, 33.62994], [-117.76033, 33.63064], [-117.75978, 33.63132], [-117.75978, 33.63168], [-117.75996, 33.63186], [-117.75977, 33.63245], [-117.76002, 33.63296], [-117.76036, 33.6333]]]} | No Public Access 3 | 47477 | Veeh Creek | 31199 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 3257 | Irvine Ranch Conservancy 790 | Non Profit 6 | Non Profit - Conservation 12 | Orange 3 | 309.589 | Veeh Creek | None 452 | |||
6044 | 6044 | 6043 | {"type": "Polygon", "coordinates": [[[-117.91151, 33.7586], [-117.91145, 33.75859], [-117.91145, 33.75857], [-117.91141, 33.75856], [-117.90784, 33.75858], [-117.90784, 33.75854], [-117.90788, 33.75851], [-117.90879, 33.7585], [-117.90885, 33.75851], [-117.9089, 33.75855], [-117.90895, 33.75855], [-117.90902, 33.75851], [-117.90909, 33.7585], [-117.9091, 33.75844], [-117.9095, 33.75843], [-117.9095, 33.75847], [-117.90952, 33.7585], [-117.90966, 33.75855], [-117.90972, 33.75854], [-117.90975, 33.7585], [-117.91142, 33.75849], [-117.91149, 33.75852], [-117.91151, 33.75854], [-117.91151, 33.7586]]]} | Open Access 1 | 47357 | Jardín de Los Niños | 31077 | 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 | 0.684 | Jardín de Los Niños | None 488 | |||
6651 | 6651 | 6650 | {"type": "Polygon", "coordinates": [[[-117.87837, 33.59536], [-117.87829, 33.59549], [-117.87823, 33.59548], [-117.87796, 33.59574], [-117.87786, 33.59557], [-117.87787, 33.59553], [-117.87785, 33.5955], [-117.87783, 33.59546], [-117.87777, 33.59543], [-117.87717, 33.5953], [-117.87709, 33.59527], [-117.87713, 33.59521], [-117.87725, 33.59517], [-117.87731, 33.59512], [-117.87751, 33.5951], [-117.87769, 33.59511], [-117.87775, 33.59511], [-117.87787, 33.59515], [-117.87794, 33.5952], [-117.87806, 33.59524], [-117.87806, 33.59527], [-117.87812, 33.59531], [-117.87813, 33.59538], [-117.87817, 33.59535], [-117.87831, 33.59533], [-117.87837, 33.59536]]]} | Open Access 1 | 4684 | Lookout Point | 21462 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 0.842 | Lookout Point | None 539 | |||
7528 | 7528 | 7527 | {"type": "Polygon", "coordinates": [[[-117.81163, 33.90348], [-117.81127, 33.90335], [-117.81104, 33.90329], [-117.81069, 33.90324], [-117.8101, 33.90324], [-117.81004, 33.90322], [-117.81002, 33.90317], [-117.80999, 33.90318], [-117.80995, 33.90325], [-117.80988, 33.9033], [-117.80931, 33.90356], [-117.80928, 33.9036], [-117.80922, 33.90359], [-117.80926, 33.90352], [-117.80943, 33.90341], [-117.80943, 33.90339], [-117.8097, 33.90319], [-117.80979, 33.90305], [-117.80979, 33.90293], [-117.80973, 33.90281], [-117.80962, 33.90273], [-117.80944, 33.90265], [-117.80953, 33.9025], [-117.8095, 33.90244], [-117.8095, 33.90239], [-117.80973, 33.90208], [-117.80977, 33.902], [-117.80979, 33.90187], [-117.80974, 33.90172], [-117.81005, 33.9018], [-117.81038, 33.90185], [-117.81121, 33.90181], [-117.81124, 33.90227], [-117.8113, 33.90257], [-117.81127, 33.90259], [-117.81142, 33.90304], [-117.81163, 33.90348]]]} | Open Access 1 | 47607 | Vista Del Verde Park II | 31337 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 6.316 | Vista Del Verde Park II | None 626 | |||
7727 | 7727 | 7726 | {"type": "MultiPolygon", "coordinates": [[[[-117.82839, 33.86663], [-117.82839, 33.86673], [-117.82832, 33.86674], [-117.82833, 33.86745], [-117.82612, 33.86721], [-117.82611, 33.86658], [-117.82754, 33.86672], [-117.82801, 33.8667], [-117.82839, 33.86663]]], [[[-117.82839, 33.86643], [-117.82805, 33.8665], [-117.82797, 33.86651], [-117.82799, 33.86633], [-117.82817, 33.86636], [-117.82838, 33.86637], [-117.82839, 33.86643]]]]} | Open Access 1 | 8004 | Parque de Los Ninos | 23474 | 1255 | Placentia, City of 241 | City 2 | City Agency 2 | http://www.placentia.org/ | City 2 | 1255 | Placentia, City of 237 | City 2 | City Agency 2 | Orange 3 | 3.87 | Parque de Los Ninos | None 640 | |||
7728 | 7728 | 7727 | {"type": "Polygon", "coordinates": [[[-117.83548, 33.88305], [-117.83543, 33.88311], [-117.83528, 33.88367], [-117.83528, 33.88412], [-117.83495, 33.88412], [-117.83476, 33.88485], [-117.83469, 33.88523], [-117.83453, 33.88556], [-117.8339, 33.88557], [-117.83386, 33.88421], [-117.83394, 33.8842], [-117.83392, 33.88275], [-117.83543, 33.88274], [-117.83543, 33.88301], [-117.83548, 33.88305]]]} | Open Access 1 | 8013 | Parque De Los Vaqueros | 23476 | 1255 | Placentia, City of 241 | City 2 | City Agency 2 | http://www.placentia.org/ | City 2 | 1255 | Placentia, City of 237 | City 2 | City Agency 2 | Orange 3 | 8.188 | Parque De Los Vaqueros | None 641 | |||
7939 | 7939 | 7938 | {"type": "Polygon", "coordinates": [[[-117.95634, 33.63093], [-117.95288, 33.64311], [-117.95175, 33.64313], [-117.95345, 33.63665], [-117.95199, 33.63459], [-117.95135, 33.63437], [-117.95087, 33.63372], [-117.95103, 33.63333], [-117.94856, 33.63291], [-117.94753, 33.63218], [-117.94809, 33.6321], [-117.94897, 33.63202], [-117.94984, 33.6315], [-117.95035, 33.63024], [-117.95123, 33.6295], [-117.95193, 33.62931], [-117.9528, 33.62956], [-117.95343, 33.62978], [-117.95493, 33.63058], [-117.95634, 33.63093]]]} | Open Access 1 | 10770 | Salt Marsh Restoration | 24811 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Orange 3 | 101.681 | Salt Marsh Restoration | None 660 | |||
10317 | 10317 | 10316 | {"type": "MultiPolygon", "coordinates": [[[[-117.8706, 33.59013], [-117.87007, 33.59064], [-117.86982, 33.5906], [-117.86959, 33.59053], [-117.8691, 33.59032], [-117.869, 33.59031], [-117.86885, 33.59034], [-117.86877, 33.5904], [-117.86871, 33.5905], [-117.86868, 33.59094], [-117.86866, 33.59102], [-117.86861, 33.59106], [-117.86852, 33.5911], [-117.86843, 33.59106], [-117.86835, 33.59042], [-117.86852, 33.59], [-117.86847, 33.5899], [-117.86856, 33.58971], [-117.8687, 33.58967], [-117.8688, 33.58974], [-117.86914, 33.5899], [-117.87023, 33.59023], [-117.87031, 33.59023], [-117.87038, 33.59021], [-117.87057, 33.5901], [-117.8706, 33.59013]]], [[[-117.87892, 33.59465], [-117.87812, 33.59539], [-117.87812, 33.59531], [-117.87806, 33.59527], [-117.87806, 33.59524], [-117.87775, 33.59511], [-117.87751, 33.5951], [-117.87731, 33.59512], [-117.87749, 33.59492], [-117.87749, 33.59491], [-117.8774, 33.5949], [-117.87659, 33.59464], [-117.87665, 33.59455], [-117.87628, 33.59442], [-117.87591, 33.59438], [-117.87523, 33.59415], [-117.87502, 33.59405], [-117.87474, 33.59381], [-117.8746, 33.59372], [-117.87347, 33.59324], [-117.87344, 33.59319], [-117.87347, 33.59314], [-117.87347, 33.59313], [-117.87336, 33.5931], [-117.87331, 33.59312], [-117.87326, 33.59315], [-117.87292, 33.593], [-117.87227, 33.59253], [-117.87219, 33.59241], [-117.87283, 33.59177], [-117.87592, 33.59277], [-117.87567, 33.59302], [-117.87567, 33.59304], [-117.87609, 33.59303], [-117.87629, 33.59301], [-117.87655, 33.59295], [-117.87738, 33.59271], [-117.87752, 33.59264], [-117.87777, 33.59345], [-117.87737, 33.59387], [-117.87833, 33.59418], [-117.87892, 33.59465]]], [[[-117.879, 33.5953], [-117.87875, 33.59556], [-117.87849, 33.59528], [-117.87876, 33.59503], [-117.879, 33.5953]]], [[[-117.87931, 33.59682], [-117.87926, 33.59686], [-117.87883, 33.59624], [-117.87918, 33.59589], [-117.87931, 33.59682]]], [[[-117.8791, 33.59522], [-117.87897, 33.59509], [-117.87907, 33.59499], [-117.87907, 33.59499], [-117.8791, 33.59522]]], [[[-117.92258, 33.605], [-117.92234, 33.60631], [-117.9205, 33.60596], [-117.91953, 33.60583], [-117.91983, 33.60447], [-117.92177, 33.60487], [-117.92258, 33.605]]]]} | Open Access 1 | 18153 | Corona del Mar State Beach | 30629 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.parks.ca.gov/default.asp?page_id=652 | Orange 3 | 35.886 | Corona del Mar SB | 1947 | None 903 |
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]);