superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACRES = "3.193", MNG_AGENCY = 597 and MNG_AG_TYP = 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13284 | 13284 | 13283 | {"type": "Polygon", "coordinates": [[[-121.31589, 38.87895], [-121.31574, 38.87908], [-121.31563, 38.87923], [-121.31559, 38.87931], [-121.31557, 38.87944], [-121.31558, 38.87979], [-121.31528, 38.87978], [-121.31501, 38.87999], [-121.3149, 38.87983], [-121.31465, 38.87964], [-121.31447, 38.87957], [-121.31412, 38.87946], [-121.31409, 38.87943], [-121.31408, 38.87939], [-121.31416, 38.87919], [-121.31419, 38.87898], [-121.31426, 38.87895], [-121.3144, 38.87895], [-121.31462, 38.879], [-121.31471, 38.87906], [-121.31471, 38.87918], [-121.31474, 38.87922], [-121.31478, 38.87925], [-121.31484, 38.87926], [-121.31492, 38.87925], [-121.31499, 38.87916], [-121.31503, 38.87916], [-121.3151, 38.87905], [-121.31509, 38.87832], [-121.3153, 38.87841], [-121.31549, 38.87854], [-121.31588, 38.8789], [-121.31589, 38.87895]]]} | Open Access 1 | Machado Park | http://www.lincolnca.gov/city-hall/departments-divisions/parks-recreation/parks | 33421 | 1175 | Lincoln, City of 597 | City 2 | City Agency 2 | http://www.ci.lincoln.ca.us/default.aspx?Jpage=41500 | City 2 | 3.193 | Machado 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]);