units_with_maps

Table actions

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

8 rows where AGNCY_LEV = 6 and MNG_AG_TYP = 5

This data as json, copyable, CSV (advanced)

Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_TYP, AGNCY_WEB, MNG_AG_ID, PARK_URL, COUNTY, LABEL_NAME, GAP_STS

MNG_AG_TYP 1

  • State Agency · 8 ✖
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
2398 2398 2397 {"type": "MultiPolygon", "coordinates": [[[[-117.21972, 33.42999], [-117.21971, 33.43008], [-117.21941, 33.43087], [-117.21888, 33.43101], [-117.21852, 33.43096], [-117.21805, 33.43108], [-117.21795, 33.43113], [-117.21774, 33.43153], [-117.21722, 33.43152], [-117.21407, 33.43154], [-117.21414, 33.42781], [-117.21857, 33.4278], [-117.21851, 33.42935], [-117.21925, 33.42978], [-117.21965, 33.42988], [-117.2197, 33.42993], [-117.21972, 33.42999]]], [[[-117.20291, 33.42795], [-117.20281, 33.43006], [-117.19914, 33.43009], [-117.199, 33.43159], [-117.19592, 33.4316], [-117.19604, 33.42917], [-117.19685, 33.429], [-117.19721, 33.42851], [-117.19932, 33.42801], [-117.20077, 33.42797], [-117.20291, 33.42795]]]]} Restricted Access 2 7255 Santa Margarita Ecological Reserve 33342 3065 San Diego State University Foundation 524 Non Profit 6 Non Profit - Other 22 http://www.foundation.sdsu.edu/index.html Non Governmental Organization 10 221 San Diego State University 378 State 5 State Agency 5 https://fsp.sdsu.edu/about-us/ San Diego 4 88.83 Santa Margarita ER 1962 State Conservation Area 8 2
5847 5847 5846 {"type": "MultiPolygon", "coordinates": [[[[-117.16733, 33.46176], [-117.16524, 33.46316], [-117.16477, 33.46349], [-117.16432, 33.46385], [-117.1639, 33.46423], [-117.16319, 33.46492], [-117.16317, 33.46482], [-117.16297, 33.46465], [-117.16293, 33.46136], [-117.1584, 33.46141], [-117.1583, 33.458], [-117.16286, 33.458], [-117.16294, 33.46135], [-117.16732, 33.46153], [-117.16733, 33.46176]]], [[[-117.17572, 33.43595], [-117.17572, 33.43673], [-117.17535, 33.43751], [-117.17514, 33.43806], [-117.17463, 33.43969], [-117.17358, 33.44319], [-117.1625, 33.4434], [-117.16239, 33.43974], [-117.17142, 33.43963], [-117.17137, 33.43602], [-117.17572, 33.43595]]], [[[-117.17577, 33.44315], [-117.17438, 33.44318], [-117.17551, 33.43984], [-117.17574, 33.43904], [-117.17577, 33.44315]]], [[[-117.1801, 33.45033], [-117.17584, 33.45044], [-117.1758, 33.44675], [-117.18006, 33.44666], [-117.1801, 33.45033]]], [[[-117.20651, 33.43216], [-117.20649, 33.43578], [-117.19766, 33.43577], [-117.1976, 33.43937], [-117.19315, 33.43935], [-117.1932, 33.43576], [-117.18876, 33.43575], [-117.18441, 33.43581], [-117.18444, 33.43223], [-117.18882, 33.43217], [-117.20651, 33.43216]]]]} Restricted Access 2 21992 Santa Margarita Ecological Reserve 33342 3065 San Diego State University Foundation 524 Non Profit 6 Non Profit - Other 22 http://www.foundation.sdsu.edu/index.html Non Governmental Organization 10 221 San Diego State University 378 State 5 State Agency 5 https://fsp.sdsu.edu/about-us/ Riverside 10 493.628 Santa Margarita ER 1962 State Conservation Area 8 2
6462 6462 6461 {"type": "Polygon", "coordinates": [[[-116.18721, 33.15378], [-116.18628, 33.1536], [-116.18497, 33.1533], [-116.18496, 33.15281], [-116.18721, 33.15378]]]} No Public Access 3 2055 Hwy 78 scenic corridor 20163 3004 Anza-Borrego Foundation 836 Non Profit 6 Non Profit - Land Trust 10 http://www.theabf.org/ Non Governmental Organization 10 204 California Department of Parks and Recreation 47 State 5 State Agency 5   San Diego 4 1.475 Hwy 78 scenic corridor   None 522  
6677 6677 6676 {"type": "Polygon", "coordinates": [[[-116.5326, 32.93414], [-116.53245, 32.94818], [-116.51564, 32.94847], [-116.51595, 32.93405], [-116.5326, 32.93414]]]} Restricted Access 2 47524 Anza-Borrego Desert State Park 31229 3004 Anza-Borrego Foundation 836 Non Profit 6 Non Profit - Land Trust 10 http://www.theabf.org/ Non Governmental Organization 10 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/?page_id=638 San Diego 4 609.836 Anza-Borrego Desert SP 1933 State Park 15 4
9930 9930 9929 {"type": "Polygon", "coordinates": [[[-121.84235, 38.25685], [-121.83602, 38.26394], [-121.83312, 38.26707], [-121.83311, 38.2711], [-121.82945, 38.27111], [-121.82645, 38.27432], [-121.82358, 38.27798], [-121.82356, 38.28536], [-121.82097, 38.28535], [-121.81442, 38.28518], [-121.81447, 38.28517], [-121.81448, 38.28333], [-121.81451, 38.28254], [-121.81452, 38.27627], [-121.80554, 38.27616], [-121.80553, 38.27613], [-121.8053, 38.27616], [-121.80552, 38.25635], [-121.82403, 38.25652], [-121.82404, 38.25691], [-121.84235, 38.25685]]]} Restricted Access 2 17078 Jepson Prairie Reserve 33186 3081 Solano Land Trust 361 Non Profit 6 Non Profit - Land Trust 10 http://www.solanolandtrust.org/ Non Governmental Organization 10 217 University of California 51 State 5 State Agency 5   Solano 26 1546.442 Jepson Prairie Reserve 0 State Conservation Area 8 2
10608 10608 10607 {"type": "Polygon", "coordinates": [[[-121.91003, 37.06168], [-121.90971, 37.06155], [-121.90985, 37.0612], [-121.9102, 37.06125], [-121.91025, 37.06129], [-121.91025, 37.06133], [-121.91003, 37.06168]]]} Open Access 1 48632 The Forest of Nisene Marks State Park 1767 3074 Save the Redwoods League 52 Non Profit 6 Non Profit - Land Trust 10 http://www.savetheredwoods.org Non Governmental Organization 10 204 California Department of Parks and Recreation 47 State 5 State Agency 5 https://www.parks.ca.gov/nisene Santa Cruz 5 0.399 The Forest of Nisene Marks SP 1963 State Park 15 4
15575 15575 15574 {"type": "Polygon", "coordinates": [[[-121.74412, 36.87571], [-121.74366, 36.87559], [-121.74329, 36.87545], [-121.74227, 36.87498], [-121.74082, 36.8726], [-121.74226, 36.87023], [-121.7427, 36.87029], [-121.74329, 36.87006], [-121.74404, 36.87042], [-121.74411, 36.87185], [-121.74417, 36.87201], [-121.74408, 36.87317], [-121.74393, 36.87357], [-121.74369, 36.87428], [-121.74359, 36.87435], [-121.74351, 36.87447], [-121.74349, 36.87456], [-121.7435, 36.87468], [-121.74363, 36.87499], [-121.74412, 36.87566], [-121.74412, 36.87571]]]} Restricted Access 2 44940 Elkhorn Slough Ecological Reserve 18581 3019 Elkhorn Slough Foundation 464 Non Profit 6 Non Profit - Land Trust 10 http://www.elkhornslough.org Non Governmental Organization 10 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/Lands/Places-to-Visit/Elkhorn-Slough-ER Monterey 14 29.594 Elkhorn Slough ER 1980 State Conservation Area 8 2
16535 16535 16534 {"type": "MultiPolygon", "coordinates": [[[[-116.51564, 32.94847], [-116.51556, 32.95249], [-116.51537, 32.96153], [-116.51211, 32.9485], [-116.51564, 32.94847]]], [[[-116.47966, 33.06811], [-116.47956, 33.07178], [-116.4753, 33.07165], [-116.47537, 33.068], [-116.47966, 33.06811]]], [[[-116.1889, 33.13293], [-116.18889, 33.13362], [-116.18786, 33.13326], [-116.18787, 33.13247], [-116.1889, 33.13293]]], [[[-116.24339, 33.13747], [-116.24338, 33.13872], [-116.24183, 33.1387], [-116.24183, 33.13748], [-116.24339, 33.13747]]], [[[-116.21568, 33.17044], [-116.21341, 33.17043], [-116.2134, 33.16964], [-116.21568, 33.16965], [-116.21568, 33.17044]]], [[[-116.21576, 33.17807], [-116.21353, 33.17802], [-116.21352, 33.1772], [-116.21576, 33.17722], [-116.21576, 33.17807]]], [[[-116.24659, 33.19801], [-116.2465, 33.20157], [-116.24226, 33.20159], [-116.24235, 33.19806], [-116.24659, 33.19801]]], [[[-116.34724, 33.20641], [-116.33846, 33.20628], [-116.3384, 33.20268], [-116.3472, 33.20289], [-116.34724, 33.20641]]], [[[-116.20487, 33.21517], [-116.20272, 33.21515], [-116.20271, 33.21338], [-116.20487, 33.21343], [-116.20487, 33.21517]]], [[[-116.19836, 33.21509], [-116.19617, 33.21507], [-116.19616, 33.21324], [-116.19834, 33.21329], [-116.19836, 33.21509]]], [[[-116.29962, 33.21697], [-116.29518, 33.21685], [-116.29515, 33.22059], [-116.29038, 33.22026], [-116.29042, 33.21662], [-116.29517, 33.21684], [-116.29519, 33.21322], [-116.28346, 33.21277], [-116.28352, 33.20914], [-116.28114, 33.20906], [-116.28122, 33.20539], [-116.29522, 33.20577], [-116.29519, 33.21321], [-116.29961, 33.21332], [-116.29962, 33.21697]]], [[[-116.19619, 33.21873], [-116.19399, 33.21871], [-116.19397, 33.21683], [-116.19618, 33.21686], [-116.19619, 33.21873]]], [[[-116.23753, 33.21238], [-116.23737, 33.22255], [-116.23303, 33.22256], [-116.23308, 33.21913], [-116.23324, 33.21229], [-116.23753, 33.21238]]], [[[-116.23193, 33.2243], [-116.2319, 33.22596], [-116.23085, 33.22597], [-116.23086, 33.22429], [-116.23193, 33.2243]]], [[[-116.31127, 33.22816], [-116.31122, 33.22998], [-116.30977, 33.22996], [-116.30979, 33.22815], [-116.31127, 33.22816]]], [[[-116.2565, 33.22961], [-116.25443, 33.22959], [-116.25438, 33.22596], [-116.25648, 33.22597], [-116.2565, 33.22961]]], [[[-116.25225, 33.22595], [-116.25225, 33.22957], [-116.25017, 33.22955], [-116.25012, 33.22594], [-116.25225, 33.22595]]], [[[-116.24166, 33.23307], [-116.233, 33.2331], [-116.23298, 33.22595], [-116.24161, 33.22589], [-116.24166, 33.23307]]], [[[-116.40042, 33.24188], [-116.39332, 33.24195], [-116.39331, 33.24032], [-116.39103, 33.24032], [-116.39102, 33.24197], [-116.38787, 33.242], [-116.38705, 33.24108], [-116.38765, 33.24011], [-116.38895, 33.24148], [-116.38951, 33.24055], [-116.38932, 33.24006], [-116.38854, 33.23992], [-116.38827, 33.23946], [-116.38721, 33.23857], [-116.38945, 33.23671], [-116.39325, 33.23922], [-116.39376, 33.23914], [-116.39465, 33.23925], [-116.39613, 33.23969], [-116.39749, 33.2398], [-116.39783, 33.23994], [-116.39799, 33.2399], [-116.40037, 33.23984], [-116.40042, 33.24188]]], [[[-116.25889, 33.24051], [-116.25028, 33.24037], [-116.25025, 33.23676], [-116.25881, 33.23689], [-116.25889, 33.24051]]], [[[-116.22593, 33.25372], [-116.22155, 33.25377], [-116.22164, 33.25548], [-116.21938, 33.25549], [-116.21926, 33.25378], [-116.20824, 33.25388], [-116.19056, 33.25407], [-116.19038, 33.24688], [-116.19492, 33.24708], [-116.19493, 33.24707], [-116.19483, 33.24532], [-116.19033, 33.24517], [-116.19031, 33.24428], [-116.1948, 33.24444], [-116.19484, 33.24532], [-116.19703, 33.2454], [-116.19704, 33.24539], [-116.19693, 33.24364], [-116.19476, 33.24356], [-116.19467, 33.24183], [-116.19025, 33.24172], [-116.1902, 33.23988], [-116.19359, 33.23998], [-116.19363, 33.24087], [-116.19462, 33.24088], [-116.19463, 33.24087], [-116.1946, 33.24001], [-116.20745, 33.2404], [-116.22477, 33.24033], [-116.22489, 33.24771], [-116.22593, 33.25372]]], [[[-116.21075, 33.25912], [-116.20856, 33.25914], [-116.20846, 33.2574], [-116.21065, 33.25737], [-116.21075, 33.25912]]], [[[-116.24637, 33.26437], [-116.24424, 33.26421], [-116.24413, 33.26246], [-116.24627, 33.26256], [-116.24637, 33.26437]]], [[[-116.22215, 33.26436], [-116.21993, 33.26438], [-116.21984, 33.26259], [-116.22206, 33.26257], [-116.22215, 33.26436]]], [[[-116.26234, 33.28414], [-116.26092, 33.28411], [-116.26078, 33.2825], [-116.2622, 33.28247], [-116.26234, 33.28414]]], [[[-116.28037, 33.28965], [-116.27194, 33.28958], [-116.27168, 33.28611], [-116.28005, 33.2862], [-116.28037, 33.28965]]], [[[-116.25053, 33.30372], [-116.25045, 33.31027], [-116.2463, 33.31028], [-116.23785, 33.31036], [-116.23767, 33.30342], [-116.24107, 33.30352], [-116.24216, 33.30359], [-116.24576, 33.30372], [-116.24711, 33.30373], [-116.25053, 33.30372]]], [[[-116.25916, 33.32112], [-116.25914, 33.32481], [-116.25483, 33.32485], [-116.25483, 33.32112], [-116.25916, 33.32112]]]]} Open Access 1 47509 Anza-Borrego Desert State Park 1413 3004 Anza-Borrego Foundation 836 Non Profit 6 Non Profit - Land Trust 10 http://www.theabf.org/ Non Governmental Organization 10 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/?page_id=638 San Diego 4 2607.419 Anza-Borrego Desert SP 1933 State Park 15 4

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