units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

1 row where COUNTY = 45 and DES_TP = 209

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

DES_TP 1

  • State Wilderness · 1 ✖

ACCESS_TYP 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
16598 16598 16597 {"type": "MultiPolygon", "coordinates": [[[[-123.93946, 40.01887], [-123.93911, 40.01916], [-123.93884, 40.0194], [-123.93855, 40.01984], [-123.93854, 40.01992], [-123.9383, 40.01993], [-123.93827, 40.02004], [-123.93827, 40.02051], [-123.93832, 40.02105], [-123.93852, 40.02146], [-123.93875, 40.02156], [-123.93907, 40.02155], [-123.93843, 40.02184], [-123.93813, 40.02161], [-123.93799, 40.02145], [-123.93788, 40.02123], [-123.93784, 40.0211], [-123.93779, 40.02083], [-123.93779, 40.02065], [-123.93783, 40.02035], [-123.93783, 40.02022], [-123.93783, 40.02008], [-123.93779, 40.01993], [-123.938, 40.01962], [-123.93807, 40.01935], [-123.938, 40.01897], [-123.93784, 40.01866], [-123.93758, 40.01833], [-123.93698, 40.01786], [-123.93633, 40.01729], [-123.93564, 40.01677], [-123.93501, 40.01632], [-123.935, 40.01643], [-123.93445, 40.01596], [-123.93398, 40.01565], [-123.93358, 40.01533], [-123.93344, 40.01519], [-123.9334, 40.01486], [-123.93346, 40.0148], [-123.93373, 40.01415], [-123.93377, 40.01389], [-123.93366, 40.01369], [-123.93341, 40.01348], [-123.93258, 40.01291], [-123.93238, 40.01273], [-123.932, 40.01207], [-123.93182, 40.01192], [-123.93117, 40.0117], [-123.93093, 40.01153], [-123.93061, 40.01122], [-123.93047, 40.01105], [-123.93027, 40.01075], [-123.93002, 40.0103], [-123.92992, 40.01003], [-123.92954, 40.0101], [-123.92943, 40.00986], [-123.92996, 40.00971], [-123.93001, 40.00963], [-123.93, 40.00945], [-123.9299, 40.0092], [-123.92966, 40.00896], [-123.92552, 40.00897], [-123.92566, 40.00527], [-123.9301, 40.0054], [-123.93, 40.00572], [-123.93002, 40.006], [-123.93001, 40.00614], [-123.92988, 40.00632], [-123.92984, 40.00744], [-123.92979, 40.00758], [-123.92986, 40.00772], [-123.93002, 40.00799], [-123.92998, 40.00828], [-123.93, 40.00867], [-123.93015, 40.00907], [-123.93485, 40.00921], [-123.93475, 40.01267], [-123.935, 40.01605], [-123.93545, 40.01622], [-123.93567, 40.01643], [-123.93677, 40.01713], [-123.93719, 40.01753], [-123.93823, 40.01813], [-123.93919, 40.01849], [-123.93929, 40.01858], [-123.93928, 40.01869], [-123.93911, 40.01887], [-123.93911, 40.01889], [-123.93946, 40.01887]]], [[[-123.93798, 40.02166], [-123.9373, 40.02234], [-123.93638, 40.02269], [-123.93547, 40.02291], [-123.93529, 40.01998], [-123.93368, 40.02012], [-123.93366, 40.01977], [-123.93347, 40.01952], [-123.93331, 40.01896], [-123.93277, 40.01858], [-123.93266, 40.01823], [-123.93239, 40.01797], [-123.93202, 40.01788], [-123.9317, 40.01789], [-123.93158, 40.01776], [-123.93214, 40.0173], [-123.93266, 40.0171], [-123.9334, 40.01678], [-123.93436, 40.01603], [-123.93562, 40.01696], [-123.93686, 40.01805], [-123.93606, 40.01814], [-123.93606, 40.01816], [-123.93632, 40.0185], [-123.9357, 40.01855], [-123.93638, 40.01947], [-123.93789, 40.01943], [-123.93762, 40.01993], [-123.93765, 40.02033], [-123.93694, 40.0203], [-123.93687, 40.02137], [-123.9377, 40.02141], [-123.93777, 40.02138], [-123.93785, 40.0215], [-123.93798, 40.02166]]], [[[-124.00725, 40.1433], [-124.00629, 40.14351], [-124.00437, 40.14229], [-124.00454, 40.14135], [-124.00532, 40.14173], [-124.00725, 40.1433]]]]} Open Access 1 23082 Sinkyone Wilderness State Park 1747 204 California Department of Parks and Recreation 48 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/?page_id=429 Humboldt 45 138.709 Sinkyone Wilderness SP 1975 State Wilderness 209 2

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);