superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACRES = "11.813", MNG_AGENCY = 7 and MNG_AG_TYP = 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10011 | 10011 | 10010 | {"type": "Polygon", "coordinates": [[[-119.84568, 34.44599], [-119.84615, 34.44647], [-119.84624, 34.44662], [-119.84629, 34.44677], [-119.8465, 34.44822], [-119.84663, 34.44933], [-119.84663, 34.44955], [-119.84655, 34.44989], [-119.84653, 34.45018], [-119.84655, 34.45047], [-119.84663, 34.45075], [-119.84662, 34.45079], [-119.8466, 34.45083], [-119.84655, 34.45087], [-119.84628, 34.45093], [-119.84609, 34.45095], [-119.8459, 34.45096], [-119.84512, 34.45092], [-119.84515, 34.45003], [-119.8452, 34.44961], [-119.84524, 34.44939], [-119.8453, 34.44915], [-119.84542, 34.44878], [-119.84574, 34.44803], [-119.84584, 34.44762], [-119.84586, 34.44739], [-119.84586, 34.44718], [-119.84584, 34.44697], [-119.8458, 34.44677], [-119.84565, 34.44636], [-119.84555, 34.44616], [-119.84545, 34.446], [-119.84553, 34.44596], [-119.8456, 34.44597], [-119.84564, 34.44601], [-119.84568, 34.44599]]]} | Open Access 1 | Stow Grove Park | 25905 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 11.813 | Stow Grove 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]);