superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9 rows where ACCESS_TYP = 1, MNG_AG_TYP = 2 and PARK_NAME = "Wilson Park"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11299 | 11299 | 11298 | {"type": "Polygon", "coordinates": [[[-119.02991, 35.33394], [-119.02831, 35.33395], [-119.0283, 35.33234], [-119.0299, 35.33233], [-119.02991, 35.33394]]]} | Open Access 1 | Wilson Park | 27606 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 6.419 | Wilson Park | ||
11300 | 11300 | 11299 | {"type": "Polygon", "coordinates": [[[-118.22008, 33.89821], [-118.21914, 33.89821], [-118.21913, 33.8979], [-118.21964, 33.89787], [-118.21962, 33.89786], [-118.21913, 33.89785], [-118.2191, 33.89645], [-118.21965, 33.89645], [-118.21967, 33.89608], [-118.21974, 33.89608], [-118.21977, 33.89619], [-118.22008, 33.89821]]]} | Open Access 1 | Wilson Park | 27607 | 1065 | Compton, City of 271 | City 2 | City Agency 2 | http://www.comptoncity.org/index.php/Parks-and-Recreation/parks-and-recreation-overview.htm | City 2 | 3.745 | Wilson Park | ||
11303 | 11303 | 11302 | {"type": "Polygon", "coordinates": [[[-117.91515, 33.65803], [-117.91463, 33.65803], [-117.91461, 33.6573], [-117.91415, 33.6573], [-117.91414, 33.65666], [-117.91411, 33.65664], [-117.9141, 33.65627], [-117.91513, 33.65627], [-117.91515, 33.65803]]]} | Open Access 1 | Wilson Park | 27608 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 3.641 | Wilson Park | ||
11304 | 11304 | 11303 | {"type": "Polygon", "coordinates": [[[-122.02204, 37.31857], [-122.02204, 37.31871], [-122.02193, 37.31872], [-122.02188, 37.31876], [-122.02186, 37.31879], [-122.02187, 37.31884], [-122.02191, 37.31892], [-122.02191, 37.31979], [-122.02189, 37.31981], [-122.02178, 37.3198], [-122.02146, 37.31969], [-122.02119, 37.31965], [-122.02101, 37.31966], [-122.02062, 37.31972], [-122.02055, 37.31966], [-122.02026, 37.31966], [-122.02024, 37.31975], [-122.01989, 37.31974], [-122.01988, 37.3197], [-122.01985, 37.31967], [-122.01976, 37.31964], [-122.01962, 37.31968], [-122.0186, 37.31968], [-122.01922, 37.31816], [-122.02042, 37.31832], [-122.02043, 37.31836], [-122.02204, 37.31857]]]} | Open Access 1 | Wilson Park | 27609 | 1076 | Cupertino, City of 191 | City 2 | City Agency 2 | http://www.cupertino.org/index.aspx?page=591 | City 2 | 9.937 | Wilson Park | 1966 | |
11305 | 11305 | 11304 | {"type": "Polygon", "coordinates": [[[-119.83984, 36.79196], [-119.83983, 36.79363], [-119.83765, 36.79364], [-119.83767, 36.79198], [-119.83984, 36.79196]]]} | Open Access 1 | Wilson Park | 27610 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 8.871 | Wilson Park | ||
11306 | 11306 | 11305 | {"type": "Polygon", "coordinates": [[[-121.21889, 37.79865], [-121.21889, 37.79885], [-121.21877, 37.79901], [-121.21842, 37.799], [-121.21843, 37.79865], [-121.21889, 37.79865]]]} | Open Access 1 | Wilson Park | 27611 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 0.381 | Wilson Park | ||
11307 | 11307 | 11306 | {"type": "Polygon", "coordinates": [[[-119.18086, 34.20514], [-119.18088, 34.20519], [-119.18086, 34.20645], [-119.17917, 34.20643], [-119.17914, 34.2064], [-119.17916, 34.20512], [-119.17976, 34.20508], [-119.18046, 34.20513], [-119.18081, 34.20512], [-119.18086, 34.20514]]]} | Open Access 1 | Wilson Park | 27612 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 5.805 | Wilson Park | ||
11854 | 11854 | 11853 | {"type": "Polygon", "coordinates": [[[-121.61752, 38.15935], [-121.61689, 38.16065], [-121.61656, 38.16055], [-121.61616, 38.16046], [-121.61567, 38.1604], [-121.6159, 38.15931], [-121.616, 38.15921], [-121.61593, 38.15918], [-121.61598, 38.15895], [-121.61604, 38.15891], [-121.61752, 38.15935]]]} | Open Access 1 | Wilson Park | 28502 | 1150 | Isleton, City of 932 | City 2 | City Agency 2 | http://www.isletoncoc.org/ | City 2 | 4.952 | Wilson Park | ||
13293 | 13293 | 13292 | {"type": "Polygon", "coordinates": [[[-121.28975, 38.84529], [-121.28927, 38.84568], [-121.28784, 38.84665], [-121.28679, 38.84581], [-121.28707, 38.84516], [-121.28975, 38.84529]]]} | Open Access 1 | Wilson Park | http://www.lincolnca.gov/city-hall/departments-divisions/parks-recreation/parks | 33423 | 1175 | Lincoln, City of 597 | City 2 | City Agency 2 | http://www.ci.lincoln.ca.us/default.aspx?Jpage=41500 | City 2 | 5.842 | Wilson 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]);