units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where ACCESS_TYP = 4, DES_TP = 16 and MNG_AG_ID = 3074
This data as json, copyable, CSV (advanced)
Suggested facets: COUNTY, YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
120 | 120 | 119 | {"type": "Polygon", "coordinates": [[[-123.78052, 39.29709], [-123.78043, 39.29964], [-123.77587, 39.29973], [-123.77122, 39.29977], [-123.77099, 39.29555], [-123.77061, 39.29557], [-123.77054, 39.29471], [-123.7708, 39.29489], [-123.77101, 39.29492], [-123.77111, 39.29503], [-123.77132, 39.29511], [-123.77154, 39.29529], [-123.77225, 39.29551], [-123.77299, 39.29488], [-123.77329, 39.29439], [-123.77335, 39.29402], [-123.77311, 39.29345], [-123.77325, 39.29328], [-123.77364, 39.29341], [-123.77396, 39.29356], [-123.77417, 39.29367], [-123.77432, 39.2938], [-123.77443, 39.29393], [-123.7745, 39.29409], [-123.77451, 39.29457], [-123.7746, 39.29494], [-123.77467, 39.29504], [-123.775, 39.29528], [-123.77583, 39.29574], [-123.77585, 39.29616], [-123.7769, 39.29616], [-123.77711, 39.2962], [-123.77803, 39.29633], [-123.77875, 39.29629], [-123.77892, 39.29631], [-123.77935, 39.29648], [-123.78002, 39.29686], [-123.7802, 39.297], [-123.78052, 39.29709]]]} | Unknown Access 4 | 46785 | Big River-Mendocino Old-Growth Redwoods | 30239 | 3074 | Save the Redwoods League 52 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.savetheredwoods.org | Non Governmental Organization 10 | 3074 | Save the Redwoods League 50 | Non Profit 6 | Non Profit - Land Trust 10 | Mendocino 24 | 92.451 | Big River-Mendocino Old-Growth Redwoods | 0 | Private Conservation 16 | 2 | |
5893 | 5893 | 5892 | {"type": "Polygon", "coordinates": [[[-124.0476, 41.30161], [-124.04702, 41.30206], [-124.04612, 41.30252], [-124.04528, 41.30274], [-124.04622, 41.30429], [-124.04651, 41.30425], [-124.04688, 41.30455], [-124.04662, 41.30539], [-124.04623, 41.30514], [-124.04619, 41.30507], [-124.0461, 41.30505], [-124.04612, 41.30606], [-124.04595, 41.30602], [-124.04503, 41.30596], [-124.04517, 41.30612], [-124.04525, 41.31016], [-124.04507, 41.3112], [-124.04396, 41.3131], [-124.04226, 41.31424], [-124.0411, 41.31599], [-124.04101, 41.31625], [-124.04008, 41.31624], [-124.03943, 41.31654], [-124.03957, 41.31625], [-124.03992, 41.3159], [-124.04058, 41.31577], [-124.04093, 41.31553], [-124.0415, 41.31441], [-124.0425, 41.31351], [-124.04384, 41.31249], [-124.04423, 41.31194], [-124.0446, 41.31063], [-124.04452, 41.3099], [-124.04374, 41.30915], [-124.04234, 41.30856], [-124.04208, 41.30829], [-124.04181, 41.30791], [-124.04152, 41.30769], [-124.03988, 41.30602], [-124.03979, 41.30554], [-124.03971, 41.30484], [-124.03954, 41.30281], [-124.03953, 41.30198], [-124.03979, 41.30125], [-124.04042, 41.30076], [-124.04103, 41.30043], [-124.04173, 41.30022], [-124.04304, 41.30023], [-124.04305, 41.30015], [-124.044, 41.30014], [-124.04458, 41.30009], [-124.04586, 41.3005], [-124.0476, 41.30161]]]} | Unknown Access 4 | 46786 | Orick Mill Site | 30240 | 3074 | Save the Redwoods League 52 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.savetheredwoods.org | Non Governmental Organization 10 | 3074 | Save the Redwoods League 50 | Non Profit 6 | Non Profit - Land Trust 10 | Humboldt 45 | 125.427 | Orick Mill Site | 0 | Private Conservation 16 | 2 | |
5894 | 5894 | 5893 | {"type": "Polygon", "coordinates": [[[-124.04065, 41.3174], [-124.03951, 41.32033], [-124.03923, 41.32036], [-124.03889, 41.32062], [-124.03874, 41.32109], [-124.03872, 41.32125], [-124.03832, 41.32127], [-124.03852, 41.32073], [-124.03931, 41.31984], [-124.03934, 41.31945], [-124.03918, 41.31876], [-124.03895, 41.31814], [-124.03895, 41.31789], [-124.03916, 41.31755], [-124.04065, 41.3174]]]} | Unknown Access 4 | 46787 | Berry Glen Trail Connection | 30241 | 3074 | Save the Redwoods League 52 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.savetheredwoods.org | Non Governmental Organization 10 | 3074 | Save the Redwoods League 50 | Non Profit 6 | Non Profit - Land Trust 10 | Humboldt 45 | 6.789 | Berry Glen Trail Connection | 0 | Private Conservation 16 | 2 | |
10600 | 10600 | 10599 | {"type": "Polygon", "coordinates": [[[-123.31159, 38.63197], [-123.31112, 38.63968], [-123.2963, 38.63978], [-123.29666, 38.63575], [-123.28701, 38.6359], [-123.28723, 38.63198], [-123.28725, 38.62452], [-123.30782, 38.62432], [-123.30767, 38.63183], [-123.31159, 38.63197]]]} | Unknown Access 4 | 48628 | Harold Richardson Redwood Reserve | 33334 | 3074 | Save the Redwoods League 52 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.savetheredwoods.org | Non Governmental Organization 10 | 3074 | Save the Redwoods League 50 | Non Profit 6 | Non Profit - Land Trust 10 | https://www.savetheredwoods.org/ | Sonoma 16 | 732.202 | Harold Richardson Redwood Reserve | 2018 | 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]);