units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where ACCESS_TYP = 2, COUNTY = 15 and MNG_AGENCY = 571
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3335 | 3335 | 3334 | {"type": "Polygon", "coordinates": [[[-122.28809, 37.19438], [-122.28359, 37.19448], [-122.2835, 37.19108], [-122.28806, 37.19066], [-122.28809, 37.19438]]]} | Restricted Access 2 | 29767 | Krvavica | 20728 | 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 | San Mateo 15 | 39.366 | Krvavica | 0 | Private Conservation 16 | 2 | |
5431 | 5431 | 5430 | {"type": "Polygon", "coordinates": [[[-122.28359, 37.19448], [-122.27908, 37.19458], [-122.2789, 37.1915], [-122.28349, 37.19108], [-122.28359, 37.19448]]]} | Restricted Access 2 | 24949 | Welden | 27339 | 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 | San Mateo 15 | 36.036 | Welden | 0 | Private Conservation 16 | 2 | |
5432 | 5432 | 5431 | {"type": "Polygon", "coordinates": [[[-122.27908, 37.19458], [-122.27174, 37.1941], [-122.27109, 37.19325], [-122.27157, 37.19273], [-122.27165, 37.19281], [-122.27207, 37.19259], [-122.27297, 37.19241], [-122.27343, 37.19201], [-122.2743, 37.19257], [-122.27482, 37.19258], [-122.27577, 37.19236], [-122.27656, 37.19279], [-122.27741, 37.19296], [-122.27773, 37.19264], [-122.27759, 37.1919], [-122.27791, 37.19156], [-122.27818, 37.19107], [-122.27849, 37.1909], [-122.27887, 37.19098], [-122.27908, 37.19458]]]} | Restricted Access 2 | 24950 | Cobb/Mahoney | 17468 | 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 | San Mateo 15 | 37.31 | Cobb/Mahoney | 0 | Private Conservation 16 | 2 | |
5433 | 5433 | 5432 | {"type": "Polygon", "coordinates": [[[-122.28349, 37.19108], [-122.2789, 37.1915], [-122.27872, 37.18835], [-122.28339, 37.18766], [-122.28349, 37.19108]]]} | Restricted Access 2 | 24951 | Santos | 25153 | 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 | San Mateo 15 | 37.316 | Santos | 0 | Private Conservation 16 | 2 | |
12736 | 12736 | 12735 | {"type": "Polygon", "coordinates": [[[-122.31405, 37.24358], [-122.31388, 37.2472], [-122.29676, 37.24603], [-122.29663, 37.24252], [-122.30563, 37.24306], [-122.31405, 37.24358]]]} | Restricted Access 2 | 29768 | Sinnott | 31348 | 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 | San Mateo 15 | 150.159 | Sinnott | 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]);