units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACRES = "19.608" and MNG_AGENCY = 533
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12638 | 12638 | 12637 | {"type": "Polygon", "coordinates": [[[-121.32235, 38.77502], [-121.3223, 38.77522], [-121.32183, 38.77515], [-121.32143, 38.77515], [-121.32093, 38.77498], [-121.3209, 38.77459], [-121.32073, 38.77439], [-121.32028, 38.77427], [-121.3203, 38.77396], [-121.32003, 38.77396], [-121.31987, 38.77404], [-121.31981, 38.774], [-121.32012, 38.77377], [-121.32012, 38.77376], [-121.32002, 38.7737], [-121.3197, 38.77371], [-121.3194, 38.77368], [-121.31886, 38.77347], [-121.31851, 38.77309], [-121.31834, 38.77284], [-121.31806, 38.77272], [-121.31778, 38.7728], [-121.31726, 38.77267], [-121.31716, 38.77296], [-121.31683, 38.77291], [-121.31615, 38.77284], [-121.31597, 38.7728], [-121.31579, 38.7727], [-121.31567, 38.77257], [-121.31561, 38.77242], [-121.31561, 38.7724], [-121.31565, 38.77236], [-121.31601, 38.77225], [-121.31646, 38.77209], [-121.31704, 38.77184], [-121.31745, 38.77162], [-121.31775, 38.77144], [-121.31832, 38.77103], [-121.31878, 38.7714], [-121.31909, 38.77184], [-121.31935, 38.77202], [-121.31952, 38.77225], [-121.31994, 38.77213], [-121.32013, 38.77274], [-121.32024, 38.7729], [-121.32039, 38.77303], [-121.32013, 38.77326], [-121.32037, 38.77349], [-121.32181, 38.77371], [-121.32205, 38.77382], [-121.32225, 38.77407], [-121.32193, 38.77492], [-121.32235, 38.77502]]]} | Open Access 1 | 29455 | Misty Wood Park | 22322 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 19.608 | Misty Wood Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);