units_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, DES_TP = 15, MNG_AGENCY = 47 and UNIT_NAME = "Limekiln State Park"

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP

ACCESS_TYP 1

  • Open Access · 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
16576 16576 16575 {"type": "Polygon", "coordinates": [[[-121.53008, 36.01425], [-121.53002, 36.02521], [-121.52771, 36.02523], [-121.52771, 36.03951], [-121.52554, 36.03954], [-121.52552, 36.03952], [-121.5207, 36.03961], [-121.52077, 36.02532], [-121.52555, 36.02524], [-121.52557, 36.02161], [-121.51351, 36.0218], [-121.5136, 36.00743], [-121.51371, 36.00747], [-121.51388, 36.00747], [-121.51392, 36.00733], [-121.51409, 36.0073], [-121.51411, 36.00744], [-121.51416, 36.00751], [-121.51434, 36.00759], [-121.51452, 36.00761], [-121.51471, 36.00756], [-121.51489, 36.00755], [-121.51525, 36.00758], [-121.51561, 36.00767], [-121.5158, 36.0077], [-121.516, 36.00779], [-121.51617, 36.00785], [-121.51634, 36.00778], [-121.51651, 36.00777], [-121.51654, 36.00791], [-121.51671, 36.00798], [-121.51707, 36.00806], [-121.51742, 36.00808], [-121.5178, 36.00813], [-121.51816, 36.00813], [-121.51835, 36.00805], [-121.51889, 36.00796], [-121.51907, 36.00791], [-121.5191, 36.00776], [-121.51909, 36.00762], [-121.51926, 36.00749], [-121.51943, 36.00745], [-121.51945, 36.00732], [-121.51962, 36.00742], [-121.51979, 36.0073], [-121.51997, 36.00738], [-121.51996, 36.00752], [-121.51983, 36.00766], [-121.51965, 36.00763], [-121.51956, 36.00776], [-121.51973, 36.00786], [-121.51986, 36.008], [-121.5198, 36.00814], [-121.51963, 36.00826], [-121.5196, 36.0084], [-121.51962, 36.00854], [-121.51999, 36.00896], [-121.52031, 36.00915], [-121.51964, 36.00902], [-121.51958, 36.00908], [-121.51867, 36.00861], [-121.51845, 36.00834], [-121.51799, 36.00827], [-121.51763, 36.00826], [-121.51692, 36.00819], [-121.51652, 36.00811], [-121.51574, 36.00788], [-121.51563, 36.0081], [-121.5163, 36.00831], [-121.51666, 36.0084], [-121.51733, 36.00849], [-121.51769, 36.00856], [-121.5179, 36.00863], [-121.5183, 36.00881], [-121.51934, 36.00938], [-121.51982, 36.0096], [-121.52028, 36.00973], [-121.52088, 36.00983], [-121.52172, 36.00985], [-121.52173, 36.01007], [-121.52326, 36.01053], [-121.52388, 36.01136], [-121.52477, 36.01164], [-121.52484, 36.01097], [-121.52491, 36.01094], [-121.52464, 36.01052], [-121.52434, 36.01019], [-121.5241, 36.01001], [-121.52394, 36.00991], [-121.52358, 36.00976], [-121.52349, 36.00981], [-121.52243, 36.00983], [-121.52242, 36.0096], [-121.52131, 36.0096], [-121.52111, 36.00959], [-121.52062, 36.00951], [-121.52069, 36.00935], [-121.52089, 36.00943], [-121.52126, 36.00945], [-121.52162, 36.00944], [-121.5218, 36.00933], [-121.52203, 36.00933], [-121.5222, 36.00944], [-121.52238, 36.00939], [-121.52256, 36.00947], [-121.52273, 36.00948], [-121.52291, 36.00962], [-121.52309, 36.00963], [-121.52328, 36.00962], [-121.52345, 36.00955], [-121.52363, 36.0096], [-121.524, 36.00974], [-121.52418, 36.00977], [-121.52456, 36.00977], [-121.52472, 36.00991], [-121.52474, 36.01006], [-121.52483, 36.0102], [-121.52496, 36.01034], [-121.52512, 36.01048], [-121.52523, 36.01061], [-121.52527, 36.01075], [-121.52534, 36.01089], [-121.52563, 36.01117], [-121.52562, 36.01432], [-121.53008, 36.01425]]]} Open Access 1 17355 Limekiln State Park 1606 204 California Department of Parks and Recreation 48 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/default.asp?page_id=577 Monterey 14 742.924 Limekiln SP 1994 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]);