units_with_maps

Table actions

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

2 rows where DES_TP = 4, MNG_AG_TYP = 4 and PARK_URL = "http://www.openspace.org/preserves/pr_los_trancos.asp"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Recreation/Parks District · 2 ✖

DES_TP 1

  • Local Conservation Area · 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
5477 5477 5476 {"type": "Polygon", "coordinates": [[[-122.18511, 37.3274], [-122.18485, 37.32804], [-122.18442, 37.32786], [-122.1844, 37.32787], [-122.18274, 37.33293], [-122.18245, 37.33263], [-122.18233, 37.33257], [-122.18217, 37.33244], [-122.18196, 37.33235], [-122.18177, 37.33223], [-122.18159, 37.33209], [-122.18127, 37.33171], [-122.18085, 37.33113], [-122.18064, 37.33089], [-122.18037, 37.3307], [-122.18014, 37.3305], [-122.17984, 37.33027], [-122.17932, 37.32992], [-122.17905, 37.32965], [-122.17882, 37.32947], [-122.17856, 37.32922], [-122.17825, 37.32899], [-122.17774, 37.32855], [-122.17725, 37.32821], [-122.17668, 37.32766], [-122.17642, 37.32744], [-122.17606, 37.32707], [-122.175, 37.32582], [-122.17481, 37.32571], [-122.17472, 37.32564], [-122.17457, 37.32546], [-122.17449, 37.32533], [-122.17448, 37.32519], [-122.1779, 37.32519], [-122.1788, 37.32635], [-122.18007, 37.32607], [-122.18023, 37.32606], [-122.18213, 37.32675], [-122.18367, 37.32594], [-122.18396, 37.32592], [-122.18405, 37.32594], [-122.18383, 37.32673], [-122.18511, 37.3274]]]} Open Access 1 17463 Los Trancos Open Space Preserve 31482 2079 Midpeninsula Regional Open Space District 366 Special District 4 Recreation/Parks District 4 http://www.openspace.org Special District 4 2079 Midpeninsula Regional Open Space District 631 Special District 4 Recreation/Parks District 4 http://www.openspace.org/preserves/pr_los_trancos.asp San Mateo 15 86.768 Los Trancos OSP 1976 Local Conservation Area 4 2
15903 15903 15902 {"type": "MultiPolygon", "coordinates": [[[[-122.18278, 37.33297], [-122.18272, 37.333], [-122.18261, 37.33334], [-122.18261, 37.33356], [-122.17958, 37.34259], [-122.17946, 37.34223], [-122.17893, 37.34194], [-122.1787, 37.34177], [-122.17828, 37.34176], [-122.1778, 37.3418], [-122.17739, 37.34154], [-122.17649, 37.34145], [-122.17621, 37.34058], [-122.17626, 37.34046], [-122.17643, 37.34036], [-122.17717, 37.34006], [-122.17723, 37.33994], [-122.17748, 37.33988], [-122.17801, 37.34016], [-122.17828, 37.33983], [-122.17777, 37.33941], [-122.17803, 37.33926], [-122.17815, 37.33901], [-122.17849, 37.33787], [-122.17852, 37.33757], [-122.17844, 37.33731], [-122.17814, 37.33675], [-122.17783, 37.33645], [-122.17723, 37.33635], [-122.17716, 37.33632], [-122.17724, 37.33544], [-122.17768, 37.33545], [-122.17776, 37.33452], [-122.17689, 37.3345], [-122.17667, 37.33386], [-122.17707, 37.33349], [-122.17711, 37.33339], [-122.17788, 37.33331], [-122.17816, 37.33308], [-122.17721, 37.33225], [-122.17693, 37.33221], [-122.17649, 37.33236], [-122.17604, 37.33312], [-122.17541, 37.33314], [-122.17409, 37.33299], [-122.17361, 37.33233], [-122.17377, 37.33181], [-122.17329, 37.33154], [-122.1728, 37.33106], [-122.17266, 37.33083], [-122.17243, 37.3306], [-122.1725, 37.33051], [-122.17293, 37.3305], [-122.17318, 37.3303], [-122.17321, 37.32968], [-122.17248, 37.32948], [-122.17237, 37.32941], [-122.17233, 37.32841], [-122.17236, 37.3284], [-122.17264, 37.32825], [-122.1727, 37.32793], [-122.17258, 37.32769], [-122.1723, 37.32766], [-122.17228, 37.32715], [-122.17216, 37.32714], [-122.17224, 37.32641], [-122.17241, 37.32581], [-122.1726, 37.32536], [-122.17281, 37.32515], [-122.17358, 37.32481], [-122.17376, 37.32479], [-122.17424, 37.32501], [-122.17439, 37.32507], [-122.17452, 37.32519], [-122.17448, 37.3252], [-122.17449, 37.32533], [-122.17457, 37.32546], [-122.17472, 37.32564], [-122.17481, 37.32571], [-122.175, 37.32582], [-122.17606, 37.32707], [-122.17642, 37.32744], [-122.17668, 37.32766], [-122.17725, 37.32821], [-122.17774, 37.32855], [-122.17825, 37.32899], [-122.17856, 37.32922], [-122.17882, 37.32947], [-122.17905, 37.32965], [-122.17932, 37.32992], [-122.17984, 37.33027], [-122.18014, 37.3305], [-122.18037, 37.3307], [-122.18064, 37.33089], [-122.18085, 37.33113], [-122.18127, 37.33171], [-122.18159, 37.33209], [-122.18177, 37.33223], [-122.18196, 37.33235], [-122.18217, 37.33244], [-122.18233, 37.33257], [-122.18245, 37.33263], [-122.18278, 37.33297]]], [[[-122.173, 37.32979], [-122.17297, 37.33023], [-122.17284, 37.33033], [-122.17241, 37.33035], [-122.17238, 37.32962], [-122.173, 37.32979]]]]} Open Access 1 17460 Los Trancos Open Space Preserve 31482 2079 Midpeninsula Regional Open Space District 366 Special District 4 Recreation/Parks District 4 http://www.openspace.org Special District 4 2079 Midpeninsula Regional Open Space District 631 Special District 4 Recreation/Parks District 4 http://www.openspace.org/preserves/pr_los_trancos.asp Santa Clara 19 188.286 Los Trancos OSP 1976 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]);