units_with_maps

Table actions

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

1 row where COUNTY = 23, DES_TP = 55 and MNG_AGENCY = 73

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • California State Lands Commission · 1 ✖

DES_TP 1

  • State Resource Management Area · 1 ✖

ACCESS_TYP 1

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