units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_LEV = 2, AGNCY_TYP = 2, DES_TP = 836 and MNG_AG_TYP = 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9687 | 9687 | 9686 | {"type": "MultiPolygon", "coordinates": [[[[-122.5738, 38.0748], [-122.57374, 38.07513], [-122.57352, 38.07506], [-122.57336, 38.07513], [-122.57324, 38.07511], [-122.573, 38.07515], [-122.57284, 38.07521], [-122.57273, 38.07555], [-122.57268, 38.07576], [-122.57249, 38.07592], [-122.57248, 38.07599], [-122.5722, 38.07595], [-122.5721, 38.07578], [-122.57194, 38.07573], [-122.57167, 38.0758], [-122.5714, 38.07568], [-122.57062, 38.07526], [-122.57063, 38.07523], [-122.57048, 38.0751], [-122.57043, 38.07504], [-122.57041, 38.07497], [-122.57026, 38.07492], [-122.56982, 38.07491], [-122.56971, 38.07493], [-122.56939, 38.07488], [-122.56978, 38.07457], [-122.56949, 38.07437], [-122.56952, 38.07418], [-122.5694, 38.07399], [-122.56918, 38.07393], [-122.56931, 38.0739], [-122.56954, 38.07392], [-122.56959, 38.07422], [-122.56954, 38.07433], [-122.56957, 38.07437], [-122.56999, 38.07469], [-122.57064, 38.07463], [-122.57077, 38.07471], [-122.57079, 38.07478], [-122.57077, 38.07488], [-122.57077, 38.07494], [-122.57087, 38.07498], [-122.57081, 38.07504], [-122.571, 38.07516], [-122.57106, 38.07526], [-122.57141, 38.07545], [-122.57158, 38.07541], [-122.57234, 38.07557], [-122.57264, 38.07508], [-122.57294, 38.07492], [-122.57327, 38.07489], [-122.57352, 38.07477], [-122.5738, 38.0748]]], [[[-122.57278, 38.07419], [-122.57273, 38.0745], [-122.57254, 38.0746], [-122.57232, 38.07466], [-122.57233, 38.07451], [-122.57161, 38.07445], [-122.57157, 38.07466], [-122.57147, 38.07468], [-122.57103, 38.07453], [-122.57073, 38.07435], [-122.57078, 38.07402], [-122.57278, 38.07419]]]]} | Open Access 1 | 16355 | Novato Lands 004 | 22915 | 1226 | Novato, City of 444 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | Marin 23 | 5.723 | Novato Lands 004 | None 836 |
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]);