units_with_maps

Table actions

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

2 rows where ACCESS_TYP = 1, LABEL_NAME = "San Pablo Bay Wildlife Area" and MNG_AG_TYP = 5

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
12263 12263 12262 {"type": "MultiPolygon", "coordinates": [[[[-122.48403, 38.02932], [-122.47943, 38.02936], [-122.47926, 38.02067], [-122.48, 38.02023], [-122.48381, 38.01988], [-122.48386, 38.02218], [-122.4816, 38.02221], [-122.48167, 38.02576], [-122.48395, 38.02574], [-122.48403, 38.02932]]], [[[-122.50651, 38.0291], [-122.50428, 38.02978], [-122.50209, 38.03039], [-122.49987, 38.03098], [-122.49983, 38.02917], [-122.49837, 38.02918], [-122.49836, 38.02906], [-122.49754, 38.02901], [-122.49732, 38.02209], [-122.49505, 38.02211], [-122.49495, 38.01885], [-122.4971, 38.01865], [-122.5039, 38.01851], [-122.50399, 38.02218], [-122.5018, 38.02222], [-122.50206, 38.02914], [-122.50422, 38.02912], [-122.50412, 38.02579], [-122.50641, 38.02575], [-122.50651, 38.0291]]]]} Open Access 1 25815 San Pablo Bay Wildlife Area 30326 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/San-Pablo-Bay-WA Marin 23 267.777 San Pablo Bay Wildlife Area 1976 State Conservation Area 8 2
16756 16756 16755 {"type": "Polygon", "coordinates": [[[-122.49893, 38.04859], [-122.49841, 38.04941], [-122.49778, 38.04889], [-122.49658, 38.04975], [-122.49721, 38.05036], [-122.48553, 38.07074], [-122.48518, 38.07111], [-122.48483, 38.07166], [-122.48468, 38.07238], [-122.48488, 38.07829], [-122.48789, 38.08823], [-122.48996, 38.09247], [-122.4902, 38.09275], [-122.47981, 38.11092], [-122.47159, 38.11035], [-122.46548, 38.10987], [-122.46207, 38.1084], [-122.45449, 38.10507], [-122.44863, 38.09749], [-122.42746, 38.07117], [-122.43265, 38.04458], [-122.45798, 38.00926], [-122.4593, 38.03162], [-122.46381, 38.03239], [-122.46445, 38.03433], [-122.47026, 38.03457], [-122.47257, 38.03457], [-122.4749, 38.03454], [-122.47724, 38.03443], [-122.47952, 38.03427], [-122.47949, 38.03299], [-122.47025, 38.0331], [-122.47016, 38.02465], [-122.47925, 38.02057], [-122.4795, 38.03299], [-122.4864, 38.03291], [-122.4863, 38.0293], [-122.48403, 38.02932], [-122.48394, 38.02574], [-122.48167, 38.02577], [-122.4816, 38.0222], [-122.48386, 38.02217], [-122.48381, 38.01988], [-122.48814, 38.01948], [-122.48839, 38.02928], [-122.49837, 38.02918], [-122.49838, 38.03137], [-122.49761, 38.0319], [-122.49751, 38.03199], [-122.49812, 38.0325], [-122.49803, 38.03255], [-122.4977, 38.033], [-122.49769, 38.0337], [-122.4976, 38.03382], [-122.49735, 38.03403], [-122.49731, 38.0362], [-122.49375, 38.04593], [-122.49355, 38.04614], [-122.49334, 38.04625], [-122.49311, 38.04632], [-122.49286, 38.04636], [-122.49278, 38.04645], [-122.49312, 38.04685], [-122.49301, 38.04738], [-122.49234, 38.04809], [-122.49893, 38.04859]]]} Open Access 1 46845 San Pablo Bay Wildlife Area 30326 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/San-Pablo-Bay-WA Marin 23 10545.279 San Pablo Bay Wildlife Area 1976 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]);