superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AG_TYP = 15 and PARK_NAME = "Madison Lane Park"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13031 | 13031 | 13030 | {"type": "Polygon", "coordinates": [[[-116.96275, 32.65963], [-116.96272, 32.6598], [-116.96273, 32.65988], [-116.96252, 32.65994], [-116.96249, 32.65993], [-116.96238, 32.65998], [-116.96235, 32.65997], [-116.96224, 32.66002], [-116.96221, 32.66001], [-116.96195, 32.6601], [-116.96175, 32.66013], [-116.96165, 32.65965], [-116.96164, 32.6595], [-116.96167, 32.65933], [-116.96188, 32.65935], [-116.962, 32.6594], [-116.96203, 32.65939], [-116.96215, 32.65944], [-116.96218, 32.65943], [-116.96245, 32.65955], [-116.96275, 32.65963]]]} | Restricted Access 2 | Madison Lane Park | 33353 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 1.505 | Madison Lane 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]);