superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
26 rows where MNG_AGENCY = 143 sorted by map
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12385 | 12385 | 12384 | {"type": "Polygon", "coordinates": [[[-117.90951, 34.14686], [-117.9095, 34.1481], [-117.90942, 34.14811], [-117.90929, 34.14758], [-117.90916, 34.14691], [-117.9092, 34.14685], [-117.90928, 34.14683], [-117.90951, 34.14683], [-117.90951, 34.14686]]]} | Open Access 1 | Canyon Park | 29355 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 0.735 | Canyon Park | ||
12391 | 12391 | 12390 | {"type": "Polygon", "coordinates": [[[-117.91348, 34.12749], [-117.91348, 34.12799], [-117.91226, 34.12798], [-117.91226, 34.12749], [-117.91348, 34.12749]]]} | Open Access 1 | Memorial Park North Recreation Center (NRC) | http://www.ci.azusa.ca.us/index.aspx?NID=988 | 29353 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1.529 | Memorial Park North Rec. Ctr. (NRC) | |
6938 | 6938 | 6937 | {"type": "Polygon", "coordinates": [[[-117.91348, 34.12635], [-117.91348, 34.12749], [-117.91227, 34.12749], [-117.91226, 34.12798], [-117.91029, 34.12797], [-117.91029, 34.12633], [-117.91348, 34.12635]]]} | Open Access 1 | Memorial Park Recreation Center | 22145 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 11.719 | Memorial Park Rec. Ctr. | ||
7487 | 7487 | 7486 | {"type": "Polygon", "coordinates": [[[-117.91444, 34.14248], [-117.91441, 34.14341], [-117.90975, 34.14339], [-117.90975, 34.14274], [-117.91258, 34.14276], [-117.91259, 34.14206], [-117.91267, 34.14189], [-117.91298, 34.14199], [-117.91318, 34.14198], [-117.91319, 34.14095], [-117.91444, 34.14096], [-117.91442, 34.14188], [-117.91443, 34.14246], [-117.91444, 34.14248]]]} | Open Access 1 | Northside Park | 22891 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 14.475 | Northside Park | ||
11497 | 11497 | 11496 | {"type": "Polygon", "coordinates": [[[-117.92179, 34.11982], [-117.92177, 34.12163], [-117.92068, 34.12164], [-117.92067, 34.12153], [-117.91871, 34.12153], [-117.91861, 34.12146], [-117.91861, 34.1209], [-117.91868, 34.12085], [-117.91899, 34.12085], [-117.91927, 34.1209], [-117.91984, 34.1209], [-117.92004, 34.12087], [-117.92028, 34.12079], [-117.92041, 34.12076], [-117.92109, 34.12076], [-117.92125, 34.12079], [-117.92137, 34.12077], [-117.92143, 34.12071], [-117.92146, 34.12063], [-117.92143, 34.12048], [-117.92143, 34.1201], [-117.92146, 34.11993], [-117.92145, 34.11987], [-117.92141, 34.11982], [-117.92179, 34.11982]]]} | Open Access 1 | Zacatecas Park | 27850 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 6.773 | Zacatecas Park | ||
12399 | 12399 | 12398 | {"type": "Polygon", "coordinates": [[[-117.92597, 34.147], [-117.92573, 34.14717], [-117.9255, 34.14736], [-117.92514, 34.14777], [-117.92517, 34.14784], [-117.92511, 34.14789], [-117.92501, 34.14781], [-117.92472, 34.14769], [-117.92525, 34.1473], [-117.92536, 34.1472], [-117.92551, 34.14714], [-117.92559, 34.14714], [-117.9257, 34.14709], [-117.92597, 34.147]]]} | Open Access 1 | Azusa Rockery | http://www.ci.azusa.ca.us/documentcenter/view/30083 | 29396 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 0.671 | Azusa Rockery |
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]);