units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, MNG_AGENCY = 663 and UNIT_NAME = "Johnson Canyon"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
DES_TP 1
ACCESS_TYP 1
- Open 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14584 | 14584 | 14583 | {"type": "Polygon", "coordinates": [[[-120.32338, 39.34317], [-120.32337, 39.34391], [-120.30973, 39.34397], [-120.30044, 39.34397], [-120.30043, 39.34032], [-120.29116, 39.34034], [-120.29115, 39.34396], [-120.28206, 39.3438], [-120.28198, 39.33642], [-120.27966, 39.33639], [-120.27965, 39.33476], [-120.28196, 39.33477], [-120.28191, 39.33037], [-120.2869, 39.33201], [-120.28798, 39.33307], [-120.28812, 39.33318], [-120.28832, 39.33329], [-120.28851, 39.33336], [-120.28871, 39.3334], [-120.28896, 39.33341], [-120.2892, 39.33338], [-120.28943, 39.33331], [-120.28967, 39.33319], [-120.28981, 39.33307], [-120.28994, 39.33291], [-120.29003, 39.33273], [-120.29006, 39.3326], [-120.29007, 39.3324], [-120.29163, 39.33241], [-120.2958, 39.32982], [-120.2958, 39.33668], [-120.30043, 39.33667], [-120.30044, 39.33031], [-120.30249, 39.3316], [-120.30448, 39.33444], [-120.30612, 39.33836], [-120.30973, 39.34078], [-120.31011, 39.34112], [-120.31043, 39.34138], [-120.31078, 39.34162], [-120.31114, 39.34184], [-120.31153, 39.34204], [-120.31193, 39.34222], [-120.31235, 39.34237], [-120.31288, 39.34253], [-120.31344, 39.34266], [-120.31389, 39.34273], [-120.31435, 39.34278], [-120.31481, 39.3428], [-120.31527, 39.34279], [-120.31573, 39.34277], [-120.31619, 39.34271], [-120.31663, 39.34263], [-120.31729, 39.34247], [-120.3183, 39.34214], [-120.31859, 39.34207], [-120.31895, 39.34201], [-120.31924, 39.34197], [-120.31962, 39.34196], [-120.31999, 39.34196], [-120.32028, 39.34199], [-120.32072, 39.34205], [-120.32101, 39.34212], [-120.32163, 39.34232], [-120.32195, 39.34246], [-120.32238, 39.3427], [-120.3226, 39.34285], [-120.32291, 39.3431], [-120.32338, 39.34317]]]} | Open Access 1 | 44734 | Johnson Canyon | 29289 | 3104 | Truckee Donner Land Trust 673 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tdlandtrust.org/ | Non Governmental Organization 10 | 3104 | Truckee Donner Land Trust 663 | Non Profit 6 | Non Profit - Land Trust 10 | http://tdlandtrust.org/johnson-canyon | Nevada 30 | 641.093 | Johnson Canyon | 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]);