superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
30 rows where MNG_AGENCY = 261 sorted by MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13407 | 13407 | 13406 | {"type": "Polygon", "coordinates": [[[-117.6293, 33.96127], [-117.62796, 33.96128], [-117.62791, 33.96123], [-117.6279, 33.96039], [-117.62795, 33.96033], [-117.62821, 33.96032], [-117.62852, 33.961], [-117.6291, 33.96082], [-117.6293, 33.96127]]]} | Open Access 1 | North Meridian Park | 33434 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 1.845 | North Meridian Park | ||
13408 | 13408 | 13407 | {"type": "Polygon", "coordinates": [[[-117.62879, 33.95998], [-117.62819, 33.96016], [-117.62795, 33.96017], [-117.6279, 33.96011], [-117.62788, 33.95828], [-117.62794, 33.95824], [-117.62842, 33.95818], [-117.62849, 33.9586], [-117.6286, 33.95906], [-117.62866, 33.95946], [-117.62874, 33.95983], [-117.62879, 33.95998]]]} | Open Access 1 | South Meridian Park | 33435 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 3.431 | South Meridian Park | ||
13413 | 13413 | 13412 | {"type": "Polygon", "coordinates": [[[-117.63204, 33.95902], [-117.63201, 33.95915], [-117.632, 33.95932], [-117.632, 33.95991], [-117.63149, 33.96007], [-117.6312, 33.95941], [-117.63141, 33.95934], [-117.63127, 33.95898], [-117.6315, 33.95892], [-117.63157, 33.95886], [-117.632, 33.95895], [-117.63204, 33.95902]]]} | Open Access 1 | West Meridian Park | 33436 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 1.84 | West Meridian Park | ||
13607 | 13607 | 13606 | {"type": "Polygon", "coordinates": [[[-117.62599, 33.96845], [-117.62557, 33.96845], [-117.62557, 33.96815], [-117.62593, 33.96813], [-117.62594, 33.96816], [-117.62598, 33.96816], [-117.62599, 33.96845]]]} | Open Access 1 | Evergreen Park | http://www.cityofchino.org/government-services/community-services/parks/evergreen-park | 31066 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 0.321 | Evergreen Park | |
13608 | 13608 | 13607 | {"type": "Polygon", "coordinates": [[[-117.66232, 33.99133], [-117.66227, 33.99137], [-117.66169, 33.99137], [-117.66161, 33.99131], [-117.66161, 33.9912], [-117.66166, 33.99116], [-117.66227, 33.99115], [-117.66232, 33.99119], [-117.66232, 33.99133]]]} | Open Access 1 | Inspiration Park | http://www.cityofchino.org/government-services/community-services/parks/inspiration-park | 31068 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 0.377 | Inspiration Park | |
13609 | 13609 | 13608 | {"type": "Polygon", "coordinates": [[[-117.6212, 33.96792], [-117.62116, 33.96804], [-117.621, 33.96806], [-117.621, 33.96848], [-117.62076, 33.96848], [-117.62075, 33.96806], [-117.62093, 33.96801], [-117.62113, 33.9679], [-117.6212, 33.96792]]]} | Open Access 1 | Mulberry Park | http://www.cityofchino.org/government-services/community-services/parks/mulberry-park | 31069 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 0.343 | Mulberry Park | |
13610 | 13610 | 13609 | {"type": "Polygon", "coordinates": [[[-117.69359, 34.01964], [-117.69329, 34.01965], [-117.69328, 34.01913], [-117.69352, 34.01913], [-117.69358, 34.01916], [-117.69359, 34.01964]]]} | Open Access 1 | Oak Tree Square Park | http://www.cityofchino.org/government-services/community-services/parks/oak-tree-square-park | 31070 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 0.384 | Oak Tree Square Park | |
13611 | 13611 | 13610 | {"type": "Polygon", "coordinates": [[[-117.63077, 33.96688], [-117.63073, 33.96692], [-117.63049, 33.96692], [-117.63049, 33.96646], [-117.6307, 33.96646], [-117.63074, 33.96647], [-117.63077, 33.9665], [-117.63077, 33.96688]]]} | Open Access 1 | Secret Garden Park | http://www.cityofchino.org/government-services/community-services/parks/secret-garden-park | 31071 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 0.324 | Secret Garden Park | |
13612 | 13612 | 13611 | {"type": "Polygon", "coordinates": [[[-117.65868, 34.01386], [-117.65659, 34.01387], [-117.65657, 34.01214], [-117.65761, 34.01213], [-117.65763, 34.01345], [-117.65868, 34.01345], [-117.65868, 34.01386]]]} | Open Access 1 | Shady Grove Park | http://www.cityofchino.org/government-services/community-services/parks/shady-grove-park | 31072 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 5.689 | Shady Grove Park | |
15480 | 15480 | 15479 | {"type": "Polygon", "coordinates": [[[-117.66738, 34.01186], [-117.66528, 34.01187], [-117.66526, 34.01015], [-117.66736, 34.01013], [-117.66738, 34.01186]]]} | Open Access 1 | Mountain View Park | http://www.cityofchino.org/government-services/community-services/parks/mountain-view-park | 22552 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 9.148 | Mtn. View 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]);