superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9 rows where ACCESS_TYP = 1 and MNG_AGENCY = 154
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
336 | 336 | 335 | {"type": "Polygon", "coordinates": [[[-118.11684, 34.08857], [-118.11633, 34.08837], [-118.11584, 34.08814], [-118.11449, 34.08814], [-118.11448, 34.08763], [-118.11424, 34.08764], [-118.1137, 34.08774], [-118.11298, 34.08739], [-118.11276, 34.08697], [-118.11269, 34.0859], [-118.11268, 34.08483], [-118.11269, 34.08456], [-118.11445, 34.08447], [-118.11447, 34.0848], [-118.11449, 34.08682], [-118.11683, 34.08681], [-118.11684, 34.08857]]]} | Open Access 1 | Almansor Park | 15393 | 1003 | Alhambra, City of 154 | City 2 | City Agency 2 | http://www.cityofalhambra.org/page/20/parks_rec_department/ | City 2 | 22.098 | Almansor Park | ||
1089 | 1089 | 1088 | {"type": "Polygon", "coordinates": [[[-118.14649, 34.09856], [-118.14521, 34.09857], [-118.14518, 34.09856], [-118.14515, 34.09477], [-118.14646, 34.09476], [-118.14649, 34.09856]]]} | Open Access 1 | Alhambra Park | 15357 | 1003 | Alhambra, City of 154 | City 2 | City Agency 2 | http://www.cityofalhambra.org/page/20/parks_rec_department/ | City 2 | 12.643 | Alhambra Park | ||
2364 | 2364 | 2363 | {"type": "Polygon", "coordinates": [[[-118.14073, 34.09862], [-118.14024, 34.09862], [-118.14023, 34.09782], [-118.14072, 34.09782], [-118.14073, 34.09862]]]} | Open Access 1 | Burke Heritage Park | 16520 | 1003 | Alhambra, City of 154 | City 2 | City Agency 2 | http://www.cityofalhambra.org/page/20/parks_rec_department/ | City 2 | 0.995 | Burke Heritage Park | ||
3987 | 3987 | 3986 | {"type": "Polygon", "coordinates": [[[-118.15398, 34.08516], [-118.15332, 34.08515], [-118.15331, 34.08529], [-118.15286, 34.0853], [-118.15299, 34.08511], [-118.15317, 34.08496], [-118.1534, 34.08484], [-118.15365, 34.08478], [-118.15384, 34.08477], [-118.15397, 34.08496], [-118.15398, 34.08503], [-118.15398, 34.08516]]]} | Open Access 1 | Emery Park | 18624 | 1003 | Alhambra, City of 154 | City 2 | City Agency 2 | http://www.cityofalhambra.org/page/20/parks_rec_department/ | City 2 | 0.847 | Emery Park | ||
4681 | 4681 | 4680 | {"type": "Polygon", "coordinates": [[[-118.1466, 34.06955], [-118.14658, 34.06956], [-118.14533, 34.06957], [-118.14532, 34.0683], [-118.1453, 34.06825], [-118.14526, 34.06822], [-118.14521, 34.0682], [-118.14515, 34.06821], [-118.1451, 34.06825], [-118.14509, 34.0683], [-118.14511, 34.06835], [-118.14522, 34.06841], [-118.14525, 34.06845], [-118.14526, 34.06889], [-118.14433, 34.06889], [-118.14431, 34.06792], [-118.14418, 34.06779], [-118.14452, 34.06756], [-118.14467, 34.06737], [-118.14473, 34.06724], [-118.14477, 34.06711], [-118.14476, 34.06657], [-118.14478, 34.06637], [-118.14487, 34.06604], [-118.14528, 34.06603], [-118.1453, 34.0662], [-118.14641, 34.06619], [-118.14641, 34.06646], [-118.14656, 34.06646], [-118.1466, 34.06955]]]} | Open Access 1 | Granada Park | 19418 | 1003 | Alhambra, City of 154 | City 2 | City Agency 2 | http://www.cityofalhambra.org/page/20/parks_rec_department/ | City 2 | 16.051 | Granada Park | ||
5163 | 5163 | 5162 | {"type": "Polygon", "coordinates": [[[-118.12115, 34.10063], [-118.12111, 34.10064], [-118.12092, 34.10083], [-118.12075, 34.10103], [-118.12062, 34.10125], [-118.12055, 34.10113], [-118.12037, 34.10093], [-118.12111, 34.10059], [-118.12115, 34.10059], [-118.12115, 34.10063]]]} | Open Access 1 | Lindaraxa Park | 21285 | 1003 | Alhambra, City of 154 | City 2 | City Agency 2 | http://www.cityofalhambra.org/page/20/parks_rec_department/ | City 2 | 0.396 | Lindaraxa Park | ||
7187 | 7187 | 7186 | {"type": "Polygon", "coordinates": [[[-118.13169, 34.08265], [-118.12945, 34.08267], [-118.12943, 34.08001], [-118.1294, 34.07954], [-118.12943, 34.07953], [-118.13166, 34.07952], [-118.13169, 34.08265]]]} | Open Access 1 | Moor Field | 22457 | 1003 | Alhambra, City of 154 | City 2 | City Agency 2 | http://www.cityofalhambra.org/page/20/parks_rec_department/ | City 2 | 17.796 | Moor Field | ||
10008 | 10008 | 10007 | {"type": "MultiPolygon", "coordinates": [[[[-118.12536, 34.09923], [-118.12287, 34.10043], [-118.12282, 34.10034], [-118.12425, 34.09963], [-118.12346, 34.09846], [-118.12348, 34.09844], [-118.12357, 34.09855], [-118.12455, 34.09807], [-118.12536, 34.09923]]], [[[-118.12602, 34.10018], [-118.12506, 34.10064], [-118.12451, 34.10025], [-118.12449, 34.09997], [-118.12447, 34.09982], [-118.1254, 34.09936], [-118.12544, 34.09936], [-118.12602, 34.10018]]]]} | Open Access 1 | Story Park | 25902 | 1003 | Alhambra, City of 154 | City 2 | City Agency 2 | http://www.cityofalhambra.org/page/20/parks_rec_department/ | City 2 | 7.492 | Story Park | ||
11340 | 11340 | 11339 | {"type": "Polygon", "coordinates": [[[-118.11414, 34.0944], [-118.11354, 34.09469], [-118.11345, 34.0947], [-118.11325, 34.09471], [-118.11318, 34.09474], [-118.11314, 34.09478], [-118.11312, 34.09483], [-118.11313, 34.09489], [-118.11317, 34.09493], [-118.11293, 34.09505], [-118.11294, 34.09514], [-118.11282, 34.0952], [-118.11274, 34.09463], [-118.11275, 34.0942], [-118.11371, 34.09378], [-118.11414, 34.0944]]]} | Open Access 1 | Winston Smoyer Memorial Community Garden | 27652 | 1003 | Alhambra, City of 154 | City 2 | City Agency 2 | http://www.cityofalhambra.org/page/20/parks_rec_department/ | City 2 | 2.493 | Winston Smoyer Memorial Community Garden |
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]);