units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,196 rows where COUNTY = 3 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
5225 | 5225 | 5224 | {"type": "Polygon", "coordinates": [[[-117.89511, 33.61062], [-117.89508, 33.61063], [-117.89507, 33.61067], [-117.89499, 33.61066], [-117.89481, 33.61061], [-117.89479, 33.61058], [-117.89491, 33.61057], [-117.89511, 33.61061], [-117.89511, 33.61062]]]} | Open Access 1 | 47420 | Myrtle Park | 31137 | 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.047 | Myrtle Park | 0 | Local Park 2 | 4 | |
638 | 638 | 637 | {"type": "Polygon", "coordinates": [[[-117.88386, 33.59796], [-117.88404, 33.59799], [-117.88405, 33.59813], [-117.884, 33.59813], [-117.88389, 33.59805], [-117.88384, 33.59799], [-117.88386, 33.59796]]]} | Open Access 1 | 4921 | M Street Park | 21618 | 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.056 | M Street Park | 0 | Local Park 2 | 4 | |
6326 | 6326 | 6325 | {"type": "Polygon", "coordinates": [[[-117.93428, 33.61823], [-117.93424, 33.61826], [-117.93394, 33.61792], [-117.93398, 33.6179], [-117.93428, 33.61823]]]} | Open Access 1 | 47414 | Lake Street Park | 31130 | 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.059 | Lake Street Park | 0 | Local Park 2 | 4 | |
5273 | 5273 | 5272 | {"type": "Polygon", "coordinates": [[[-117.87737, 33.85948], [-117.87731, 33.85953], [-117.87727, 33.85959], [-117.87726, 33.85965], [-117.87728, 33.8597], [-117.87732, 33.85969], [-117.87729, 33.85973], [-117.87729, 33.85975], [-117.87728, 33.85976], [-117.87714, 33.85945], [-117.87737, 33.85948]]]} | Open Access 1 | 47392 | Jaycee Parkette | 31116 | 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 | 0.062 | Jaycee Parkette | 0 | Local Park 2 | 4 | |
1031 | 1031 | 1030 | {"type": "Polygon", "coordinates": [[[-117.89901, 33.74171], [-117.89886, 33.74172], [-117.89885, 33.74179], [-117.89876, 33.74179], [-117.89875, 33.74163], [-117.89901, 33.74163], [-117.89901, 33.74171]]]} | Open Access 1 | 5649 | Friendship Park | 19122 | 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 | Orange 3 | 0.074 | Friendship Park | 0 | Local Park 2 | 4 | |
12630 | 12630 | 12629 | {"type": "Polygon", "coordinates": [[[-118.07687, 33.80434], [-118.07686, 33.8046], [-118.07673, 33.8046], [-118.07672, 33.80434], [-118.07687, 33.80434]]]} | Open Access 1 | 48794 | Roberts Park | 33515 | 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 | https://cityoflosalamitos.org/recreation/events-facilities/facilities/parks-shelters/ | Orange 3 | 0.094 | Roberts Park | 0 | Local Park 2 | 4 |
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 | ||
4886 | 4886 | 4885 | {"type": "Polygon", "coordinates": [[[-117.66702, 33.49792], [-117.66702, 33.49797], [-117.66682, 33.49806], [-117.66672, 33.49814], [-117.66665, 33.4983], [-117.66661, 33.49829], [-117.66673, 33.49802], [-117.6668, 33.49795], [-117.66702, 33.49792]]]} | Open Access 1 | 30270 | Arce Park | 15572 | 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 | 0.096 | Arce Park | 0 | Local Park 2 | 4 | |
13911 | 13911 | 13910 | {"type": "Polygon", "coordinates": [[[-117.92126, 33.61221], [-117.92123, 33.61223], [-117.92099, 33.61213], [-117.92098, 33.61208], [-117.92101, 33.61201], [-117.92107, 33.61195], [-117.92113, 33.612], [-117.92126, 33.61221]]]} | Open Access 1 | 36516 | Newport Beach holding 1 | 22733 | 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.098 | Newport Beach holding 1 | 0 | Local Other or Unknown 14 | 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 | |
2828 | 2828 | 2827 | {"type": "Polygon", "coordinates": [[[-117.89054, 33.59896], [-117.89013, 33.59896], [-117.89013, 33.59888], [-117.89015, 33.59884], [-117.89012, 33.59877], [-117.89015, 33.59873], [-117.89054, 33.59896]]]} | Open Access 1 | 47419 | Miramar Park | 31136 | 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.125 | Miramar Park | 0 | Local Park 2 | 4 | |
14502 | 14502 | 14501 | {"type": "Polygon", "coordinates": [[[-117.87596, 33.76955], [-117.87596, 33.76981], [-117.87593, 33.76984], [-117.87588, 33.76983], [-117.87566, 33.76963], [-117.87596, 33.76955]]]} | Open Access 1 | 47387 | Sarah May Downie Herb Garden | 31112 | 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 | Orange 3 | 0.129 | Sarah May Downie Herb Garden | 0 | Local Park 2 | 4 | |
12817 | 12817 | 12816 | {"type": "Polygon", "coordinates": [[[-117.69767, 33.46954], [-117.69752, 33.46954], [-117.69752, 33.46919], [-117.69767, 33.46919], [-117.69766, 33.46937], [-117.69767, 33.46954]]]} | Open Access 1 | 30261 | Shipwreck Park | 25414 | 1079 | Dana Point, City of 134 | City 2 | City Agency 2 | http://www.danapoint.org/index.aspx?page=170 | City 2 | 1079 | Dana Point, City of 131 | City 2 | City Agency 2 | Orange 3 | 0.131 | Shipwreck Park | 0 | Local Park 2 | 4 | |
8990 | 8990 | 8989 | {"type": "Polygon", "coordinates": [[[-117.91753, 33.86783], [-117.9174, 33.86783], [-117.91739, 33.86746], [-117.91753, 33.86746], [-117.91753, 33.86783]]]} | Open Access 1 | 14842 | Truslow Park | 26555 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 0.132 | Truslow Park | 0 | Local Park 2 | 4 | |
5302 | 5302 | 5301 | {"type": "Polygon", "coordinates": [[[-117.77551, 33.53902], [-117.77551, 33.53902], [-117.77504, 33.53906], [-117.77533, 33.5388], [-117.77551, 33.53902]]]} | Open Access 1 | 5774 | Nita Carmen Park | 22770 | 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.14 | Nita Carmen Park | 0 | Local Park 2 | 4 | |
2658 | 2658 | 2657 | {"type": "Polygon", "coordinates": [[[-117.95426, 33.92688], [-117.95426, 33.92723], [-117.9541, 33.92723], [-117.9541, 33.92688], [-117.95426, 33.92688]]]} | Open Access 1 | 18157 | Corona Park | 17643 | 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 | 0.143 | Corona Park | 0 | Local Park 2 | 4 | |
12798 | 12798 | 12797 | {"type": "Polygon", "coordinates": [[[-117.77926, 33.53558], [-117.77879, 33.53582], [-117.77876, 33.53577], [-117.77893, 33.53566], [-117.77893, 33.53561], [-117.77892, 33.53559], [-117.77917, 33.53547], [-117.77926, 33.53558]]]} | Open Access 1 | 30237 | Thalia Street Park | 26275 | 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.144 | Thalia Street 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 | |
5992 | 5992 | 5991 | {"type": "Polygon", "coordinates": [[[-117.86446, 33.75326], [-117.86421, 33.75286], [-117.86445, 33.75275], [-117.86445, 33.75275], [-117.86446, 33.75326]]]} | Open Access 1 | 693 | French Park | 19107 | 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 | Orange 3 | 0.159 | French 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]);