units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_LEV = 2, DES_TP = 3 and MNG_AGENCY = 431
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- San Anselmo, City of · 1 ✖
DES_TP 1
- Local Recreation Area · 1 ✖
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16058 | 16058 | 16057 | {"type": "Polygon", "coordinates": [[[-122.58498, 37.99403], [-122.58346, 37.99421], [-122.58359, 37.99479], [-122.58257, 37.99492], [-122.58243, 37.99485], [-122.58245, 37.99539], [-122.58253, 37.99559], [-122.58243, 37.99584], [-122.58223, 37.99573], [-122.58183, 37.99567], [-122.5815, 37.9957], [-122.5811, 37.99598], [-122.58104, 37.99603], [-122.58104, 37.99606], [-122.57991, 37.99606], [-122.57985, 37.99604], [-122.58042, 37.99563], [-122.57982, 37.99515], [-122.57963, 37.99507], [-122.57941, 37.99513], [-122.57896, 37.99513], [-122.57868, 37.99492], [-122.5784, 37.99489], [-122.5783, 37.99493], [-122.57828, 37.99496], [-122.57832, 37.99525], [-122.57826, 37.99552], [-122.57816, 37.99542], [-122.57817, 37.99525], [-122.57812, 37.99494], [-122.57814, 37.9949], [-122.57818, 37.99485], [-122.57812, 37.99479], [-122.57823, 37.9947], [-122.57835, 37.99468], [-122.57843, 37.99469], [-122.57864, 37.99473], [-122.57909, 37.99489], [-122.57924, 37.99453], [-122.57916, 37.99435], [-122.58012, 37.99433], [-122.58181, 37.99437], [-122.58222, 37.99416], [-122.5818, 37.99359], [-122.58167, 37.99314], [-122.58144, 37.99287], [-122.58138, 37.9926], [-122.58137, 37.99233], [-122.58123, 37.99212], [-122.58104, 37.99137], [-122.58111, 37.99137], [-122.58112, 37.99141], [-122.58119, 37.99145], [-122.58158, 37.99157], [-122.58164, 37.99162], [-122.58238, 37.99161], [-122.58266, 37.9915], [-122.58272, 37.99158], [-122.58311, 37.99146], [-122.58303, 37.99126], [-122.58326, 37.99094], [-122.58312, 37.99086], [-122.58325, 37.99064], [-122.58297, 37.99059], [-122.58298, 37.99057], [-122.58347, 37.99064], [-122.58354, 37.99055], [-122.58498, 37.99403]]]} | Open Access 1 | 6857 | Hawthorne Hills Town Open Space | 19751 | 1292 | San Anselmo, City of 437 | City 2 | City Agency 2 | http://www.townofsananselmo.org/index.aspx?nid=106 | City 2 | 1292 | San Anselmo, City of 431 | City 2 | City Agency 2 | Marin 23 | 32.945 | Hawthorne Hills Town OS | 0 | Local Recreation Area 3 | 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]);