units_with_maps

Table actions

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

1 row where COUNTY = 1, DES_TP = 15 and YR_EST = 2003

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

DES_TP 1

  • State Park · 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
16527 16527 16526 {"type": "Polygon", "coordinates": [[[-121.02028, 35.47854], [-121.01593, 35.47853], [-121.01589, 35.48252], [-120.998, 35.48234], [-120.99799, 35.48235], [-120.99816, 35.4829], [-120.99834, 35.48332], [-120.99801, 35.48376], [-120.99811, 35.48438], [-120.99742, 35.48323], [-120.997, 35.48245], [-120.99622, 35.48139], [-120.99538, 35.48054], [-120.99433, 35.47971], [-120.99213, 35.47823], [-120.99224, 35.47786], [-120.99196, 35.47768], [-120.99135, 35.47686], [-120.99132, 35.47665], [-120.99205, 35.4754], [-120.99749, 35.4713], [-121.00653, 35.46592], [-121.00653, 35.464], [-121.00774, 35.464], [-121.00779, 35.46405], [-121.00793, 35.46438], [-121.00813, 35.46456], [-121.00831, 35.46456], [-121.00821, 35.46476], [-121.00827, 35.46492], [-121.00817, 35.46506], [-121.00838, 35.46508], [-121.00853, 35.46526], [-121.00867, 35.46537], [-121.00854, 35.46545], [-121.00854, 35.46547], [-121.00877, 35.46554], [-121.00876, 35.46571], [-121.00887, 35.46579], [-121.0087, 35.46596], [-121.00895, 35.46598], [-121.00896, 35.46606], [-121.00891, 35.46623], [-121.00899, 35.46632], [-121.00891, 35.46647], [-121.00899, 35.46663], [-121.00923, 35.46664], [-121.00929, 35.46692], [-121.00953, 35.46701], [-121.00951, 35.46718], [-121.00957, 35.46753], [-121.00962, 35.46771], [-121.00982, 35.46781], [-121.01, 35.46764], [-121.01026, 35.46796], [-121.0106, 35.46813], [-121.01054, 35.46835], [-121.01072, 35.46838], [-121.01089, 35.46855], [-121.011, 35.46887], [-121.01119, 35.46891], [-121.01147, 35.46893], [-121.01148, 35.46907], [-121.01131, 35.46932], [-121.01144, 35.46954], [-121.01208, 35.46996], [-121.01226, 35.47003], [-121.01226, 35.47018], [-121.01242, 35.47034], [-121.01252, 35.47064], [-121.01249, 35.47078], [-121.01234, 35.47083], [-121.01233, 35.47093], [-121.01274, 35.47102], [-121.01261, 35.47112], [-121.01261, 35.47114], [-121.0131, 35.47132], [-121.01312, 35.47138], [-121.01327, 35.47176], [-121.01343, 35.47208], [-121.01366, 35.47224], [-121.01373, 35.4724], [-121.01396, 35.47256], [-121.0142, 35.4726], [-121.01428, 35.4727], [-121.01449, 35.47266], [-121.01455, 35.47255], [-121.01471, 35.47263], [-121.01481, 35.47281], [-121.01494, 35.47286], [-121.01539, 35.47311], [-121.01553, 35.47334], [-121.01561, 35.47393], [-121.01578, 35.47413], [-121.01598, 35.47418], [-121.01616, 35.47431], [-121.01637, 35.47434], [-121.01645, 35.47447], [-121.01661, 35.47458], [-121.01658, 35.47473], [-121.01677, 35.47477], [-121.01687, 35.47504], [-121.01689, 35.47516], [-121.01708, 35.47521], [-121.01743, 35.47551], [-121.01772, 35.47584], [-121.01798, 35.47617], [-121.0181, 35.47649], [-121.01814, 35.47664], [-121.01833, 35.47657], [-121.01834, 35.47681], [-121.01845, 35.47696], [-121.01872, 35.47697], [-121.01885, 35.47685], [-121.01884, 35.47696], [-121.01901, 35.47725], [-121.01906, 35.47749], [-121.0194, 35.47758], [-121.01981, 35.47822], [-121.02011, 35.47838], [-121.02028, 35.47854]]]} Open Access 1 701 Harmony Headlands State Park 1555 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/?page_id=25735 San Luis Obispo 1 748.66 Harmony Headlands SP 2003 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]);