units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,196 rows where COUNTY = 3 sorted by YR_EST
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, LAYER, YR_EST
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 | |||
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 | ||
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 | |||
10672 | 10672 | 10671 | {"type": "Polygon", "coordinates": [[[-117.70798, 33.89469], [-117.70763, 33.89501], [-117.70756, 33.89497], [-117.6896, 33.88395], [-117.68955, 33.87758], [-117.68999, 33.87756], [-117.69017, 33.87753], [-117.68986, 33.87846], [-117.69036, 33.87883], [-117.69094, 33.87959], [-117.69101, 33.87994], [-117.69144, 33.88007], [-117.69149, 33.88026], [-117.69222, 33.88034], [-117.69362, 33.88074], [-117.69522, 33.88101], [-117.69761, 33.88188], [-117.69825, 33.88174], [-117.69787, 33.88072], [-117.69774, 33.88003], [-117.69764, 33.87981], [-117.69742, 33.87946], [-117.69725, 33.87887], [-117.69723, 33.87866], [-117.69792, 33.87846], [-117.69814, 33.87842], [-117.69824, 33.87841], [-117.69827, 33.87883], [-117.69842, 33.87918], [-117.69873, 33.87965], [-117.69886, 33.88043], [-117.69922, 33.88154], [-117.70225, 33.8805], [-117.70271, 33.8803], [-117.70297, 33.88028], [-117.70342, 33.8806], [-117.70394, 33.88052], [-117.70446, 33.88055], [-117.7046, 33.88086], [-117.70473, 33.88125], [-117.70486, 33.88142], [-117.70558, 33.88204], [-117.70583, 33.88146], [-117.70629, 33.8814], [-117.70629, 33.8815], [-117.70613, 33.88256], [-117.70533, 33.88246], [-117.70508, 33.88385], [-117.70563, 33.88432], [-117.70543, 33.88526], [-117.705, 33.88518], [-117.70423, 33.8845], [-117.70265, 33.88468], [-117.70271, 33.8855], [-117.7031, 33.88682], [-117.7036, 33.88747], [-117.70282, 33.88808], [-117.70342, 33.89001], [-117.70382, 33.8902], [-117.70441, 33.89015], [-117.70684, 33.89051], [-117.7076, 33.89152], [-117.70742, 33.89317], [-117.70772, 33.89317], [-117.70738, 33.89424], [-117.70798, 33.89469]]]} | Open Access 1 | 19014 | Brush Canyon | 8044 | 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 | 320.468 | Brush Canyon | None 938 | |||
10795 | 10795 | 10794 | {"type": "Polygon", "coordinates": [[[-117.69676, 33.51276], [-117.69672, 33.51276], [-117.69655, 33.51282], [-117.6963, 33.51294], [-117.69525, 33.51353], [-117.69519, 33.51348], [-117.69554, 33.51322], [-117.69554, 33.51316], [-117.69532, 33.51314], [-117.69535, 33.5131], [-117.69554, 33.51277], [-117.69562, 33.51269], [-117.69573, 33.51263], [-117.69638, 33.51263], [-117.69652, 33.51265], [-117.69676, 33.51276]]]} | Open Access 1 | 20186 | Parc Vista Overlook | 23413 | 1166 | Laguna Niguel, City of 532 | City 2 | City Agency 2 | http://www.cityoflagunaniguel.org/index.aspx?nid=12 | City 2 | 1166 | Laguna Niguel, City of 525 | City 2 | City Agency 2 | Orange 3 | 1.363 | Parc Vista Overlook | None 942 | |||
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 |
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]);