superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LABEL_NAME = "Roseville holding 16" and MNG_AGENCY = 533
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8961 | 8961 | 8960 | {"type": "Polygon", "coordinates": [[[-121.25119, 38.76227], [-121.25118, 38.76283], [-121.2511, 38.76283], [-121.25103, 38.76312], [-121.2508, 38.7631], [-121.25076, 38.76321], [-121.25066, 38.76323], [-121.25051, 38.76324], [-121.25048, 38.7634], [-121.25038, 38.76345], [-121.25015, 38.76348], [-121.25016, 38.76361], [-121.25006, 38.76369], [-121.24974, 38.76379], [-121.24939, 38.76382], [-121.24918, 38.76394], [-121.24886, 38.76392], [-121.24872, 38.76407], [-121.24858, 38.76412], [-121.24851, 38.76423], [-121.24827, 38.76432], [-121.24834, 38.76444], [-121.2483, 38.76454], [-121.24817, 38.76459], [-121.2481, 38.76466], [-121.24802, 38.76467], [-121.24783, 38.76464], [-121.24778, 38.76447], [-121.2475, 38.76446], [-121.2474, 38.76452], [-121.24729, 38.76448], [-121.24719, 38.76453], [-121.24699, 38.76451], [-121.24685, 38.76442], [-121.24659, 38.76445], [-121.24649, 38.76427], [-121.24634, 38.76433], [-121.246, 38.76432], [-121.24588, 38.76427], [-121.24584, 38.76423], [-121.24585, 38.76419], [-121.24589, 38.76416], [-121.24618, 38.7642], [-121.24654, 38.76409], [-121.24674, 38.76424], [-121.24693, 38.76415], [-121.2472, 38.76415], [-121.24724, 38.76406], [-121.24738, 38.76404], [-121.24771, 38.76422], [-121.24794, 38.7639], [-121.24792, 38.76371], [-121.24802, 38.76359], [-121.24826, 38.76352], [-121.24827, 38.76329], [-121.24881, 38.76292], [-121.24897, 38.7627], [-121.24922, 38.76266], [-121.24933, 38.76223], [-121.24988, 38.76224], [-121.24989, 38.76222], [-121.25095, 38.76223], [-121.25096, 38.76227], [-121.25119, 38.76227]]]} | Open Access 1 | Roseville holding 16 | 24634 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 10.667 | Roseville holding 16 |
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]);