units_with_maps

Table actions

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

6 rows where ACCESS_TYP = 1, MNG_AG_TYP = 2 and YR_EST = 1997

This data as json, copyable, CSV (advanced)

DES_TP 2

MNG_AG_TYP 1

  • City Agency · 6 ✖

ACCESS_TYP 1

  • Open Access · 6 ✖
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
1450 1450 1449 {"type": "Polygon", "coordinates": [[[-121.79984, 37.29776], [-121.79995, 37.29788], [-121.80108, 37.29865], [-121.80193, 37.29927], [-121.80227, 37.29957], [-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.80028, 37.29934], [-121.79935, 37.29865], [-121.79849, 37.29807], [-121.7982, 37.29794], [-121.79762, 37.29775], [-121.79726, 37.2977], [-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.79914, 37.29778], [-121.79984, 37.29776]]]} Open Access 1 9709 Silver Creek Linear Park 25483 1303 San Jose, City of 33 City 2 City Agency 2 http://www.sanjoseca.gov/index.aspx?NID=204 City 2 1303 San Jose, City of 32 City 2 City Agency 2   Santa Clara 19 11.638 Silver Creek Linear Park 1997 Local Park 2 4
1812 1812 1811 {"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 13746 Scottsdale Park 25216 1303 San Jose, City of 33 City 2 City Agency 2 http://www.sanjoseca.gov/index.aspx?NID=204 City 2 1303 San Jose, City of 32 City 2 City Agency 2   Santa Clara 19 0.386 Scottsdale Park 1997 Local Park 2 4
2823 2823 2822 {"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 22000 Silver Creek Linear Park: Picnic Meadow 25484 1303 San Jose, City of 33 City 2 City Agency 2 http://www.sanjoseca.gov/index.aspx?NID=204 City 2 1303 San Jose, City of 32 City 2 City Agency 2   Santa Clara 19 4.532 Silver Creek Linear Park: Picnic Meadow 1997 None 233  
8579 8579 8578 {"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 13626 Avenida Espana Park 15723 1303 San Jose, City of 33 City 2 City Agency 2 http://www.sanjoseca.gov/index.aspx?NID=204 City 2 1303 San Jose, City of 32 City 2 City Agency 2   Santa Clara 19 0.924 Avenida Espana Park 1997 Local Park 2 4
8884 8884 8883 {"type": "Polygon", "coordinates": [[[-122.032, 37.32214], [-122.032, 37.3226], [-122.03199, 37.32268], [-122.03153, 37.32232], [-122.03175, 37.32214], [-122.032, 37.32214]]]} Open Access 1 14521 Cali Mill Plaza 16683 1076 Cupertino, City of 195 City 2 City Agency 2 http://www.cupertino.org/index.aspx?page=591 City 2 1076 Cupertino, City of 191 City 2 City Agency 2   Santa Clara 19 0.367 Cali Mill Plaza 1997 Local Park 2 4
9593 9593 9592 {"type": "Polygon", "coordinates": [[[-121.86656, 37.26253], [-121.86634, 37.26259], [-121.86631, 37.26264], [-121.86612, 37.26268], [-121.86603, 37.26264], [-121.86578, 37.26271], [-121.86579, 37.26276], [-121.86552, 37.26284], [-121.86549, 37.26281], [-121.8655, 37.26279], [-121.8654, 37.26259], [-121.86514, 37.26266], [-121.86515, 37.2627], [-121.86503, 37.26273], [-121.86503, 37.26276], [-121.86487, 37.26281], [-121.86469, 37.26241], [-121.86488, 37.26235], [-121.8649, 37.26233], [-121.86488, 37.26229], [-121.86547, 37.26213], [-121.86548, 37.26206], [-121.86552, 37.26198], [-121.86559, 37.262], [-121.86566, 37.26197], [-121.86566, 37.26231], [-121.86643, 37.26232], [-121.86647, 37.26245], [-121.86656, 37.26253]]]} Open Access 1 16134 Erikson Park 18694 1303 San Jose, City of 33 City 2 City Agency 2 http://www.sanjoseca.gov/index.aspx?NID=204 City 2 1303 San Jose, City of 32 City 2 City Agency 2   Santa Clara 19 1.868 Erikson Park 1997 Local Park 2 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]);