superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
22 rows where MNG_AGENCY = 199 sorted by PARK_NAME descending
This data as json, copyable, CSV (advanced)
Link | rowid | id | map | ACCESS_TYP | PARK_NAME ▲ | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10950 | 10950 | 10949 | {"type": "MultiPolygon", "coordinates": [[[[-117.95898, 33.91288], [-117.9587, 33.91249], [-117.95808, 33.91188], [-117.95785, 33.91097], [-117.95326, 33.90942], [-117.95332, 33.90928], [-117.9538, 33.90935], [-117.95405, 33.90935], [-117.95429, 33.90931], [-117.95453, 33.90923], [-117.95506, 33.90889], [-117.95562, 33.90865], [-117.95582, 33.90852], [-117.95599, 33.90835], [-117.95611, 33.9081], [-117.9563, 33.9081], [-117.95619, 33.90891], [-117.95617, 33.90895], [-117.95624, 33.90916], [-117.95623, 33.90919], [-117.95634, 33.90938], [-117.95634, 33.90943], [-117.95651, 33.9096], [-117.95652, 33.90963], [-117.95673, 33.90977], [-117.95675, 33.90981], [-117.95698, 33.90991], [-117.957, 33.90993], [-117.95727, 33.90999], [-117.9573, 33.91001], [-117.95773, 33.91002], [-117.95816, 33.91007], [-117.95818, 33.91004], [-117.9582, 33.90982], [-117.95816, 33.90976], [-117.95821, 33.9097], [-117.95821, 33.90963], [-117.95815, 33.90956], [-117.95816, 33.90952], [-117.95795, 33.90907], [-117.95792, 33.90881], [-117.95777, 33.90844], [-117.95763, 33.90841], [-117.9576, 33.90832], [-117.9577, 33.90824], [-117.95754, 33.90786], [-117.95778, 33.90781], [-117.95802, 33.90775], [-117.95813, 33.90779], [-117.95827, 33.90815], [-117.95842, 33.90875], [-117.95898, 33.91229], [-117.95898, 33.91288]]], [[[-117.95795, 33.9074], [-117.95791, 33.9075], [-117.95745, 33.90765], [-117.95702, 33.90776], [-117.95642, 33.90787], [-117.95617, 33.90789], [-117.95599, 33.90789], [-117.95574, 33.90785], [-117.95522, 33.90772], [-117.95502, 33.90763], [-117.95471, 33.90743], [-117.95459, 33.90732], [-117.95443, 33.90713], [-117.95439, 33.90705], [-117.95437, 33.90691], [-117.95433, 33.90685], [-117.95418, 33.90679], [-117.95413, 33.9068], [-117.95409, 33.90646], [-117.95463, 33.90646], [-117.95488, 33.90684], [-117.9548, 33.90691], [-117.95481, 33.9072], [-117.95537, 33.90742], [-117.95561, 33.90742], [-117.95579, 33.9074], [-117.95614, 33.90723], [-117.95615, 33.90668], [-117.95557, 33.90646], [-117.95731, 33.90646], [-117.9577, 33.90698], [-117.95795, 33.9074]]], [[[-117.96414, 33.90645], [-117.96412, 33.90659], [-117.96389, 33.90664], [-117.96368, 33.90673], [-117.96322, 33.90735], [-117.9623, 33.90745], [-117.96215, 33.90745], [-117.96184, 33.90742], [-117.96161, 33.90735], [-117.96121, 33.90717], [-117.96082, 33.90703], [-117.96038, 33.90691], [-117.96004, 33.90686], [-117.95978, 33.90685], [-117.95929, 33.90686], [-117.95927, 33.90685], [-117.95911, 33.90684], [-117.95901, 33.90685], [-117.95896, 33.90681], [-117.95873, 33.90682], [-117.95868, 33.90703], [-117.95866, 33.90709], [-117.95856, 33.9072], [-117.95846, 33.90729], [-117.9584, 33.90732], [-117.95828, 33.9073], [-117.95792, 33.90671], [-117.95772, 33.90645], [-117.96414, 33.90645]]]]} | Open Access 1 | Vista del Valle Park | 27171 | 1155 | La Habra, City of 199 | City 2 | City Agency 2 | http://www.ci.la-habra.ca.us/section.cfm?id=79 | City 2 | 36.347 | Vista del Valle Park | ||
10952 | 10952 | 10951 | {"type": "Polygon", "coordinates": [[[-117.95903, 33.92151], [-117.95902, 33.9244], [-117.95895, 33.92445], [-117.9564, 33.92444], [-117.95641, 33.92279], [-117.95705, 33.92278], [-117.95706, 33.92154], [-117.95903, 33.92151]]]} | Open Access 1 | Vista Grande Park | 27173 | 1155 | La Habra, City of 199 | City 2 | City Agency 2 | http://www.ci.la-habra.ca.us/section.cfm?id=79 | City 2 | 17.315 | Vista Grande Park | ||
10293 | 10293 | 10292 | {"type": "Polygon", "coordinates": [[[-117.97513, 33.92838], [-117.9745, 33.92839], [-117.97406, 33.92843], [-117.97362, 33.9285], [-117.97226, 33.92878], [-117.9717, 33.92884], [-117.97113, 33.92885], [-117.97113, 33.92851], [-117.97133, 33.92837], [-117.97513, 33.92838]]]} | Open Access 1 | Terraza Park | 26265 | 1155 | La Habra, City of 199 | City 2 | City Agency 2 | http://www.ci.la-habra.ca.us/section.cfm?id=79 | City 2 | 2.359 | Terraza Park | ||
9229 | 9229 | 9228 | {"type": "Polygon", "coordinates": [[[-117.94822, 33.94183], [-117.94705, 33.94183], [-117.94705, 33.94138], [-117.94714, 33.94137], [-117.94715, 33.94093], [-117.9477, 33.94093], [-117.94772, 33.94138], [-117.94821, 33.94139], [-117.94822, 33.94183]]]} | Open Access 1 | San Miguel Park | 24957 | 1155 | La Habra, City of 199 | City 2 | City Agency 2 | http://www.ci.la-habra.ca.us/section.cfm?id=79 | City 2 | 1.984 | San Miguel Park | ||
8662 | 8662 | 8661 | {"type": "Polygon", "coordinates": [[[-117.946, 33.92432], [-117.946, 33.92447], [-117.94596, 33.9245], [-117.9454, 33.9245], [-117.94535, 33.92447], [-117.94535, 33.92436], [-117.94565, 33.92436], [-117.94567, 33.92432], [-117.946, 33.92432]]]} | Open Access 1 | Richard's Park | 24320 | 1155 | La Habra, City of 199 | City 2 | City Agency 2 | http://www.ci.la-habra.ca.us/section.cfm?id=79 | City 2 | 0.263 | Richard's Park | ||
8327 | 8327 | 8326 | {"type": "Polygon", "coordinates": [[[-117.94828, 33.92839], [-117.94829, 33.92877], [-117.94828, 33.92984], [-117.94825, 33.92986], [-117.94827, 33.93031], [-117.94624, 33.93031], [-117.94624, 33.92978], [-117.94621, 33.92976], [-117.94621, 33.92933], [-117.94624, 33.92931], [-117.94625, 33.9284], [-117.94828, 33.92839]]]} | Open Access 1 | Portola Park | 23910 | 1155 | La Habra, City of 199 | City 2 | City Agency 2 | http://www.ci.la-habra.ca.us/section.cfm?id=79 | City 2 | 9.934 | Portola Park | ||
7787 | 7787 | 7786 | {"type": "Polygon", "coordinates": [[[-117.96685, 33.9453], [-117.96665, 33.94607], [-117.96489, 33.94606], [-117.96488, 33.94491], [-117.96671, 33.9449], [-117.96685, 33.9453]]]} | Open Access 1 | Osornio Park | 23237 | 1155 | La Habra, City of 199 | City 2 | City Agency 2 | http://www.ci.la-habra.ca.us/section.cfm?id=79 | City 2 | 5.519 | Osornio Park | ||
7660 | 7660 | 7659 | {"type": "Polygon", "coordinates": [[[-117.93856, 33.94274], [-117.93749, 33.94274], [-117.93748, 33.9424], [-117.93795, 33.9424], [-117.93797, 33.94231], [-117.93855, 33.94231], [-117.93856, 33.94274]]]} | Open Access 1 | Old Reservoir Park | 23101 | 1155 | La Habra, City of 199 | City 2 | City Agency 2 | http://www.ci.la-habra.ca.us/section.cfm?id=79 | City 2 | 1.073 | Old Reservoir Park | ||
7636 | 7636 | 7635 | {"type": "Polygon", "coordinates": [[[-117.97245, 33.9232], [-117.97243, 33.92449], [-117.97188, 33.92449], [-117.97187, 33.92455], [-117.97105, 33.92455], [-117.97104, 33.92329], [-117.97187, 33.92329], [-117.97189, 33.92312], [-117.97223, 33.92312], [-117.97224, 33.92319], [-117.97245, 33.9232]]]} | Open Access 1 | Oeste Park | 23071 | 1155 | La Habra, City of 199 | City 2 | City Agency 2 | http://www.ci.la-habra.ca.us/section.cfm?id=79 | City 2 | 4.561 | Oeste Park | ||
7171 | 7171 | 7170 | {"type": "Polygon", "coordinates": [[[-117.94442, 33.91445], [-117.94432, 33.91452], [-117.94376, 33.91451], [-117.94376, 33.91415], [-117.94441, 33.91415], [-117.94442, 33.91445]]]} | Open Access 1 | Montwood Park | 22445 | 1155 | La Habra, City of 199 | City 2 | City Agency 2 | http://www.ci.la-habra.ca.us/section.cfm?id=79 | City 2 | 0.599 | Montwood Park | ||
6318 | 6318 | 6317 | {"type": "Polygon", "coordinates": [[[-117.95205, 33.92722], [-117.95059, 33.92723], [-117.95059, 33.92723], [-117.95059, 33.92714], [-117.95061, 33.92707], [-117.95148, 33.92677], [-117.95205, 33.92651], [-117.95205, 33.92722]]]} | Open Access 1 | Loma Verde Park | 21409 | 1155 | La Habra, City of 199 | City 2 | City Agency 2 | http://www.ci.la-habra.ca.us/section.cfm?id=79 | City 2 | 1.538 | Loma Verde Park | ||
6328 | 6328 | 6327 | {"type": "Polygon", "coordinates": [[[-117.92433, 33.94505], [-117.92328, 33.94506], [-117.92328, 33.94297], [-117.92418, 33.94297], [-117.92422, 33.943], [-117.92422, 33.94314], [-117.92384, 33.94319], [-117.92388, 33.94335], [-117.92396, 33.94349], [-117.92433, 33.94403], [-117.92433, 33.94505]]]} | Open Access 1 | Loma Norte Park | 21406 | 1155 | La Habra, City of 199 | City 2 | City Agency 2 | http://www.ci.la-habra.ca.us/section.cfm?id=79 | City 2 | 4.875 | Loma Norte Park | ||
6121 | 6121 | 6120 | {"type": "Polygon", "coordinates": [[[-117.9402, 33.91751], [-117.94011, 33.91759], [-117.94011, 33.91819], [-117.93982, 33.91778], [-117.9398, 33.91767], [-117.9398, 33.91753], [-117.93984, 33.9175], [-117.9402, 33.91751]]]} | Open Access 1 | Leslie Park | 21180 | 1155 | La Habra, City of 199 | City 2 | City Agency 2 | http://www.ci.la-habra.ca.us/section.cfm?id=79 | City 2 | 0.375 | Leslie Park | ||
6012 | 6012 | 6011 | {"type": "Polygon", "coordinates": [[[-117.94847, 33.9231], [-117.94621, 33.92236], [-117.94621, 33.92209], [-117.94674, 33.92208], [-117.94689, 33.9221], [-117.94739, 33.92237], [-117.94793, 33.92261], [-117.94815, 33.92266], [-117.94847, 33.92268], [-117.94847, 33.9231]]]} | Open Access 1 | Las Lomas Park | 21057 | 1155 | La Habra, City of 199 | City 2 | City Agency 2 | http://www.ci.la-habra.ca.us/section.cfm?id=79 | City 2 | 2.152 | Las Lomas Park | ||
5798 | 5798 | 5797 | {"type": "Polygon", "coordinates": [[[-117.96304, 33.93707], [-117.96271, 33.93783], [-117.96286, 33.93844], [-117.96201, 33.93834], [-117.96201, 33.93921], [-117.96076, 33.9391], [-117.96087, 33.9381], [-117.96051, 33.93774], [-117.96048, 33.93721], [-117.96058, 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 | La Bonita Park | 20742 | 1155 | La Habra, City of 199 | City 2 | City Agency 2 | http://www.ci.la-habra.ca.us/section.cfm?id=79 | City 2 | 18.864 | La Bonita Park | ||
4794 | 4794 | 4793 | {"type": "Polygon", "coordinates": [[[-117.95906, 33.92836], [-117.95906, 33.92852], [-117.95319, 33.92855], [-117.95317, 33.92866], [-117.95309, 33.92868], [-117.95309, 33.92894], [-117.95265, 33.92893], [-117.95262, 33.92856], [-117.95171, 33.92859], [-117.95111, 33.92866], [-117.95055, 33.92877], [-117.95056, 33.92841], [-117.95906, 33.92836]]]} | Open Access 1 | Guadalupe Park | 19556 | 1155 | La Habra, City of 199 | City 2 | City Agency 2 | http://www.ci.la-habra.ca.us/section.cfm?id=79 | City 2 | 4.138 | Guadalupe Park | ||
4061 | 4061 | 4060 | {"type": "Polygon", "coordinates": [[[-117.92111, 33.94507], [-117.91973, 33.94508], [-117.91937, 33.94443], [-117.91927, 33.94399], [-117.91937, 33.94376], [-117.91922, 33.94348], [-117.91899, 33.94316], [-117.91905, 33.94291], [-117.91937, 33.94291], [-117.91943, 33.94277], [-117.91996, 33.94277], [-117.91998, 33.94291], [-117.9211, 33.9429], [-117.92111, 33.94507]]]} | Open Access 1 | Esteli Park | 18722 | 1155 | La Habra, City of 199 | City 2 | City Agency 2 | http://www.ci.la-habra.ca.us/section.cfm?id=79 | City 2 | 9.99 | Esteli Park | ||
3886 | 3886 | 3885 | {"type": "Polygon", "coordinates": [[[-117.94385, 33.93367], [-117.94187, 33.93367], [-117.94187, 33.9329], [-117.94297, 33.93289], [-117.94343, 33.93281], [-117.94383, 33.93282], [-117.94385, 33.93284], [-117.94385, 33.93367]]]} | Open Access 1 | El Centro Park | 18489 | 1155 | La Habra, City of 199 | City 2 | City Agency 2 | http://www.ci.la-habra.ca.us/section.cfm?id=79 | City 2 | 4.031 | El Centro Park | ||
3579 | 3579 | 3578 | {"type": "Polygon", "coordinates": [[[-117.92918, 33.9331], [-117.92918, 33.93366], [-117.92871, 33.93366], [-117.9287, 33.93288], [-117.92903, 33.93288], [-117.92904, 33.93298], [-117.92906, 33.93302], [-117.92911, 33.93307], [-117.92918, 33.9331]]]} | Open Access 1 | Descanso Park | 18108 | 1155 | La Habra, City of 199 | City 2 | City Agency 2 | http://www.ci.la-habra.ca.us/section.cfm?id=79 | City 2 | 0.866 | Descanso Park | ||
3191 | 3191 | 3190 | {"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 | Corona Park | 17643 | 1155 | La Habra, City of 199 | City 2 | City Agency 2 | http://www.ci.la-habra.ca.us/section.cfm?id=79 | City 2 | 0.143 | Corona Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);