superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, MNG_AGENCY = 322, MNG_AG_TYP = 2 and PARK_NAME = "Mountain View Park"
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency · 1 ✖
MNG_AGENCY 1
- Santa Clarita, City of · 1 ✖
ACCESS_TYP 1
- Open Access · 1 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
860 | 860 | 859 | {"type": "MultiPolygon", "coordinates": [[[[-118.53244, 34.46826], [-118.52928, 34.46833], [-118.52923, 34.46815], [-118.52921, 34.46799], [-118.52921, 34.46783], [-118.52923, 34.46767], [-118.52931, 34.46741], [-118.52962, 34.46667], [-118.53231, 34.46662], [-118.53235, 34.46665], [-118.5324, 34.4669], [-118.53256, 34.46743], [-118.53259, 34.46761], [-118.53259, 34.46776], [-118.53257, 34.46794], [-118.53252, 34.46809], [-118.53244, 34.46826]]], [[[-118.53427, 34.46657], [-118.53418, 34.46793], [-118.53413, 34.46822], [-118.53267, 34.46826], [-118.53274, 34.46811], [-118.53278, 34.46794], [-118.53281, 34.46776], [-118.53281, 34.46761], [-118.53277, 34.4674], [-118.53261, 34.46686], [-118.53256, 34.46661], [-118.53427, 34.46657]]]]} | Open Access 1 | Mountain View Park | 32720 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 19.339 | Mtn. 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]);