superunits_with_maps

Table actions

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

5 rows where MNG_AGENCY = 32 and YR_EST = 1997

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • San Jose, City of · 5 ✖

ACCESS_TYP 1

Link rowid ▼ id map ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST
1680 1680 1679 {"type": "Polygon", "coordinates": [[[-121.77072, 37.22196], [-121.77013, 37.22259], [-121.76976, 37.22234], [-121.76988, 37.22226], [-121.76994, 37.22218], [-121.77006, 37.22183], [-121.77011, 37.22179], [-121.77017, 37.22179], [-121.77036, 37.22183], [-121.77072, 37.22196]]]} Open Access 1 Avenida Espana Park   15723 1303 San Jose, City of 32 City 2 City Agency 2 http://www.sanjoseca.gov/index.aspx?NID=204 City 2 0.924 Avenida Espana Park 1997
4046 4046 4045 {"type": "Polygon", "coordinates": [[[-121.86656, 37.26253], [-121.86634, 37.26259], [-121.86631, 37.26264], [-121.86612, 37.26268], [-121.86603, 37.26264], [-121.86579, 37.26271], [-121.86579, 37.26276], [-121.86552, 37.26284], [-121.86549, 37.26281], [-121.8655, 37.26278], [-121.8654, 37.26259], [-121.86515, 37.26266], [-121.86515, 37.2627], [-121.86504, 37.26273], [-121.86503, 37.26276], [-121.86487, 37.26281], [-121.86469, 37.26241], [-121.86488, 37.26235], [-121.86489, 37.26233], [-121.86488, 37.26229], [-121.86546, 37.26213], [-121.86548, 37.26206], [-121.86552, 37.26198], [-121.86559, 37.262], [-121.86566, 37.26197], [-121.86567, 37.26231], [-121.86643, 37.26232], [-121.86647, 37.26245], [-121.86656, 37.26253]]]} Open Access 1 Erikson Park   18694 1303 San Jose, City of 32 City 2 City Agency 2 http://www.sanjoseca.gov/index.aspx?NID=204 City 2 1.876 Erikson Park 1997
9421 9421 9420 {"type": "Polygon", "coordinates": [[[-121.89561, 37.25718], [-121.89547, 37.25727], [-121.89533, 37.25733], [-121.89499, 37.25756], [-121.89484, 37.2574], [-121.89484, 37.25737], [-121.89487, 37.25734], [-121.89544, 37.25705], [-121.89551, 37.25706], [-121.89561, 37.25718]]]} Open Access 1 Scottsdale Park   25216 1303 San Jose, City of 32 City 2 City Agency 2 http://www.sanjoseca.gov/index.aspx?NID=204 City 2 0.386 Scottsdale Park 1997
9672 9672 9671 {"type": "Polygon", "coordinates": [[[-121.80229, 37.29962], [-121.80228, 37.29968], [-121.80223, 37.29972], [-121.80217, 37.29974], [-121.80167, 37.29976], [-121.80127, 37.29971], [-121.80083, 37.29959], [-121.80041, 37.29941], [-121.80029, 37.29934], [-121.79935, 37.29865], [-121.79849, 37.29807], [-121.7982, 37.29794], [-121.79762, 37.29775], [-121.79726, 37.29771], [-121.79688, 37.29768], [-121.79618, 37.29772], [-121.79586, 37.29771], [-121.79542, 37.29766], [-121.79511, 37.29759], [-121.79493, 37.29754], [-121.79489, 37.2975], [-121.79488, 37.29746], [-121.79492, 37.29733], [-121.79496, 37.2973], [-121.79501, 37.29728], [-121.79528, 37.29728], [-121.79537, 37.29731], [-121.79733, 37.29722], [-121.79798, 37.29744], [-121.79841, 37.29762], [-121.79913, 37.29778], [-121.79984, 37.29776], [-121.79996, 37.29788], [-121.80108, 37.29865], [-121.80193, 37.29927], [-121.80227, 37.29957], [-121.80229, 37.29962]]]} Open Access 1 Silver Creek Linear Park   25483 1303 San Jose, City of 32 City 2 City Agency 2 http://www.sanjoseca.gov/index.aspx?NID=204 City 2 11.639 Silver Creek Linear Park 1997
9673 9673 9672 {"type": "Polygon", "coordinates": [[[-121.7916, 37.29481], [-121.79152, 37.2951], [-121.79051, 37.29593], [-121.78977, 37.29536], [-121.78935, 37.29509], [-121.7902, 37.29439], [-121.7916, 37.29481]]]} Open Access 1 Silver Creek Linear Park: Picnic Meadow   25484 1303 San Jose, City of 32 City 2 City Agency 2 http://www.sanjoseca.gov/index.aspx?NID=204 City 2 4.531 Silver Creek Linear Park: Picnic Meadow 1997

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);