units_with_maps

Table actions

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

3 rows where COUNTY = 23, DES_TP = 55 and MNG_AG_TYP = 5

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_ID, LAYER, MNG_AG_ID

ACCESS_TYP 2

MNG_AG_TYP 1

  • State Agency · 3 ✖

DES_TP 1

  • State Resource Management Area · 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
6173 6173 6172 {"type": "Polygon", "coordinates": [[[-122.64262, 37.8994], [-122.64213, 37.8998], [-122.64167, 37.8996], [-122.64213, 37.89912], [-122.64242, 37.8992], [-122.64262, 37.8994]]]} No Public Access 3 1204 Stinson Beach 32319 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   Marin 23 0.833 Stinson Beach 0 State Resource Management Area 55 3
13181 13181 13180 {"type": "Polygon", "coordinates": [[[-122.92622, 38.21025], [-122.92607, 38.2121], [-122.9261, 38.21451], [-122.92537, 38.21453], [-122.92543, 38.21398], [-122.9252, 38.21396], [-122.92534, 38.21304], [-122.92489, 38.21275], [-122.92481, 38.21267], [-122.92468, 38.21246], [-122.92464, 38.21237], [-122.92459, 38.21217], [-122.92434, 38.21196], [-122.92414, 38.21165], [-122.92392, 38.21134], [-122.92379, 38.21121], [-122.92373, 38.21108], [-122.92373, 38.21095], [-122.92376, 38.21086], [-122.92383, 38.21078], [-122.92388, 38.21074], [-122.924, 38.21071], [-122.92413, 38.2107], [-122.92483, 38.21075], [-122.92503, 38.21072], [-122.92521, 38.21068], [-122.92534, 38.21057], [-122.9254, 38.2105], [-122.92561, 38.21012], [-122.92562, 38.21043], [-122.92581, 38.21043], [-122.92581, 38.21025], [-122.92622, 38.21025]]]} No Public Access 3 35164 Walker Creek Marsh 32346 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   Marin 23 13.468 Walker Creek Marsh 0 State Resource Management Area 55 3
16866 16866 16865 {"type": "Polygon", "coordinates": [[[-122.52722, 38.07777], [-122.52681, 38.07802], [-122.52681, 38.07788], [-122.52643, 38.07731], [-122.52588, 38.07617], [-122.52516, 38.07557], [-122.52516, 38.07509], [-122.52528, 38.07479], [-122.52522, 38.07418], [-122.52473, 38.07379], [-122.52465, 38.07377], [-122.52426, 38.07651], [-122.52478, 38.07692], [-122.52507, 38.07733], [-122.52545, 38.07827], [-122.52582, 38.07857], [-122.5259, 38.07858], [-122.52508, 38.07909], [-122.52375, 38.07758], [-122.52247, 38.07828], [-122.52126, 38.07679], [-122.51758, 38.07557], [-122.51648, 38.07455], [-122.51254, 38.07697], [-122.51172, 38.07825], [-122.51108, 38.07816], [-122.51163, 38.07682], [-122.51123, 38.07673], [-122.51065, 38.0781], [-122.50787, 38.07772], [-122.50332, 38.07979], [-122.50464, 38.08168], [-122.50559, 38.08295], [-122.50624, 38.08358], [-122.50719, 38.08308], [-122.50738, 38.08351], [-122.50698, 38.08347], [-122.50668, 38.08351], [-122.50592, 38.08414], [-122.50458, 38.08474], [-122.5032, 38.08556], [-122.50248, 38.08605], [-122.50103, 38.08767], [-122.50105, 38.08943], [-122.49874, 38.09112], [-122.49876, 38.08983], [-122.49875, 38.08982], [-122.49633, 38.09096], [-122.49507, 38.09141], [-122.49145, 38.09264], [-122.49026, 38.09289], [-122.49043, 38.09258], [-122.49008, 38.0926], [-122.48996, 38.09247], [-122.48789, 38.08823], [-122.48488, 38.07829], [-122.48468, 38.07238], [-122.48483, 38.07166], [-122.48518, 38.07111], [-122.48553, 38.07074], [-122.49222, 38.05907], [-122.51103, 38.06344], [-122.52117, 38.07149], [-122.5218, 38.07101], [-122.52237, 38.07141], [-122.5231, 38.07182], [-122.5243, 38.07214], [-122.52574, 38.07374], [-122.52596, 38.07439], [-122.52563, 38.07464], [-122.52722, 38.07777]], [[-122.50282, 38.08438], [-122.50494, 38.0833], [-122.50477, 38.08284], [-122.50428, 38.08204], [-122.50338, 38.08236], [-122.50164, 38.08318], [-122.50167, 38.08357], [-122.5019, 38.08401], [-122.50242, 38.08446], [-122.50282, 38.08438]], [[-122.50607, 38.07779], [-122.50615, 38.07764], [-122.50263, 38.07687], [-122.50246, 38.07689], [-122.50208, 38.07744], [-122.50211, 38.07872], [-122.50226, 38.07899], [-122.50376, 38.07881], [-122.50607, 38.07779]]]} Open Access 1 1153 California State Lands Commission 16724 209 California State Lands Commission 75 State 5 State Agency 5 http://www.slc.ca.gov/ Other State 5 209 California State Lands Commission 73 State 5 State Agency 5   Marin 23 1758.222 SLC 0 State Resource Management Area 55 3

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