superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACRES = "23.195" and MNG_AG_TYP = 17
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13426 | 13426 | 13425 | {"type": "MultiPolygon", "coordinates": [[[[-121.38001, 38.42816], [-121.37938, 38.42865], [-121.37942, 38.42872], [-121.37935, 38.42879], [-121.37911, 38.42882], [-121.3788, 38.42929], [-121.37901, 38.4298], [-121.37887, 38.4299], [-121.37871, 38.43006], [-121.37863, 38.43019], [-121.37857, 38.43039], [-121.37809, 38.43057], [-121.37771, 38.43082], [-121.37771, 38.43096], [-121.37765, 38.43099], [-121.37762, 38.43106], [-121.37752, 38.43106], [-121.37721, 38.43117], [-121.37673, 38.43052], [-121.37715, 38.43014], [-121.37735, 38.43014], [-121.37763, 38.43007], [-121.3778, 38.43], [-121.37802, 38.42985], [-121.37813, 38.42972], [-121.37824, 38.42951], [-121.37828, 38.42936], [-121.37826, 38.42913], [-121.37862, 38.42897], [-121.37891, 38.42875], [-121.3789, 38.42863], [-121.37897, 38.4286], [-121.37902, 38.42855], [-121.37918, 38.42859], [-121.37977, 38.42801], [-121.38001, 38.42816]]], [[[-121.38539, 38.42712], [-121.38534, 38.43073], [-121.38522, 38.43073], [-121.38521, 38.43017], [-121.3849, 38.42994], [-121.38457, 38.42966], [-121.38434, 38.4295], [-121.3842, 38.42927], [-121.38387, 38.42925], [-121.38382, 38.4291], [-121.38373, 38.42893], [-121.38362, 38.4288], [-121.38347, 38.42868], [-121.38328, 38.42857], [-121.38271, 38.42832], [-121.38256, 38.42826], [-121.38238, 38.42822], [-121.38237, 38.42792], [-121.38168, 38.42783], [-121.38149, 38.42747], [-121.38117, 38.4276], [-121.38116, 38.42771], [-121.38108, 38.42771], [-121.38102, 38.42776], [-121.38085, 38.42771], [-121.38048, 38.42788], [-121.38022, 38.42812], [-121.37995, 38.42794], [-121.3809, 38.42712], [-121.38539, 38.42712]]]]} | Open Access 1 | Camden Park Greenbelt | http://www.yourcsd.com/569/Camden-Park | 30810 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 23.195 | Camden Park Greenbelt |
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]);