units_with_maps

Table actions

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

2 rows where ACCESS_TYP = 3, AGNCY_NAME = 23 and MNG_AG_TYP = 3

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • County Agency · 2 ✖

MNG_AGENCY 1

ACCESS_TYP 1

  • No Public 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
4640 4640 4639 {"type": "Polygon", "coordinates": [[[-121.76878, 36.88577], [-121.76854, 36.88632], [-121.76869, 36.88648], [-121.76648, 36.88819], [-121.76471, 36.88798], [-121.7647, 36.88784], [-121.76557, 36.88755], [-121.76873, 36.88508], [-121.76878, 36.88577]]]} No Public Access 3 36489 Unnamed site - Monterey, County of 28701 310 Monterey, County of 23 County 3 County Agency 3 http://www.co.monterey.ca.us/parks/ County 3 310 Monterey, County of 23 County 3 County Agency 3   Monterey 14 10.195   0 Local Other or Unknown 14 4
16112 16112 16111 {"type": "Polygon", "coordinates": [[[-121.93713, 36.48166], [-121.93589, 36.48169], [-121.93565, 36.48218], [-121.93525, 36.48195], [-121.93482, 36.48164], [-121.93419, 36.48187], [-121.93391, 36.48199], [-121.93358, 36.48189], [-121.93342, 36.48203], [-121.93338, 36.48229], [-121.93301, 36.48226], [-121.93275, 36.48226], [-121.93231, 36.48216], [-121.93191, 36.48198], [-121.93176, 36.48178], [-121.93152, 36.48157], [-121.93128, 36.48133], [-121.93093, 36.48159], [-121.93042, 36.48151], [-121.92961, 36.48143], [-121.92935, 36.48143], [-121.929, 36.48119], [-121.92854, 36.48094], [-121.92841, 36.48085], [-121.9281, 36.48118], [-121.92781, 36.48121], [-121.92739, 36.48114], [-121.92715, 36.4812], [-121.92708, 36.48092], [-121.92701, 36.48085], [-121.92674, 36.48095], [-121.92636, 36.48143], [-121.92627, 36.48162], [-121.92607, 36.48167], [-121.92587, 36.48128], [-121.92554, 36.48106], [-121.92515, 36.48102], [-121.92488, 36.48087], [-121.92456, 36.48089], [-121.9244, 36.48062], [-121.92422, 36.48052], [-121.9239, 36.48052], [-121.92367, 36.48066], [-121.92325, 36.48067], [-121.92305, 36.48075], [-121.92282, 36.4806], [-121.92245, 36.48067], [-121.92225, 36.48048], [-121.92171, 36.48029], [-121.92126, 36.48027], [-121.9208, 36.48003], [-121.92055, 36.48], [-121.92003, 36.47982], [-121.91977, 36.47967], [-121.91945, 36.47943], [-121.9191, 36.47929], [-121.91882, 36.47951], [-121.91847, 36.47948], [-121.91822, 36.47935], [-121.91808, 36.47913], [-121.91787, 36.47903], [-121.91757, 36.47903], [-121.91711, 36.4787], [-121.91625, 36.4786], [-121.91605, 36.47854], [-121.92713, 36.47357], [-121.9276, 36.47357], [-121.92774, 36.47311], [-121.9288, 36.47271], [-121.93027, 36.47271], [-121.93103, 36.47268], [-121.93147, 36.47258], [-121.93188, 36.47516], [-121.93333, 36.47501], [-121.93331, 36.47464], [-121.93435, 36.47461], [-121.93547, 36.47413], [-121.93627, 36.47837], [-121.93633, 36.47859], [-121.93644, 36.47889], [-121.9369, 36.47982], [-121.93702, 36.48021], [-121.93711, 36.48089], [-121.93713, 36.48134], [-121.93713, 36.48166]]]} No Public Access 3 16442 County Open Space 17714 310 Monterey, County of 23 County 3 County Agency 3 http://www.co.monterey.ca.us/parks/ County 3 310 Monterey, County of 23 County 3 County Agency 3   Monterey 14 288.367 County OS 0 Local Recreation Area 3 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]);