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_AGENCY
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5 | 5 | 4 | {"type": "MultiPolygon", "coordinates": [[[[-118.10598, 33.73945], [-118.10581, 33.73968], [-118.1051, 33.73933], [-118.10527, 33.73909], [-118.10598, 33.73945]]], [[[-118.10701, 33.73996], [-118.10683, 33.7402], [-118.10615, 33.73985], [-118.10632, 33.73962], [-118.10701, 33.73996]]], [[[-118.10746, 33.7402], [-118.10729, 33.74044], [-118.10691, 33.74024], [-118.10708, 33.74], [-118.10746, 33.7402]]]]} | Open Access 1 | 25 | Eisenhower Park | 18475 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | Orange 3 | 1.46 | Eisenhower Park | 0 | Local Park 2 | 4 | |
674 | 674 | 673 | {"type": "Polygon", "coordinates": [[[-118.111, 33.74554], [-118.11097, 33.74555], [-118.10971, 33.74629], [-118.10972, 33.74521], [-118.11008, 33.74524], [-118.11037, 33.7453], [-118.11059, 33.74537], [-118.111, 33.74554]]]} | Open Access 1 | 5111 | Marina Park | 21837 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | Orange 3 | 1.915 | Marina Park | 0 | Local Park 2 | 4 | |
2278 | 2278 | 2277 | {"type": "Polygon", "coordinates": [[[-118.0508, 33.77469], [-118.0507, 33.77474], [-118.05066, 33.77481], [-118.05066, 33.77506], [-118.05064, 33.77513], [-118.05061, 33.77515], [-118.05051, 33.77515], [-118.04961, 33.77506], [-118.04924, 33.77506], [-118.04919, 33.77501], [-118.04919, 33.77486], [-118.04917, 33.77481], [-118.04913, 33.77476], [-118.04903, 33.77471], [-118.0508, 33.77469]]]} | Open Access 1 | 16839 | Almond Park | 15398 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | Orange 3 | 1.507 | Almond Park | 0 | Local Park 2 | 4 | |
2473 | 2473 | 2472 | {"type": "Polygon", "coordinates": [[[-118.09665, 33.77734], [-118.09664, 33.77835], [-118.09659, 33.77908], [-118.09606, 33.779], [-118.09566, 33.77902], [-118.09569, 33.77668], [-118.09574, 33.77489], [-118.09606, 33.77483], [-118.09664, 33.77485], [-118.09662, 33.77729], [-118.09665, 33.77734]]]} | Open Access 1 | 18958 | Edison Park | 18446 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | Orange 3 | 9.949 | Edison Park | 0 | Local Park 2 | 4 | |
3722 | 3722 | 3721 | {"type": "Polygon", "coordinates": [[[-118.06595, 33.77472], [-118.06558, 33.77479], [-118.06521, 33.7749], [-118.06481, 33.77506], [-118.06449, 33.77523], [-118.06408, 33.77551], [-118.06382, 33.77574], [-118.06343, 33.77613], [-118.06332, 33.77613], [-118.06287, 33.77585], [-118.0627, 33.77578], [-118.06252, 33.77572], [-118.06235, 33.77569], [-118.06217, 33.77568], [-118.06212, 33.77564], [-118.06212, 33.77508], [-118.06219, 33.77491], [-118.06217, 33.77476], [-118.06595, 33.77472]]]} | Open Access 1 | 30350 | Seal Beach Tennis Center | 25242 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | Orange 3 | 6.797 | Seal Beach Tennis Ctr. | 0 | Local Recreation Area 3 | 4 | |
5349 | 5349 | 5348 | {"type": "Polygon", "coordinates": [[[-118.0526, 33.78098], [-118.05249, 33.78107], [-118.05209, 33.78107], [-118.05186, 33.78077], [-118.05193, 33.78071], [-118.05195, 33.78065], [-118.05193, 33.78054], [-118.05193, 33.78014], [-118.05195, 33.78009], [-118.05199, 33.78008], [-118.05252, 33.78009], [-118.05256, 33.78009], [-118.05259, 33.78012], [-118.0526, 33.78098]]]} | Open Access 1 | 24616 | Heather Park | 19785 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | Orange 3 | 1.615 | Heather Park | 0 | Local Park 2 | 4 | |
5350 | 5350 | 5349 | {"type": "Polygon", "coordinates": [[[-118.09593, 33.74451], [-118.09565, 33.74437], [-118.09567, 33.74429], [-118.09478, 33.74377], [-118.09476, 33.74327], [-118.09514, 33.74279], [-118.0966, 33.74354], [-118.0966, 33.74357], [-118.09593, 33.74451]]]} | Open Access 1 | 24617 | McGaugh Gymnasium, Pool, Tennis Courts & Fields | 22033 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | Orange 3 | 4.455 | McGaugh Gymnasium, Pool, Tennis Courts & Fields | 0 | Local Recreation Area 3 | 4 | |
6220 | 6220 | 6219 | {"type": "Polygon", "coordinates": [[[-118.10036, 33.74943], [-118.10034, 33.74971], [-118.10013, 33.74989], [-118.09978, 33.74999], [-118.09918, 33.74999], [-118.09748, 33.74977], [-118.09567, 33.74976], [-118.09489, 33.75005], [-118.0943, 33.75006], [-118.09404, 33.75021], [-118.09393, 33.7505], [-118.09274, 33.75002], [-118.09208, 33.7498], [-118.09206, 33.74981], [-118.09182, 33.74974], [-118.09161, 33.74966], [-118.09078, 33.74928], [-118.09059, 33.74923], [-118.0904, 33.74923], [-118.09024, 33.74927], [-118.09011, 33.74934], [-118.08996, 33.74946], [-118.08988, 33.74958], [-118.0898, 33.74978], [-118.09, 33.74998], [-118.09008, 33.75003], [-118.08995, 33.75016], [-118.08991, 33.75016], [-118.08987, 33.75014], [-118.0898, 33.75007], [-118.08968, 33.75005], [-118.08939, 33.74991], [-118.08937, 33.74987], [-118.08938, 33.74984], [-118.0904, 33.74833], [-118.09168, 33.7494], [-118.10036, 33.74943]]]} | Open Access 1 | 1278 | Gum Grove Park | 19568 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | Orange 3 | 14.952 | Gum Grove Park | 0 | Local Park 2 | 4 | |
9297 | 9297 | 9296 | {"type": "Polygon", "coordinates": [[[-118.10221, 33.74239], [-118.10162, 33.7432], [-118.10041, 33.74259], [-118.10094, 33.74186], [-118.10181, 33.7423], [-118.10187, 33.74222], [-118.10221, 33.74239]]]} | Open Access 1 | 15520 | Zoeter Field | 27867 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | Orange 3 | 3.137 | Zoeter Field | 0 | Local Recreation Area 3 | 4 | |
11983 | 11983 | 11982 | {"type": "MultiPolygon", "coordinates": [[[[-118.09836, 33.73752], [-118.09788, 33.7375], [-118.09784, 33.73745], [-118.09801, 33.7372], [-118.09836, 33.73752]]], [[[-118.10024, 33.73925], [-118.10001, 33.73945], [-118.09809, 33.73769], [-118.09857, 33.73772], [-118.10024, 33.73925]]], [[[-118.10169, 33.74058], [-118.10152, 33.74083], [-118.10011, 33.73954], [-118.10034, 33.73934], [-118.10169, 33.74058]]], [[[-118.10382, 33.74254], [-118.10364, 33.74278], [-118.1024, 33.74164], [-118.10162, 33.74093], [-118.1018, 33.74068], [-118.10382, 33.74254]]], [[[-118.10525, 33.74384], [-118.10503, 33.74405], [-118.10381, 33.74293], [-118.10401, 33.74271], [-118.10525, 33.74384]]], [[[-118.10603, 33.74458], [-118.10599, 33.74466], [-118.10595, 33.7449], [-118.10517, 33.74419], [-118.1054, 33.74399], [-118.10603, 33.74458]]], [[[-118.10648, 33.74497], [-118.10612, 33.74497], [-118.1061, 33.74486], [-118.10613, 33.74465], [-118.10648, 33.74497]]]]} | Open Access 1 | 24615 | Electric Ave Greenbelt | 18557 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | Orange 3 | 7.723 | Electric Ave Greenbelt | 0 | Local Recreation Area 3 | 4 | |
12341 | 12341 | 12340 | {"type": "Polygon", "coordinates": [[[-118.06195, 33.77555], [-118.0613, 33.77555], [-118.06131, 33.77488], [-118.06133, 33.77485], [-118.06137, 33.77484], [-118.06186, 33.77484], [-118.06194, 33.77488], [-118.06196, 33.77493], [-118.06195, 33.77555]]]} | Open Access 1 | 26034 | Bluebell Park | 16192 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | Orange 3 | 1.171 | Bluebell Park | 0 | Local Park 2 | 4 | |
12517 | 12517 | 12516 | {"type": "Polygon", "coordinates": [[[-118.05123, 33.78279], [-118.05121, 33.78401], [-118.04864, 33.78403], [-118.04753, 33.78326], [-118.0475, 33.78274], [-118.05123, 33.78279]]]} | Open Access 1 | 29000 | Arbor Park | 15559 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | Orange 3 | 10.752 | Arbor Park | 0 | Local Park 2 | 4 | |
13902 | 13902 | 13901 | {"type": "Polygon", "coordinates": [[[-118.10808, 33.74807], [-118.10744, 33.74844], [-118.1074, 33.74793], [-118.10733, 33.74748], [-118.10727, 33.74736], [-118.1072, 33.74729], [-118.10708, 33.74722], [-118.10708, 33.74717], [-118.10709, 33.74716], [-118.10808, 33.74807]]]} | Open Access 1 | 36524 | Seal Beach holding 1 | 25240 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | Orange 3 | 0.923 | Seal Beach holding 1 | 0 | Local Other or Unknown 14 | 4 | |
28 | 28 | 27 | {"type": "Polygon", "coordinates": [[[-117.89558, 33.75242], [-117.89529, 33.75244], [-117.89531, 33.75329], [-117.8936, 33.75333], [-117.89359, 33.75197], [-117.89397, 33.75194], [-117.89398, 33.75162], [-117.89558, 33.75161], [-117.89558, 33.75242]]]} | Open Access 1 | 154 | El Salvador Park | 18538 | 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 | 7.57 | El Salvador Park | 0 | Local Park 2 | 4 | |
203 | 203 | 202 | {"type": "Polygon", "coordinates": [[[-117.8759, 33.77057], [-117.8759, 33.77164], [-117.87387, 33.77142], [-117.871, 33.77154], [-117.87088, 33.77167], [-117.87063, 33.77133], [-117.87169, 33.77125], [-117.8717, 33.77141], [-117.87384, 33.77134], [-117.87386, 33.77119], [-117.87472, 33.7711], [-117.8756, 33.77074], [-117.8759, 33.77057]]]} | Open Access 1 | 544 | Fisher Park | 18919 | 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 | 3.993 | Fisher Park | 0 | Local Park 2 | 4 | |
626 | 626 | 625 | {"type": "MultiPolygon", "coordinates": [[[[-117.898, 33.73463], [-117.89798, 33.73688], [-117.896, 33.73688], [-117.896, 33.73629], [-117.89607, 33.73628], [-117.89607, 33.7346], [-117.89791, 33.7346], [-117.89792, 33.73463], [-117.898, 33.73463]]], [[[-117.89922, 33.73798], [-117.89813, 33.73798], [-117.89812, 33.7346], [-117.8992, 33.7346], [-117.89922, 33.73798]]]]} | Open Access 1 | 2440 | Jerome Park | 20399 | 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 | 20.542 | Jerome Park | 0 | Local Park 2 | 4 | |
702 | 702 | 701 | {"type": "Polygon", "coordinates": [[[-117.87512, 33.70458], [-117.87514, 33.70468], [-117.87508, 33.70483], [-117.87466, 33.70522], [-117.87465, 33.70537], [-117.87317, 33.70536], [-117.87318, 33.70507], [-117.87307, 33.70502], [-117.8731, 33.70494], [-117.87309, 33.7049], [-117.87324, 33.70484], [-117.87324, 33.70429], [-117.87311, 33.70424], [-117.87312, 33.70419], [-117.8731, 33.70413], [-117.87324, 33.70407], [-117.87325, 33.70355], [-117.87311, 33.70348], [-117.87312, 33.70343], [-117.87311, 33.70338], [-117.87325, 33.70332], [-117.87325, 33.70277], [-117.87454, 33.70277], [-117.87471, 33.7028], [-117.87468, 33.70416], [-117.87512, 33.70458]]]} | Open Access 1 | 4154 | Lillie King Park | 21237 | 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 | 10.431 | Lillie King Park | 0 | Local Park 2 | 4 | |
725 | 725 | 724 | {"type": "Polygon", "coordinates": [[[-117.85796, 33.75435], [-117.85756, 33.75436], [-117.85755, 33.75394], [-117.85795, 33.75394], [-117.85796, 33.75435]]]} | Open Access 1 | 4606 | Chepa's Park | 17163 | 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.418 | Chepa's Park | 0 | Local Park 2 | 4 | |
774 | 774 | 773 | {"type": "Polygon", "coordinates": [[[-117.87227, 33.7464], [-117.87227, 33.74703], [-117.87226, 33.74705], [-117.87221, 33.74708], [-117.87092, 33.74709], [-117.87092, 33.7464], [-117.87227, 33.7464]]]} | Open Access 1 | 5035 | Birch Park | 16117 | 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 | 2.354 | Birch Park | 0 | Local Park 2 | 4 | |
777 | 777 | 776 | {"type": "Polygon", "coordinates": [[[-117.89784, 33.71694], [-117.89618, 33.71696], [-117.89617, 33.71572], [-117.89619, 33.71566], [-117.89621, 33.71564], [-117.89626, 33.71563], [-117.89784, 33.71561], [-117.89784, 33.71694]]]} | Open Access 1 | 5185 | Adams Park | 15263 | 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 | 5.604 | Adams 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]);