superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where LABEL_NAME = "Neighborhood Park"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, LABEL_NAME
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
501 | 501 | 500 | {"type": "Polygon", "coordinates": [[[-120.88074, 37.0513], [-120.88052, 37.05153], [-120.88038, 37.05151], [-120.88026, 37.05154], [-120.8802, 37.05146], [-120.8801, 37.05143], [-120.88012, 37.05135], [-120.88008, 37.05123], [-120.88029, 37.05101], [-120.88074, 37.0513]]]} | Open Access 1 | Neighborhood Park | http://www.losbanos.org/wp-content/uploads/2013/09/rec_parks_list_2017.pdf | 33512 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 0.508 | Neighborhood Park | |
7325 | 7325 | 7324 | {"type": "Polygon", "coordinates": [[[-122.5069, 37.94708], [-122.5066, 37.94739], [-122.50652, 37.94738], [-122.50645, 37.94748], [-122.50644, 37.94755], [-122.50647, 37.94762], [-122.50645, 37.94764], [-122.50648, 37.94773], [-122.50645, 37.94786], [-122.50645, 37.94792], [-122.50653, 37.94806], [-122.50654, 37.94813], [-122.50653, 37.9482], [-122.50649, 37.94826], [-122.50648, 37.94828], [-122.50637, 37.94827], [-122.50623, 37.94819], [-122.50618, 37.94818], [-122.5061, 37.94819], [-122.50605, 37.94825], [-122.50598, 37.94821], [-122.50588, 37.94819], [-122.5059, 37.94811], [-122.50587, 37.94799], [-122.50591, 37.94789], [-122.50591, 37.9478], [-122.50592, 37.94776], [-122.50599, 37.94766], [-122.50617, 37.94756], [-122.50627, 37.94746], [-122.50626, 37.94741], [-122.50624, 37.94737], [-122.5061, 37.94721], [-122.50617, 37.94714], [-122.5062, 37.94705], [-122.50619, 37.94694], [-122.50613, 37.94685], [-122.50614, 37.94679], [-122.50625, 37.94674], [-122.50646, 37.94671], [-122.5065, 37.9468], [-122.50657, 37.94689], [-122.5069, 37.94708]]]} | Open Access 1 | Neighborhood Park | 22686 | 1170 | Larkspur, City of 444 | City 2 | City Agency 2 | http://www.ci.larkspur.ca.us/index.aspx?nid=207 | City 2 | 1.801 | Neighborhood Park | ||
11631 | 11631 | 11630 | {"type": "Polygon", "coordinates": [[[-117.76967, 34.03509], [-117.76964, 34.03513], [-117.76956, 34.03515], [-117.76946, 34.03481], [-117.76899, 34.03488], [-117.76876, 34.03465], [-117.76821, 34.03464], [-117.76771, 34.03495], [-117.76689, 34.03517], [-117.76601, 34.03488], [-117.7656, 34.03491], [-117.76508, 34.03505], [-117.76515, 34.03541], [-117.76487, 34.03548], [-117.76472, 34.03485], [-117.76774, 34.03436], [-117.76861, 34.03428], [-117.76944, 34.03426], [-117.76949, 34.03427], [-117.76952, 34.03431], [-117.76954, 34.03456], [-117.76967, 34.03509]]]} | Open Access 1 | Neighborhood Park | 28179 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 5.62 | Neighborhood Park | ||
13327 | 13327 | 13326 | {"type": "Polygon", "coordinates": [[[-124.15357, 40.79271], [-124.15356, 40.79285], [-124.15352, 40.79287], [-124.15336, 40.79288], [-124.15318, 40.79287], [-124.15314, 40.79285], [-124.15312, 40.79278], [-124.15313, 40.79266], [-124.15318, 40.79263], [-124.15345, 40.79263], [-124.15355, 40.79265], [-124.15357, 40.79271]]]} | Open Access 1 | Neighborhood Park | 30654 | 1419 | Eureka, City of 698 | City 2 | City Agency 2 | http://www.ci.eureka.ca.gov/depts/pnr/default.asp | City 2 | 0.241 | Neighborhood 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]);