units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,196 rows where COUNTY = 3 sorted by MNG_AG_LEV
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Irvine, City of 101
- Orange, County of 95
- Huntington Beach, City of 75
- Newport Beach, City of 62
- Anaheim, City of 58
- Fullerton, City of 57
- Mission Viejo, City of 47
- Santa Ana, City of 44
- Costa Mesa, City of 31
- Lake Forest, City of 31
- Woodbridge Village Association 31
- Laguna Niguel, City of 29
- Yorba Linda, City of 28
- Westminster, City of 24
- San Clemente, City of 24
- San Juan Capistrano, City of 22
- La Habra, City of 22
- Dana Point, City of 21
- Fountain Valley, City of 21
- Orange, City of 20
- Cypress, City of 19
- Rancho Santa Margarita Landscape and Recreation Corporation 18
- Garden Grove, City of 17
- Laguna Beach, City of 17
- Aliso Viejo, City of 17
- Placentia, City of 16
- Tustin, City of 16
- Brea, City of 15
- Laguna Hills, City of 13
- Seal Beach, City of 12
- …
DES_TP >30
- Local Park 777
- Private Recreation or Education 143
- Local Recreation Area 91
- 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
- None 1
- None 1
- State Resource Management Area 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
- None 1
- None 1
- …
MNG_AG_TYP 11
ACCESS_TYP 4
- Open Access 992
- Restricted Access 177
- 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
334 | 334 | 333 | {"type": "Polygon", "coordinates": [[[-118.01117, 33.86901], [-118.00852, 33.86905], [-118.0085, 33.86928], [-118.00512, 33.86932], [-118.00511, 33.86863], [-118.0042, 33.86862], [-118.0042, 33.86848], [-118.00834, 33.86842], [-118.00833, 33.86716], [-118.01114, 33.86713], [-118.01117, 33.86901]]]} | Open Access 1 | 913 | George Bellis Park | 19259 | 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 | 20.977 | George Bellis Park | 0 | Local Park 2 | 4 | |
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 | |||
376 | 376 | 375 | {"type": "Polygon", "coordinates": [[[-118.01093, 33.77007], [-118.01083, 33.77015], [-118.01069, 33.77031], [-118.01061, 33.77047], [-118.01056, 33.77071], [-118.01055, 33.77119], [-118.01052, 33.77121], [-118.01012, 33.77121], [-118.01011, 33.76991], [-118.01073, 33.76991], [-118.01093, 33.77007]]]} | Open Access 1 | 1108 | Goldenwest Park | 19378 | 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.77 | Goldenwest Park | 0 | Local Park 2 | 4 | |
386 | 386 | 385 | {"type": "Polygon", "coordinates": [[[-118.05417, 33.72241], [-118.05416, 33.72158], [-118.05339, 33.72158], [-118.05338, 33.72109], [-118.05364, 33.72108], [-118.05364, 33.72069], [-118.05357, 33.72068], [-118.05357, 33.72042], [-118.05361, 33.72031], [-118.05367, 33.72022], [-118.05376, 33.72014], [-118.054, 33.72003], [-118.05407, 33.72006], [-118.05425, 33.7205], [-118.05433, 33.72078], [-118.05441, 33.72126], [-118.05443, 33.72234], [-118.0544, 33.72239], [-118.05436, 33.72241], [-118.05417, 33.72241]]]} | Open Access 1 | 1408 | Harbour View Park | 19671 | 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 | 3.406 | Harbour View Park | 0 | Local Park 2 | 4 | |
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 | |||
420 | 420 | 419 | {"type": "Polygon", "coordinates": [[[-117.97183, 33.79249], [-117.97103, 33.79199], [-117.97103, 33.79179], [-117.97112, 33.79178], [-117.97112, 33.79137], [-117.97181, 33.79137], [-117.97183, 33.79249]]]} | Open Access 1 | 1294 | Gutosky Park | 19574 | 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 | 1.639 | Gutosky Park | 0 | Local Park 2 | 4 | |
461 | 461 | 460 | {"type": "Polygon", "coordinates": [[[-117.87133, 33.59796], [-117.87133, 33.59796], [-117.87119, 33.59799], [-117.8713, 33.59788], [-117.87133, 33.59796]]]} | Open Access 1 | 47411 | Corona del Mar Pocket Park | 31210 | 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.015 | Corona del Mar PP | 0 | Local Park 2 | 4 | |
463 | 463 | 462 | {"type": "Polygon", "coordinates": [[[-117.95893, 33.6679], [-117.95781, 33.6679], [-117.9578, 33.66708], [-117.95781, 33.66704], [-117.95787, 33.66701], [-117.95834, 33.66699], [-117.95844, 33.66703], [-117.95854, 33.66704], [-117.95857, 33.66703], [-117.95862, 33.66697], [-117.95864, 33.66689], [-117.95891, 33.66689], [-117.95893, 33.6679]]]} | Open Access 1 | 1536 | Hawes Park | 19742 | 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/hawes-park.cfm | Orange 3 | 2.599 | Hawes Park | 0 | Local Park 2 | 4 |
469 | 469 | 468 | {"type": "Polygon", "coordinates": [[[-118.04595, 33.72971], [-118.04398, 33.72972], [-118.04391, 33.72969], [-118.0439, 33.72907], [-118.04415, 33.72896], [-118.04415, 33.72858], [-118.04461, 33.72858], [-118.04462, 33.72874], [-118.04481, 33.72873], [-118.04482, 33.72859], [-118.0449, 33.72859], [-118.04491, 33.72892], [-118.04501, 33.72893], [-118.04502, 33.72962], [-118.04595, 33.72962], [-118.04595, 33.72971]]]} | Open Access 1 | 1517 | Haven View Park | 19741 | 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/haven-view-park.cfm | Orange 3 | 2.961 | Haven View Park | 0 | Local Park 2 | 4 |
483 | 483 | 482 | {"type": "Polygon", "coordinates": [[[-117.79494, 33.54528], [-117.79484, 33.54519], [-117.79463, 33.54506], [-117.79443, 33.545], [-117.7943, 33.54498], [-117.7942, 33.54497], [-117.79419, 33.545], [-117.79379, 33.54502], [-117.79354, 33.54507], [-117.79338, 33.54507], [-117.79314, 33.545], [-117.793, 33.54492], [-117.79289, 33.54476], [-117.79287, 33.54445], [-117.79285, 33.54437], [-117.79147, 33.54389], [-117.79121, 33.54389], [-117.79108, 33.54395], [-117.79091, 33.54399], [-117.79071, 33.54396], [-117.7906, 33.54391], [-117.78938, 33.54318], [-117.78923, 33.54314], [-117.78914, 33.54313], [-117.78904, 33.54313], [-117.78883, 33.54317], [-117.78867, 33.54264], [-117.78881, 33.5426], [-117.78904, 33.54265], [-117.78916, 33.5427], [-117.78934, 33.54284], [-117.78938, 33.54289], [-117.78957, 33.54299], [-117.78973, 33.54305], [-117.78995, 33.54322], [-117.79055, 33.54337], [-117.79085, 33.54341], [-117.79098, 33.54342], [-117.7914, 33.54336], [-117.79166, 33.54341], [-117.79189, 33.54326], [-117.79212, 33.54306], [-117.79238, 33.54303], [-117.79248, 33.54315], [-117.79251, 33.54313], [-117.79258, 33.54311], [-117.79259, 33.54328], [-117.79272, 33.54367], [-117.79279, 33.54374], [-117.79286, 33.5438], [-117.79295, 33.54392], [-117.79308, 33.54402], [-117.79309, 33.54407], [-117.79316, 33.54413], [-117.79317, 33.54416], [-117.79327, 33.54427], [-117.79331, 33.54435], [-117.79342, 33.5444], [-117.79347, 33.54445], [-117.7938, 33.54459], [-117.79405, 33.54473], [-117.79451, 33.54496], [-117.7946, 33.54492], [-117.79467, 33.54485], [-117.79484, 33.54474], [-117.79494, 33.54528]]]} | Open Access 1 | 1660 | Heisler Park | 19795 | 1164 | Laguna Beach, City of 181 | City 2 | City Agency 2 | http://www.lagunabeachcity.net/cityhall/pw/parks.asp | City 2 | 1164 | Laguna Beach, City of 177 | City 2 | City Agency 2 | Orange 3 | 8.492 | Heisler Park | 0 | Local Park 2 | 4 | |
486 | 486 | 485 | {"type": "Polygon", "coordinates": [[[-117.6813, 33.61079], [-117.681, 33.61102], [-117.68099, 33.61113], [-117.68092, 33.61115], [-117.68084, 33.61123], [-117.68084, 33.61127], [-117.68089, 33.61133], [-117.68067, 33.61153], [-117.6799, 33.61034], [-117.67975, 33.60987], [-117.67944, 33.60924], [-117.67845, 33.60767], [-117.67894, 33.60821], [-117.67928, 33.60801], [-117.67933, 33.60807], [-117.6795, 33.60811], [-117.67961, 33.60776], [-117.67961, 33.60741], [-117.67972, 33.6074], [-117.68084, 33.60876], [-117.68058, 33.60894], [-117.68053, 33.60895], [-117.6805, 33.60894], [-117.68035, 33.60879], [-117.68028, 33.60876], [-117.68018, 33.60875], [-117.68012, 33.60877], [-117.68003, 33.60883], [-117.68002, 33.6089], [-117.6801, 33.60897], [-117.6802, 33.60896], [-117.67984, 33.6092], [-117.6813, 33.61079]]]} | Open Access 1 | 1948 | Bart Spendlove Park | 15840 | 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 | 8.707 | Bart Spendlove Park | 0 | Local Park 2 | 4 | |
489 | 489 | 488 | {"type": "Polygon", "coordinates": [[[-117.98565, 33.69303], [-117.98466, 33.69303], [-117.98465, 33.69223], [-117.98564, 33.69223], [-117.98565, 33.69303]]]} | Open Access 1 | 1686 | Helme Park | 19809 | 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/helme-park.cfm | Orange 3 | 2.001 | Helme Park | 0 | Local Park 2 | 4 |
550 | 550 | 549 | {"type": "Polygon", "coordinates": [[[-117.96304, 33.93707], [-117.96271, 33.93783], [-117.96286, 33.93844], [-117.962, 33.93833], [-117.96201, 33.93921], [-117.96076, 33.9391], [-117.96087, 33.9381], [-117.96051, 33.93774], [-117.96048, 33.93721], [-117.96059, 33.9372], [-117.96056, 33.93693], [-117.96068, 33.93645], [-117.96048, 33.93547], [-117.96238, 33.93547], [-117.96291, 33.93606], [-117.96304, 33.93707]]]} | Open Access 1 | 3043 | La Bonita Park | 20742 | 1155 | La Habra, City of 203 | City 2 | City Agency 2 | http://www.ci.la-habra.ca.us/section.cfm?id=79 | City 2 | 1155 | La Habra, City of 199 | City 2 | City Agency 2 | Orange 3 | 18.853 | La Bonita Park | 0 | Local Park 2 | 4 | |
577 | 577 | 576 | {"type": "Polygon", "coordinates": [[[-117.99805, 33.66886], [-117.99804, 33.66848], [-117.99808, 33.66842], [-117.99819, 33.66832], [-117.99832, 33.66824], [-117.99846, 33.66819], [-117.99862, 33.66816], [-117.99885, 33.66818], [-117.99927, 33.66828], [-117.99968, 33.66832], [-118.00008, 33.66831], [-118.00047, 33.66825], [-118.00052, 33.66829], [-118.00068, 33.66868], [-118.00066, 33.66872], [-118.00061, 33.66874], [-118.00042, 33.66871], [-118.00025, 33.6687], [-118.0, 33.66874], [-117.99983, 33.66879], [-117.99953, 33.66895], [-117.99934, 33.66902], [-117.99913, 33.66907], [-117.99893, 33.66909], [-117.99872, 33.66908], [-117.99851, 33.66905], [-117.99832, 33.66899], [-117.99805, 33.66886]]]} | Open Access 1 | 3456 | Lake Park | 20959 | 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/lake-park.cfm | Orange 3 | 4.224 | Lake Park | 0 | Local Park 2 | 4 |
580 | 580 | 579 | {"type": "Polygon", "coordinates": [[[-118.01718, 33.70818], [-118.01661, 33.70819], [-118.01657, 33.70552], [-118.01715, 33.70552], [-118.01718, 33.70818]]]} | Open Access 1 | 1928 | Hope View Park | 20087 | 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 | 3.924 | Hope View Park | 0 | Local Park 2 | 4 | |
594 | 594 | 593 | {"type": "Polygon", "coordinates": [[[-118.04559, 33.82791], [-118.04349, 33.82792], [-118.04347, 33.82704], [-118.04558, 33.82702], [-118.04559, 33.82791]]]} | Open Access 1 | 4066 | Evergreen Park | 18766 | 1077 | Cypress, City of 218 | City 2 | City Agency 2 | http://www.ci.cypress.ca.us/ | City 2 | 1077 | Cypress, City of 214 | City 2 | City Agency 2 | Orange 3 | 4.743 | Evergreen Park | 0 | Local Park 2 | 4 | |
598 | 598 | 597 | {"type": "Polygon", "coordinates": [[[-117.92689, 33.61603], [-117.92681, 33.61619], [-117.92653, 33.6162], [-117.92643, 33.61603], [-117.92689, 33.61603]]]} | Open Access 1 | 4130 | Lido Park | 21228 | 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.157 | Lido Park | 0 | Local Park 2 | 4 | |
599 | 599 | 598 | {"type": "MultiPolygon", "coordinates": [[[[-118.00637, 33.70704], [-118.00631, 33.70705], [-118.00632, 33.70813], [-118.00629, 33.70817], [-118.00622, 33.7082], [-118.00432, 33.70821], [-118.00429, 33.70711], [-118.00008, 33.70717], [-118.00006, 33.7058], [-118.0, 33.70579], [-117.99998, 33.70472], [-118.00005, 33.70471], [-118.00004, 33.70396], [-118.0008, 33.70395], [-118.00129, 33.70372], [-118.00219, 33.70362], [-118.00217, 33.70308], [-118.00194, 33.7031], [-118.00167, 33.70337], [-118.00136, 33.70337], [-118.00136, 33.70257], [-118.00183, 33.70257], [-118.00181, 33.70184], [-118.00233, 33.70183], [-118.00232, 33.70108], [-118.0, 33.70109], [-118.0, 33.70102], [-117.99993, 33.70101], [-117.99991, 33.69928], [-118.00249, 33.69926], [-118.00246, 33.69746], [-118.00199, 33.69746], [-118.00194, 33.69392], [-118.00332, 33.6939], [-118.00333, 33.69393], [-118.00343, 33.69393], [-118.00343, 33.6939], [-118.00618, 33.69387], [-118.0062, 33.69471], [-118.00613, 33.69472], [-118.00615, 33.6956], [-118.00621, 33.69561], [-118.00625, 33.69833], [-118.00618, 33.69834], [-118.00622, 33.70105], [-118.00629, 33.70581], [-118.00635, 33.70582], [-118.00637, 33.70704]], [[-118.00621, 33.70812], [-118.00622, 33.70811], [-118.00621, 33.70738], [-118.00561, 33.70738], [-118.0054, 33.70756], [-118.0054, 33.70812], [-118.00621, 33.70812]]], [[[-118.01501, 33.69733], [-118.01496, 33.69734], [-118.01498, 33.69916], [-118.01287, 33.69918], [-118.01286, 33.69895], [-118.01285, 33.69894], [-118.01201, 33.69947], [-118.01143, 33.69976], [-118.01071, 33.70021], [-118.01077, 33.70465], [-118.0066, 33.70468], [-118.00647, 33.69562], [-118.00641, 33.69561], [-118.00639, 33.6947], [-118.00646, 33.69469], [-118.00645, 33.69399], [-118.00648, 33.69392], [-118.00655, 33.6939], [-118.00844, 33.69388], [-118.00845, 33.69382], [-118.01044, 33.6938], [-118.01045, 33.69441], [-118.01052, 33.69442], [-118.01052, 33.6938], [-118.01269, 33.69378], [-118.0127, 33.6944], [-118.01172, 33.69441], [-118.01172, 33.69451], [-118.0127, 33.69451], [-118.01271, 33.69512], [-118.01173, 33.69513], [-118.01173, 33.69523], [-118.01271, 33.69523], [-118.01272, 33.69585], [-118.01174, 33.69586], [-118.01174, 33.69596], [-118.01272, 33.69596], [-118.01273, 33.69657], [-118.01174, 33.69659], [-118.01175, 33.69669], [-118.01273, 33.69668], [-118.01274, 33.6973], [-118.01176, 33.69731], [-118.01175, 33.69735], [-118.01283, 33.69735], [-118.01284, 33.69734], [-118.01279, 33.69378], [-118.01387, 33.69377], [-118.01389, 33.6938], [-118.01496, 33.69379], [-118.01501, 33.69733]], [[-118.01054, 33.69556], [-118.01054, 33.69526], [-118.01039, 33.69526], [-118.01038, 33.69556], [-118.01054, 33.69556]], [[-118.01046, 33.69513], [-118.01054, 33.69514], [-118.01052, 33.69453], [-118.01045, 33.69454], [-118.01046, 33.69513]]]]} | Open Access 1 | 2039 | Huntington Beach Central Park | 29219 | 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/huntington_central_park/ | Orange 3 | 345.196 | Huntington Beach Central Park | 0 | Local Park 2 | 4 |
613 | 613 | 612 | {"type": "Polygon", "coordinates": [[[-117.78491, 33.54955], [-117.78414, 33.55079], [-117.78423, 33.55139], [-117.78521, 33.55172], [-117.78521, 33.55216], [-117.7844, 33.55218], [-117.78361, 33.55264], [-117.78281, 33.55131], [-117.7828, 33.55064], [-117.78316, 33.54924], [-117.78315, 33.54915], [-117.78312, 33.54907], [-117.78306, 33.549], [-117.78298, 33.54894], [-117.78288, 33.54891], [-117.78278, 33.5489], [-117.78267, 33.54892], [-117.78254, 33.54899], [-117.78244, 33.54902], [-117.78198, 33.54907], [-117.78183, 33.54903], [-117.78149, 33.54887], [-117.78196, 33.54818], [-117.78208, 33.54793], [-117.78219, 33.54767], [-117.78279, 33.54808], [-117.78288, 33.54804], [-117.78318, 33.54747], [-117.78328, 33.5475], [-117.7834, 33.54727], [-117.78377, 33.5474], [-117.78351, 33.54788], [-117.78359, 33.548], [-117.78395, 33.54732], [-117.78431, 33.54745], [-117.78389, 33.54825], [-117.78387, 33.54836], [-117.78386, 33.54846], [-117.78404, 33.54873], [-117.7841, 33.54869], [-117.78402, 33.54856], [-117.78399, 33.5484], [-117.78401, 33.5483], [-117.7841, 33.54812], [-117.78446, 33.54826], [-117.78437, 33.54848], [-117.78437, 33.54858], [-117.78438, 33.54867], [-117.78442, 33.54873], [-117.78449, 33.54879], [-117.7847, 33.54888], [-117.78485, 33.549], [-117.78494, 33.54915], [-117.78498, 33.54936], [-117.78496, 33.54946], [-117.78491, 33.54955]]]} | Open Access 1 | 2211 | Irvine Bowl Park | 20237 | 1164 | Laguna Beach, City of 181 | City 2 | City Agency 2 | http://www.lagunabeachcity.net/cityhall/pw/parks.asp | City 2 | 1164 | Laguna Beach, City of 177 | City 2 | City Agency 2 | Orange 3 | 22.501 | Irvine Bowl Park | 0 | Local Park 2 | 4 | |
623 | 623 | 622 | {"type": "MultiPolygon", "coordinates": [[[[-117.78673, 33.54375], [-117.7867, 33.54378], [-117.78639, 33.54383], [-117.78598, 33.54395], [-117.78559, 33.54408], [-117.78529, 33.54424], [-117.78506, 33.54438], [-117.78457, 33.54475], [-117.78442, 33.54482], [-117.78426, 33.54487], [-117.78487, 33.54438], [-117.78525, 33.54413], [-117.78586, 33.54388], [-117.78642, 33.54371], [-117.78662, 33.54368], [-117.78669, 33.5437], [-117.78673, 33.54375]]], [[[-117.78787, 33.54378], [-117.78747, 33.54374], [-117.78715, 33.54373], [-117.78702, 33.54373], [-117.78683, 33.54376], [-117.7868, 33.54374], [-117.78677, 33.54369], [-117.78703, 33.54363], [-117.78703, 33.54357], [-117.78714, 33.54356], [-117.78717, 33.54352], [-117.78787, 33.54378]]]]} | Open Access 1 | 2393 | Jahraus Park | 20336 | 1164 | Laguna Beach, City of 181 | City 2 | City Agency 2 | http://www.lagunabeachcity.net/cityhall/pw/parks.asp | City 2 | 1164 | Laguna Beach, City of 177 | City 2 | City Agency 2 | Orange 3 | 0.988 | Jahraus 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]);