units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 2, MNG_AGENCY = 571, MNG_AG_TYP = 10 and UNIT_NAME = "Minton"
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Non Profit - Land Trust · 1 ✖
MNG_AGENCY 1
- Sempervirens Fund · 1 ✖
DES_TP 1
ACCESS_TYP 1
- Restricted Access · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5435 | 5435 | 5434 | {"type": "Polygon", "coordinates": [[[-122.20851, 37.20799], [-122.19951, 37.20811], [-122.19945, 37.20114], [-122.20078, 37.20112], [-122.20302, 37.20112], [-122.20315, 37.20121], [-122.20326, 37.20133], [-122.20386, 37.20156], [-122.20393, 37.20167], [-122.20396, 37.20179], [-122.20389, 37.20192], [-122.20365, 37.2021], [-122.20327, 37.20232], [-122.20324, 37.2024], [-122.20328, 37.20246], [-122.20342, 37.2025], [-122.20429, 37.2026], [-122.2047, 37.20269], [-122.20484, 37.20279], [-122.20485, 37.20287], [-122.20482, 37.20295], [-122.20458, 37.20319], [-122.20444, 37.20343], [-122.20457, 37.20383], [-122.20451, 37.20394], [-122.2044, 37.20408], [-122.20434, 37.20426], [-122.20434, 37.20436], [-122.20446, 37.20474], [-122.20473, 37.20519], [-122.20481, 37.20526], [-122.2049, 37.2053], [-122.20533, 37.20541], [-122.20539, 37.20553], [-122.20543, 37.2057], [-122.20549, 37.20585], [-122.20569, 37.20598], [-122.20589, 37.20616], [-122.20594, 37.20623], [-122.20601, 37.2064], [-122.20612, 37.20652], [-122.2062, 37.20674], [-122.20625, 37.2068], [-122.20642, 37.20685], [-122.20662, 37.20686], [-122.20684, 37.20692], [-122.20695, 37.20697], [-122.20705, 37.20705], [-122.20713, 37.20711], [-122.20727, 37.20727], [-122.20735, 37.20733], [-122.20758, 37.20741], [-122.20789, 37.20746], [-122.20809, 37.20755], [-122.20844, 37.20777], [-122.2085, 37.20786], [-122.20851, 37.20799]]]} | Restricted Access 2 | 24952 | Minton | 22271 | 3110 | Sempervirens Fund 579 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sempervirens.org/ | Non Governmental Organization 10 | 3110 | Sempervirens Fund 571 | Non Profit 6 | Non Profit - Land Trust 10 | Santa Cruz 5 | 95.844 | Minton | 0 | Private Conservation 16 | 2 |
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]);