units_with_maps

Table actions

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

3 rows where ACCESS_TYP = 2, COUNTY = 15 and MNG_AGENCY = 25

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_ID, AGNCY_NAME, LAYER

MNG_AG_TYP 1

MNG_AGENCY 1

  • California Department of Fish and Wildlife · 3 ✖

ACCESS_TYP 1

  • Restricted Access · 3 ✖
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
4070 4070 4069 {"type": "Polygon", "coordinates": [[[-122.26206, 37.57356], [-122.25329, 37.58145], [-122.25329, 37.58145], [-122.25315, 37.58126], [-122.26174, 37.57345], [-122.26206, 37.57356]]]} Restricted Access 2 44448 San Mateo Fishing Pier 24951 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   San Mateo 15 7.589 San Mateo Fishing Pier 0 State Recreation Area 39 4
15625 15625 15624 {"type": "MultiPolygon", "coordinates": [[[[-122.24865, 37.51867], [-122.24743, 37.51868], [-122.24741, 37.51813], [-122.24748, 37.51813], [-122.24749, 37.51816], [-122.24862, 37.51816], [-122.24865, 37.51867]]], [[[-122.25031, 37.52028], [-122.25023, 37.52041], [-122.24962, 37.5202], [-122.24918, 37.52094], [-122.24828, 37.52218], [-122.2483, 37.52221], [-122.24792, 37.52383], [-122.24781, 37.52382], [-122.2478, 37.52386], [-122.24781, 37.5241], [-122.24786, 37.52424], [-122.24796, 37.52444], [-122.24799, 37.52472], [-122.24791, 37.52535], [-122.24786, 37.52542], [-122.24778, 37.52547], [-122.24723, 37.52548], [-122.24707, 37.52552], [-122.24692, 37.52562], [-122.24685, 37.52574], [-122.2467, 37.52589], [-122.24634, 37.52667], [-122.245, 37.52927], [-122.24342, 37.53062], [-122.24231, 37.53147], [-122.24153, 37.53184], [-122.24148, 37.53156], [-122.24182, 37.53144], [-122.24329, 37.5305], [-122.24468, 37.52927], [-122.245, 37.52866], [-122.24525, 37.52848], [-122.24547, 37.52798], [-122.24599, 37.52722], [-122.24624, 37.52667], [-122.24633, 37.52654], [-122.24643, 37.52628], [-122.24654, 37.52603], [-122.24661, 37.52577], [-122.24721, 37.52417], [-122.24776, 37.52234], [-122.24798, 37.52223], [-122.24811, 37.52205], [-122.24773, 37.52171], [-122.24828, 37.51948], [-122.24999, 37.51947], [-122.25, 37.52016], [-122.25031, 37.52028]]], [[[-122.26048, 37.53983], [-122.25986, 37.54047], [-122.25946, 37.54084], [-122.25913, 37.54101], [-122.25855, 37.5412], [-122.25804, 37.54119], [-122.25772, 37.54131], [-122.25724, 37.54136], [-122.25559, 37.54134], [-122.25503, 37.54121], [-122.25145, 37.54121], [-122.25134, 37.54061], [-122.25128, 37.54022], [-122.25111, 37.53887], [-122.25235, 37.53852], [-122.25331, 37.5382], [-122.25366, 37.53831], [-122.25397, 37.53888], [-122.25428, 37.53932], [-122.25501, 37.53978], [-122.25625, 37.54008], [-122.2566, 37.54011], [-122.25696, 37.54005], [-122.25758, 37.53973], [-122.25905, 37.53885], [-122.25959, 37.53581], [-122.25953, 37.53523], [-122.25952, 37.53411], [-122.26037, 37.53411], [-122.26039, 37.53561], [-122.26051, 37.53857], [-122.26048, 37.53983]]], [[[-122.25028, 37.5486], [-122.24616, 37.55153], [-122.24454, 37.55092], [-122.2445, 37.55056], [-122.23268, 37.5485], [-122.22913, 37.54832], [-122.22573, 37.54575], [-122.22551, 37.54456], [-122.22647, 37.54375], [-122.22746, 37.54312], [-122.228, 37.54251], [-122.22814, 37.54218], [-122.2287, 37.54152], [-122.22976, 37.53961], [-122.23149, 37.53647], [-122.23186, 37.53603], [-122.23309, 37.53486], [-122.2344, 37.53393], [-122.23498, 37.53394], [-122.23331, 37.53504], [-122.23279, 37.53595], [-122.23386, 37.53877], [-122.23243, 37.5399], [-122.23463, 37.54114], [-122.23471, 37.54139], [-122.23202, 37.54174], [-122.23135, 37.54208], [-122.22994, 37.54172], [-122.22602, 37.54478], [-122.22612, 37.54565], [-122.22864, 37.54754], [-122.22881, 37.54742], [-122.2294, 37.54785], [-122.22964, 37.54796], [-122.2339, 37.54828], [-122.23459, 37.54768], [-122.23539, 37.54826], [-122.23601, 37.54817], [-122.24311, 37.54898], [-122.2432, 37.54887], [-122.24423, 37.54895], [-122.24467, 37.54932], [-122.24458, 37.54992], [-122.24415, 37.54987], [-122.24432, 37.55035], [-122.24487, 37.55048], [-122.24483, 37.54996], [-122.24511, 37.54992], [-122.24523, 37.55013], [-122.24553, 37.54982], [-122.24629, 37.54998], [-122.24731, 37.54929], [-122.2456, 37.54832], [-122.24616, 37.54769], [-122.24856, 37.54904], [-122.2492, 37.54861], [-122.24947, 37.5484], [-122.24989, 37.54788], [-122.25022, 37.54713], [-122.25046, 37.54651], [-122.2505, 37.54636], [-122.25049, 37.54618], [-122.2501, 37.54469], [-122.24881, 37.54254], [-122.24985, 37.54224], [-122.25108, 37.54487], [-122.25117, 37.54517], [-122.25127, 37.5459], [-122.25116, 37.54638], [-122.25055, 37.54751], [-122.25015, 37.5481], [-122.24992, 37.54835], [-122.2496, 37.5486], [-122.25028, 37.5486]]], [[[-122.25278, 37.54858], [-122.25136, 37.55035], [-122.25103, 37.55059], [-122.24968, 37.55201], [-122.24686, 37.55341], [-122.24684, 37.55426], [-122.24657, 37.55451], [-122.24683, 37.55476], [-122.24681, 37.55559], [-122.24618, 37.55477], [-122.24514, 37.55598], [-122.24549, 37.55472], [-122.24616, 37.55371], [-122.24753, 37.55203], [-122.25081, 37.54981], [-122.25228, 37.54852], [-122.25251, 37.54853], [-122.25248, 37.54857], [-122.25249, 37.54858], [-122.25278, 37.54858]]]]} Restricted Access 2 24423 Redwood Shores Ecological Reserve 24252 209 California State Lands Commission 75 State 5 State Agency 5 http://www.slc.ca.gov/ Other State 5 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/Lands/Places-to-Visit/Redwood-Shores-ER San Mateo 15 218.064 Redwood Shores ER 1976 State Conservation Area 8 2
15629 15629 15628 {"type": "Polygon", "coordinates": [[[-122.22785, 37.5376], [-122.22781, 37.53769], [-122.22737, 37.53832], [-122.22719, 37.53867], [-122.22695, 37.53952], [-122.22669, 37.53983], [-122.22637, 37.54034], [-122.22594, 37.54065], [-122.22587, 37.54083], [-122.22572, 37.54099], [-122.22529, 37.54163], [-122.22499, 37.54186], [-122.22456, 37.54246], [-122.22451, 37.54248], [-122.22432, 37.54214], [-122.22343, 37.54263], [-122.21888, 37.5422], [-122.21566, 37.54246], [-122.21353, 37.542], [-122.20784, 37.54198], [-122.20636, 37.54134], [-122.20455, 37.54011], [-122.20733, 37.5374], [-122.20733, 37.53739], [-122.19806, 37.53143], [-122.20588, 37.52401], [-122.20775, 37.52464], [-122.20924, 37.52534], [-122.21153, 37.52598], [-122.2154, 37.52634], [-122.21659, 37.52578], [-122.21686, 37.52402], [-122.21759, 37.52322], [-122.2194, 37.52263], [-122.21975, 37.52171], [-122.21809, 37.51903], [-122.21877, 37.51801], [-122.22009, 37.51773], [-122.22005, 37.51792], [-122.22062, 37.51804], [-122.22148, 37.52435], [-122.21606, 37.52774], [-122.21381, 37.52792], [-122.21288, 37.52874], [-122.22785, 37.5376]]]} Restricted Access 2 29105 Bair Island Ecological Reserve 15765 209 California State Lands Commission 75 State 5 State Agency 5 http://www.slc.ca.gov/ Other State 5 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/Lands/Places-to-Visit/Bair-Island-ER San Mateo 15 787.45 Bair Island ER 1986 State Conservation Area 8 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]);