superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10 rows where MNG_AGENCY = 154, MNG_AG_LEV = 2 and MNG_AG_TYP = 2
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 | ||
357 | 357 | 356 | {"type": "Polygon", "coordinates": [[[-118.11967, 34.09049], [-118.11966, 34.09074], [-118.11234, 34.09388], [-118.10973, 34.0882], [-118.10992, 34.08814], [-118.10934, 34.08688], [-118.1091, 34.08626], [-118.1094, 34.08614], [-118.10899, 34.08523], [-118.10881, 34.08475], [-118.11269, 34.08456], [-118.11268, 34.08483], [-118.11269, 34.0859], [-118.11273, 34.08679], [-118.11276, 34.08697], [-118.11298, 34.08739], [-118.1137, 34.08774], [-118.11393, 34.08771], [-118.11418, 34.08766], [-118.11449, 34.08765], [-118.11449, 34.08813], [-118.11461, 34.08814], [-118.11486, 34.08832], [-118.11491, 34.08836], [-118.11492, 34.08859], [-118.11575, 34.08939], [-118.11563, 34.0894], [-118.11563, 34.08959], [-118.11567, 34.08964], [-118.1157, 34.08965], [-118.11577, 34.08965], [-118.11578, 34.08941], [-118.11591, 34.08929], [-118.11685, 34.08929], [-118.11687, 34.09051], [-118.11967, 34.09049]]]} | Restricted Access 2 | Alhambra Municipal Golf Course | http://alhambragolf.com/ag/ | 33112 | 1003 | Alhambra, City of 154 | City 2 | City Agency 2 | http://www.cityofalhambra.org/page/20/parks_rec_department/ | City 2 | 107.043 | Alhambra Municipal GC | |
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]);