units_with_maps

Table actions

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

3 rows where AGNCY_WEB = "http://www.theabf.org/", COUNTY = 4, MNG_AGENCY = 47 and MNG_AG_TYP = 5

This data as json, copyable, CSV (advanced)

Suggested facets: UNIT_NAME, LABEL_NAME

DES_TP 2

MNG_AG_TYP 1

  • State Agency · 3 ✖

MNG_AGENCY 1

  • California Department of Parks and Recreation · 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
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
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]);