superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where ACRES = "0.289"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7084 | 7084 | 7083 | {"type": "Polygon", "coordinates": [[[-120.97873, 37.64514], [-120.97864, 37.64523], [-120.97846, 37.64535], [-120.97815, 37.64548], [-120.97793, 37.64552], [-120.97788, 37.6455], [-120.97788, 37.64545], [-120.97793, 37.64541], [-120.97866, 37.6451], [-120.97872, 37.64511], [-120.97873, 37.64514]]]} | Open Access 1 | Modesto holding 2 | 22338 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 0.289 | Modesto holding 2 | ||
9292 | 9292 | 9291 | {"type": "Polygon", "coordinates": [[[-119.72261, 34.40986], [-119.72251, 34.41013], [-119.72213, 34.41004], [-119.72223, 34.40976], [-119.72261, 34.40986]]]} | Unknown Access 4 | Santa Barbara holding 6 | 25048 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 0.289 | Santa Barbara holding 6 | ||
10565 | 10565 | 10564 | {"type": "Polygon", "coordinates": [[[-119.65231, 36.79585], [-119.65231, 36.79617], [-119.65185, 36.79611], [-119.65214, 36.79577], [-119.65218, 36.79576], [-119.65227, 36.7958], [-119.65231, 36.79585]]]} | Open Access 1 | Arrowhead Park | 33294 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 0.289 | Arrowhead Park | ||
10653 | 10653 | 10652 | {"type": "Polygon", "coordinates": [[[-122.364, 38.40385], [-122.3637, 38.40397], [-122.36328, 38.40334], [-122.36328, 38.40334], [-122.364, 38.40385]]]} | Open Access 1 | Van de Leur Park | 26825 | 1385 | Yountville, Town of 714 | City 2 | City Agency 2 | http://www.townofyountville.com/index.aspx?page=88 | City 2 | 0.289 | Van de Leur Park | ||
11888 | 11888 | 11887 | {"type": "Polygon", "coordinates": [[[-121.96105, 36.96553], [-121.96093, 36.96566], [-121.9605, 36.9653], [-121.96048, 36.96524], [-121.96044, 36.96518], [-121.96044, 36.96515], [-121.96055, 36.96512], [-121.96105, 36.96553]]]} | Open Access 1 | Privates Beach Accessway | 28594 | 2103 | Opal Cliffs Recreation District 1054 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 0.289 | Privates Beach Accessway | |||
13729 | 13729 | 13728 | {"type": "Polygon", "coordinates": [[[-117.17059, 34.11122], [-117.17054, 34.11131], [-117.17047, 34.11137], [-117.17038, 34.1114], [-117.1703, 34.11142], [-117.17021, 34.11141], [-117.17011, 34.11137], [-117.17005, 34.11132], [-117.17, 34.11124], [-117.17006, 34.11117], [-117.17052, 34.11115], [-117.17059, 34.11122]]]} | Restricted Access 2 | Palm View Park | http://www.ehrhoa.com/info.php?pnum=458ee5f40122cd | 33136 | 7031 | East Highlands Ranch MHOA 839 | Private 7 | Home Owners Association 15 | http://www.ehrhoa.com/info.php?pnum=458ee5f40122cd | Private 14 | 0.289 | Palm View 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]);