units_with_maps

Table actions

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

2 rows where GAP_STS = 2, MNG_AGENCY = 338 and MNG_AG_TYP = 4

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Recreation/Parks District · 2 ✖

MNG_AGENCY 1

  • Greater Vallejo Recreation and Park District · 2 ✖

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
7556 7556 7555 {"type": "Polygon", "coordinates": [[[-122.20957, 38.06758], [-122.20956, 38.06787], [-122.2084, 38.06804], [-122.20788, 38.06822], [-122.20785, 38.06852], [-122.20778, 38.06848], [-122.2077, 38.06847], [-122.20762, 38.0685], [-122.20758, 38.06855], [-122.20759, 38.06864], [-122.2077, 38.06874], [-122.20771, 38.06882], [-122.20641, 38.06881], [-122.20508, 38.06877], [-122.2051, 38.06835], [-122.2051, 38.06699], [-122.20529, 38.06729], [-122.20608, 38.06766], [-122.20684, 38.06774], [-122.20738, 38.0674], [-122.20741, 38.06735], [-122.20741, 38.06694], [-122.20762, 38.06695], [-122.20766, 38.06688], [-122.20789, 38.06689], [-122.20799, 38.06681], [-122.20802, 38.06687], [-122.20812, 38.06691], [-122.20868, 38.06703], [-122.20899, 38.06696], [-122.20924, 38.06686], [-122.20938, 38.06689], [-122.20936, 38.06708], [-122.20948, 38.0671], [-122.20946, 38.06757], [-122.20957, 38.06758]]]} Open Access 1 47640 Glen Cove Nature Area 31382 2224 Greater Vallejo Recreation and Park District 341 Special District 4 Recreation/Parks District 4 http://www.gvrd.org/ Special District 4 2224 Greater Vallejo Recreation and Park District 338 Special District 4 Recreation/Parks District 4 http://www.gvrd.org/?page=Glen_Cove_Nature_Area Solano 26 13.068 Glen Cove Nature Area 0 Local Conservation Area 4 2
14222 14222 14221 {"type": "Polygon", "coordinates": [[[-122.20351, 38.11873], [-122.20328, 38.11883], [-122.20313, 38.11904], [-122.20284, 38.11927], [-122.20219, 38.11961], [-122.20174, 38.11972], [-122.20122, 38.12015], [-122.20077, 38.1204], [-122.20056, 38.12044], [-122.20036, 38.12056], [-122.20022, 38.12088], [-122.19972, 38.12162], [-122.19969, 38.12201], [-122.19851, 38.12033], [-122.19912, 38.12062], [-122.20048, 38.12015], [-122.2031, 38.11852], [-122.20351, 38.11873]]]} Open Access 1 44102 Blue Rock Springs Corridor 16188 2224 Greater Vallejo Recreation and Park District 341 Special District 4 Recreation/Parks District 4 http://www.gvrd.org/ Special District 4 2224 Greater Vallejo Recreation and Park District 338 Special District 4 Recreation/Parks District 4   Solano 26 6.569 Blue Rock Springs Corridor 0 Local Conservation Area 4 2

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