units_with_maps

Table actions

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

2 rows where ACCESS_TYP = 1, COUNTY = 19 and DES_TP = 8

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP

ACCESS_TYP 1

  • Open Access · 2 ✖
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
15557 15557 15556 {"type": "MultiPolygon", "coordinates": [[[[-121.42502, 37.04646], [-121.41822, 37.05058], [-121.41609, 37.05063], [-121.41615, 37.05185], [-121.40969, 37.05176], [-121.40962, 37.05477], [-121.40454, 37.05794], [-121.40327, 37.05796], [-121.40331, 37.0588], [-121.40269, 37.05882], [-121.39201, 37.05815], [-121.38528, 37.05828], [-121.37624, 37.05776], [-121.37597, 37.05067], [-121.367, 37.05022], [-121.36694, 37.04679], [-121.36411, 37.04661], [-121.36429, 37.05471], [-121.36382, 37.05474], [-121.3635, 37.05469], [-121.36324, 37.05458], [-121.36307, 37.05448], [-121.36274, 37.0542], [-121.3626, 37.05411], [-121.36242, 37.05405], [-121.36229, 37.05399], [-121.36223, 37.0539], [-121.36213, 37.05361], [-121.36202, 37.05352], [-121.36175, 37.05347], [-121.36156, 37.05341], [-121.36095, 37.05298], [-121.36075, 37.0528], [-121.36072, 37.05269], [-121.36072, 37.05249], [-121.3607, 37.05238], [-121.36053, 37.05228], [-121.36035, 37.05219], [-121.3602, 37.0521], [-121.35999, 37.05199], [-121.35978, 37.05194], [-121.35962, 37.05196], [-121.35917, 37.05219], [-121.35905, 37.05222], [-121.35878, 37.05222], [-121.35866, 37.05216], [-121.35855, 37.05201], [-121.35844, 37.05191], [-121.35833, 37.05185], [-121.35808, 37.05176], [-121.35788, 37.05175], [-121.35697, 37.05178], [-121.35581, 37.05178], [-121.35555, 37.05174], [-121.35544, 37.05168], [-121.35536, 37.05155], [-121.35525, 37.05151], [-121.35509, 37.05149], [-121.35481, 37.0515], [-121.35468, 37.05149], [-121.35425, 37.05134], [-121.35406, 37.05129], [-121.35387, 37.05126], [-121.35342, 37.05128], [-121.35321, 37.05125], [-121.35304, 37.05125], [-121.35275, 37.05133], [-121.3521, 37.0516], [-121.35196, 37.05164], [-121.3515, 37.05169], [-121.35113, 37.0516], [-121.35086, 37.0515], [-121.35056, 37.05142], [-121.35026, 37.05145], [-121.34996, 37.05154], [-121.34982, 37.05156], [-121.34965, 37.05154], [-121.34929, 37.05139], [-121.34913, 37.05137], [-121.34877, 37.05117], [-121.34864, 37.05112], [-121.34852, 37.0511], [-121.34825, 37.05109], [-121.34813, 37.05111], [-121.3477, 37.05128], [-121.34731, 37.05137], [-121.34691, 37.05142], [-121.34606, 37.05149], [-121.34604, 37.05023], [-121.32957, 37.05031], [-121.33085, 37.04625], [-121.33651, 37.02905], [-121.33662, 37.02903], [-121.33827, 37.02371], [-121.34022, 37.0239], [-121.35088, 37.02542], [-121.35101, 37.02998], [-121.35212, 37.03097], [-121.3523, 37.03188], [-121.35303, 37.03303], [-121.35334, 37.03426], [-121.35557, 37.03629], [-121.35847, 37.03391], [-121.36146, 37.0343], [-121.36309, 37.03399], [-121.3631, 37.03621], [-121.36402, 37.04303], [-121.37749, 37.04357], [-121.37955, 37.04217], [-121.38009, 37.04178], [-121.38075, 37.04154], [-121.38122, 37.04116], [-121.3819, 37.04043], [-121.38297, 37.04016], [-121.38367, 37.03954], [-121.38366, 37.0363], [-121.39177, 37.03632], [-121.3938, 37.03631], [-121.394, 37.03598], [-121.39463, 37.03564], [-121.39526, 37.03506], [-121.39602, 37.03502], [-121.39648, 37.03495], [-121.39709, 37.03525], [-121.39753, 37.03527], [-121.39793, 37.0349], [-121.39896, 37.03458], [-121.39951, 37.03458], [-121.40003, 37.03472], [-121.40067, 37.03467], [-121.40131, 37.03454], [-121.40427, 37.03508], [-121.40506, 37.03536], [-121.40557, 37.03567], [-121.40701, 37.0349], [-121.40769, 37.03476], [-121.40807, 37.03454], [-121.40852, 37.03441], [-121.40913, 37.03467], [-121.40939, 37.03462], [-121.40997, 37.0341], [-121.4101, 37.03389], [-121.41053, 37.03391], [-121.41123, 37.0342], [-121.41116, 37.0331], [-121.41192, 37.033], [-121.41215, 37.03267], [-121.42487, 37.0343], [-121.42446, 37.03451], [-121.42097, 37.03407], [-121.42099, 37.03551], [-121.42093, 37.03553], [-121.42104, 37.03879], [-121.42111, 37.0429], [-121.4207, 37.04324], [-121.42062, 37.04364], [-121.42095, 37.04403], [-121.42172, 37.0447], [-121.4229, 37.04543], [-121.42372, 37.0454], [-121.42502, 37.04646]]], [[[-121.38565, 37.08728], [-121.36412, 37.08649], [-121.36454, 37.05709], [-121.38534, 37.05845], [-121.38565, 37.08728]]]]} Open Access 1 1196 Canada de los Osos Ecological Reserve 32087 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 https://www.wildlife.ca.gov/Lands/Places-to-Visit/Canada-de-los-Osos-ER Santa Clara 19 5588.786 Canada de los Osos ER 2003 State Conservation Area 8 2
16761 16761 16760 {"type": "Polygon", "coordinates": [[[-121.24132, 37.09177], [-121.24123, 37.10182], [-121.22965, 37.10147], [-121.22963, 37.10146], [-121.22963, 37.10105], [-121.22954, 37.10087], [-121.22948, 37.10068], [-121.22949, 37.10049], [-121.22959, 37.10028], [-121.2296, 37.10008], [-121.22939, 37.09989], [-121.22908, 37.0995], [-121.22896, 37.09906], [-121.22909, 37.09889], [-121.2295, 37.09868], [-121.22958, 37.09854], [-121.22919, 37.09825], [-121.22902, 37.09803], [-121.22892, 37.09781], [-121.22882, 37.09725], [-121.22885, 37.09691], [-121.22901, 37.09659], [-121.22945, 37.09618], [-121.22977, 37.09584], [-121.22996, 37.09572], [-121.23033, 37.0957], [-121.23072, 37.09579], [-121.23098, 37.09594], [-121.2311, 37.0961], [-121.23128, 37.09619], [-121.23148, 37.09614], [-121.23171, 37.096], [-121.23201, 37.09573], [-121.23247, 37.09561], [-121.23312, 37.09534], [-121.23308, 37.09508], [-121.23313, 37.09482], [-121.23334, 37.09462], [-121.23362, 37.09447], [-121.23382, 37.09431], [-121.23411, 37.09388], [-121.23431, 37.09365], [-121.235, 37.09327], [-121.23518, 37.09311], [-121.23537, 37.09288], [-121.23562, 37.09279], [-121.23596, 37.09278], [-121.23662, 37.09286], [-121.23703, 37.09277], [-121.23733, 37.09266], [-121.2381, 37.09261], [-121.23838, 37.09245], [-121.23902, 37.09202], [-121.23957, 37.09157], [-121.23987, 37.09142], [-121.24025, 37.09147], [-121.2406, 37.09167], [-121.24082, 37.09177], [-121.24111, 37.09181], [-121.24132, 37.09177]]]} Open Access 1 25254 Cottonwood Creek Wildlife Area 30429 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 https://www.wildlife.ca.gov/Lands/Places-to-Visit/Cottonwood-Creek-WA Santa Clara 19 232.992 Cottonwood Creek Wildlife Area 1978 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]);