superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10 rows where MNG_AG_TYP = 2 and YR_EST = 2016
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
86 | 86 | 85 | {"type": "Polygon", "coordinates": [[[-118.00178, 34.13276], [-118.00168, 34.13302], [-118.00144, 34.13297], [-118.00143, 34.13326], [-118.00096, 34.13325], [-118.00096, 34.13303], [-118.00094, 34.13296], [-118.00095, 34.13262], [-118.00102, 34.13264], [-118.00104, 34.13262], [-118.00163, 34.13273], [-118.00164, 34.13272], [-118.00178, 34.13276]]]} | Open Access 1 | Station Square Park | https://www.cityofmonrovia.org/Home/Components/FacilityDirectory/FacilityDirectory/16/787 | 31797 | 1209 | Monrovia, City of 309 | City 2 | City Agency 2 | http://www.cityofmonrovia.org/publicworks/page/parks | City 2 | 0.953 | Station Square Park | 2016 |
224 | 224 | 223 | {"type": "Polygon", "coordinates": [[[-117.84833, 33.96677], [-117.84766, 33.96715], [-117.84745, 33.96733], [-117.84713, 33.96767], [-117.84702, 33.96771], [-117.84699, 33.96774], [-117.8468, 33.96774], [-117.84679, 33.96772], [-117.84666, 33.96772], [-117.84618, 33.96778], [-117.84613, 33.96766], [-117.84619, 33.96762], [-117.8462, 33.96756], [-117.84623, 33.96755], [-117.84629, 33.96747], [-117.84634, 33.96745], [-117.84671, 33.96683], [-117.84686, 33.96663], [-117.84697, 33.96655], [-117.84715, 33.9665], [-117.84727, 33.96651], [-117.84729, 33.96648], [-117.84718, 33.96644], [-117.84698, 33.96642], [-117.84674, 33.96634], [-117.84666, 33.96633], [-117.84658, 33.96626], [-117.84649, 33.96622], [-117.84643, 33.96629], [-117.84616, 33.9662], [-117.8459, 33.96634], [-117.84585, 33.96623], [-117.8458, 33.96617], [-117.84555, 33.96607], [-117.8453, 33.96591], [-117.84508, 33.96583], [-117.84502, 33.96576], [-117.84498, 33.96566], [-117.84502, 33.9657], [-117.84507, 33.96572], [-117.84518, 33.96571], [-117.8469, 33.96621], [-117.84705, 33.96627], [-117.84763, 33.96656], [-117.8478, 33.96635], [-117.84796, 33.96641], [-117.84817, 33.96659], [-117.84814, 33.96665], [-117.84815, 33.96671], [-117.84818, 33.96673], [-117.84825, 33.96675], [-117.84831, 33.96674], [-117.84833, 33.96677]]]} | Open Access 1 | Diamond Canyon Park | 31870 | 1085 | Diamond Bar, City of 312 | City 2 | City Agency 2 | http://www.ci.diamond-bar.ca.us/Index.aspx?page=939 | City 2 | 4.991 | Diamond Canyon Park | 2016 | |
902 | 902 | 901 | {"type": "Polygon", "coordinates": [[[-118.2356, 34.04165], [-118.23514, 34.0417], [-118.23507, 34.04127], [-118.23553, 34.04121], [-118.2356, 34.04165]]]} | Open Access 1 | Arts District Park | 32785 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.514 | Arts District Park | 2016 | |
5380 | 5380 | 5379 | {"type": "Polygon", "coordinates": [[[-119.18952, 34.19789], [-119.18952, 34.19806], [-119.18887, 34.19807], [-119.18888, 34.19845], [-119.18803, 34.19844], [-119.18803, 34.19787], [-119.18952, 34.19789]]]} | Open Access 1 | Campus Park Dog Park | https://www.oxnard.org/dog-park-opening/ | 33011 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 1.5 | Campus Park Dog Park | 2016 |
12482 | 12482 | 12481 | {"type": "Polygon", "coordinates": [[[-118.54299, 34.19064], [-118.54284, 34.19074], [-118.54242, 34.19049], [-118.54196, 34.1903], [-118.54174, 34.19014], [-118.54291, 34.18966], [-118.54291, 34.19054], [-118.54299, 34.19064]]]} | Open Access 1 | Los Angeles River and Aliso Creek Confluence Park | https://www.tpl.org/our-work/los-angeles-river-aliso-creek-confluence-project | 31121 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1.682 | Los Angeles River and Aliso Creek Confluence Park | 2016 |
13579 | 13579 | 13578 | {"type": "Polygon", "coordinates": [[[-122.73156, 38.45287], [-122.73152, 38.45293], [-122.7309, 38.45305], [-122.73084, 38.45292], [-122.73075, 38.45281], [-122.73039, 38.4517], [-122.73106, 38.45137], [-122.73117, 38.4516], [-122.73156, 38.45287]]]} | Open Access 1 | Finali Park | https://srcity.org/Facilities/Facility/Details/Finali-Park-66 | 31030 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 2.767 | Finali Park | 2016 |
13861 | 13861 | 13860 | {"type": "Polygon", "coordinates": [[[-122.35762, 38.40022], [-122.35748, 38.40034], [-122.3573, 38.40051], [-122.35739, 38.39999], [-122.3576, 38.39989], [-122.35762, 38.40022]]]} | Open Access 1 | Oak Circle Neighborhood Park | 31413 | 1385 | Yountville, Town of 714 | City 2 | City Agency 2 | http://www.townofyountville.com/index.aspx?page=88 | City 2 | 0.249 | Oak Circle Neighborhood Park | 2016 | |
13963 | 13963 | 13962 | {"type": "Polygon", "coordinates": [[[-120.86036, 37.48086], [-120.85915, 37.48087], [-120.85916, 37.48008], [-120.86035, 37.48008], [-120.86036, 37.48086]]]} | Open Access 1 | Montana Park | 32554 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 2.272 | Montana Park | 2016 | |
14002 | 14002 | 14001 | {"type": "Polygon", "coordinates": [[[-122.50267, 37.76171], [-122.50184, 37.76175], [-122.50179, 37.76106], [-122.50262, 37.76102], [-122.50267, 37.76171]]]} | Open Access 1 | Playland at 43rd Avenue | 31457 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1.381 | Playland at 43rd Avenue | 2016 | |
14090 | 14090 | 14089 | {"type": "Polygon", "coordinates": [[[-118.19075, 33.79976], [-118.19062, 33.79976], [-118.19062, 33.79951], [-118.19075, 33.79951], [-118.19075, 33.79976]]]} | Open Access 1 | Locust Tot Lot | http://www.longbeach.gov/park/park-and-facilities/directory/locust-tot-lot/ | 32630 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.085 | Locust Tot Lot | 2016 |
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]);