units_with_maps

Table actions

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

5 rows where COUNTY = 9 and DES_TP = 55

This data as json, copyable, CSV (advanced)

Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_WEB, LAYER, MNG_AG_ID, LABEL_NAME

ACCESS_TYP 2

MNG_AG_TYP 1

DES_TP 1

  • State Resource Management Area · 5 ✖
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
1362 1362 1361 {"type": "MultiPolygon", "coordinates": [[[[-120.54592, 36.6911], [-120.53904, 36.69108], [-120.53903, 36.68751], [-120.53931, 36.68748], [-120.53932, 36.67661], [-120.53965, 36.67662], [-120.54592, 36.6911]]], [[[-120.54644, 36.69054], [-120.54632, 36.69071], [-120.54625, 36.69074], [-120.54003, 36.67662], [-120.54028, 36.67664], [-120.54644, 36.69054]]]]} No Public Access 3 8074 Pilobos 32263 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 201 California Department of Fish and Wildlife 25 State 5 State Agency 5   Fresno 9 134.36 Pilobos 0 State Resource Management Area 55 3
7132 7132 7131 {"type": "MultiPolygon", "coordinates": [[[[-119.41323, 36.78389], [-119.41298, 36.78429], [-119.41297, 36.78478], [-119.41308, 36.78757], [-119.41299, 36.78847], [-119.41167, 36.78916], [-119.4116, 36.78454], [-119.40887, 36.78451], [-119.40928, 36.78346], [-119.41097, 36.78354], [-119.411, 36.7831], [-119.41, 36.78308], [-119.41079, 36.78223], [-119.41154, 36.78298], [-119.41323, 36.78389]]], [[[-119.41291, 36.78956], [-119.41289, 36.7902], [-119.41169, 36.79021], [-119.41169, 36.79009], [-119.41163, 36.79008], [-119.41163, 36.78953], [-119.41265, 36.78953], [-119.41266, 36.78957], [-119.41291, 36.78956]]]]} Open Access 1 6750 Avocado Lake 32030 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 201 California Department of Fish and Wildlife 25 State 5 State Agency 5   Fresno 9 29.362 Avocado Lake 0 State Resource Management Area 55 3
10097 10097 10096 {"type": "MultiPolygon", "coordinates": [[[[-120.38851, 36.07903], [-120.38402, 36.07898], [-120.38402, 36.07506], [-120.38845, 36.07502], [-120.38851, 36.07903]]], [[[-120.58648, 36.28432], [-120.56898, 36.28448], [-120.56891, 36.27347], [-120.57736, 36.27346], [-120.57738, 36.27704], [-120.58181, 36.27708], [-120.58182, 36.26987], [-120.58634, 36.26983], [-120.58625, 36.27704], [-120.58648, 36.28432]]], [[[-120.6209, 36.31956], [-120.62001, 36.31988], [-120.61962, 36.31972], [-120.61915, 36.31943], [-120.619, 36.31927], [-120.61892, 36.31921], [-120.61858, 36.31915], [-120.61844, 36.31908], [-120.61826, 36.31897], [-120.61801, 36.31877], [-120.61788, 36.31886], [-120.6177, 36.31914], [-120.61751, 36.31933], [-120.6173, 36.31945], [-120.61713, 36.3195], [-120.61694, 36.31946], [-120.61638, 36.3195], [-120.61612, 36.31957], [-120.61591, 36.31965], [-120.61558, 36.31993], [-120.61533, 36.32007], [-120.61508, 36.32025], [-120.6149, 36.32029], [-120.61468, 36.32026], [-120.61445, 36.32021], [-120.61406, 36.32021], [-120.61354, 36.32026], [-120.61338, 36.32031], [-120.61326, 36.32052], [-120.6131, 36.32067], [-120.61297, 36.32075], [-120.61283, 36.32087], [-120.61252, 36.32107], [-120.61216, 36.32146], [-120.61215, 36.32158], [-120.61226, 36.32178], [-120.6125, 36.32199], [-120.61255, 36.32226], [-120.61265, 36.32263], [-120.61277, 36.32284], [-120.61288, 36.32297], [-120.61297, 36.3233], [-120.61303, 36.32359], [-120.61295, 36.3239], [-120.61272, 36.32415], [-120.61251, 36.32431], [-120.6118, 36.32462], [-120.61154, 36.32465], [-120.61134, 36.32462], [-120.61079, 36.32436], [-120.61013, 36.32425], [-120.60988, 36.32425], [-120.60926, 36.32432], [-120.609, 36.32433], [-120.60875, 36.3243], [-120.60844, 36.32432], [-120.60822, 36.32437], [-120.60805, 36.32437], [-120.60753, 36.32427], [-120.60703, 36.3242], [-120.6068, 36.32419], [-120.60648, 36.32424], [-120.60597, 36.32425], [-120.60558, 36.32429], [-120.60535, 36.32425], [-120.60516, 36.32415], [-120.605, 36.32415], [-120.60461, 36.32434], [-120.6044, 36.32455], [-120.60423, 36.32467], [-120.60403, 36.32474], [-120.60394, 36.32491], [-120.6039, 36.32523], [-120.60382, 36.32541], [-120.60365, 36.32549], [-120.60346, 36.32547], [-120.60308, 36.3255], [-120.60257, 36.3255], [-120.60229, 36.32564], [-120.60214, 36.32573], [-120.60196, 36.32626], [-120.59657, 36.32616], [-120.59655, 36.32505], [-120.59647, 36.32298], [-120.59616, 36.31099], [-120.60401, 36.31092], [-120.61261, 36.31081], [-120.61716, 36.31079], [-120.62084, 36.31061], [-120.6209, 36.31956]]]]} Open Access 1 17485 California State Lands Commission 16724 209 California State Lands Commission 75 State 5 State Agency 5 http://www.slc.ca.gov/ Other State 5 209 California State Lands Commission 73 State 5 State Agency 5   Fresno 9 1266.224 SLC 0 State Resource Management Area 55 3
12983 12983 12982 {"type": "Polygon", "coordinates": [[[-119.01902, 36.735], [-119.019, 36.73858], [-119.01004, 36.73851], [-119.01008, 36.73493], [-119.01902, 36.735]]]} Open Access 1 44769 California State Lands Commission 16724 209 California State Lands Commission 75 State 5 State Agency 5 http://www.slc.ca.gov/ Other State 5 209 California State Lands Commission 73 State 5 State Agency 5   Fresno 9 78.552 SLC 0 State Resource Management Area 55 3
16357 16357 16356 {"type": "MultiPolygon", "coordinates": [[[[-119.40892, 37.09687], [-119.40888, 37.10414], [-119.40433, 37.10414], [-119.40438, 37.09688], [-119.40892, 37.09687]]], [[[-119.41801, 37.10775], [-119.41344, 37.10776], [-119.41343, 37.11139], [-119.40885, 37.1114], [-119.40887, 37.10777], [-119.41344, 37.10776], [-119.41346, 37.09687], [-119.418, 37.09686], [-119.41801, 37.10775]]]]} Open Access 1 44763 California State Lands Commission 16724 209 California State Lands Commission 75 State 5 State Agency 5 http://www.slc.ca.gov/ Other State 5 209 California State Lands Commission 73 State 5 State Agency 5   Fresno 9 242.067 SLC 0 State Resource Management Area 55 3

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