superunits_with_maps

Table actions

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

3 rows where ACCESS_TYP = 2 and MNG_AGENCY = 306

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • South Pasadena, City of · 3 ✖

ACCESS_TYP 1

  • Restricted Access · 3 ✖
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
215 215 214 {"type": "Polygon", "coordinates": [[[-118.17442, 34.11313], [-118.17382, 34.11314], [-118.17249, 34.1138], [-118.1717, 34.11481], [-118.17141, 34.1152], [-118.17123, 34.11541], [-118.17063, 34.11525], [-118.17023, 34.11568], [-118.1699, 34.11588], [-118.16957, 34.11604], [-118.1687, 34.11633], [-118.1684, 34.11659], [-118.16778, 34.11722], [-118.16752, 34.1172], [-118.16721, 34.11716], [-118.16702, 34.11722], [-118.16668, 34.1172], [-118.16617, 34.11698], [-118.1663, 34.1167], [-118.16644, 34.11652], [-118.16714, 34.1158], [-118.16736, 34.11565], [-118.16786, 34.11535], [-118.16903, 34.11436], [-118.17094, 34.11312], [-118.17138, 34.11306], [-118.1719, 34.11287], [-118.17256, 34.11271], [-118.17296, 34.1125], [-118.17362, 34.11232], [-118.17402, 34.11239], [-118.17442, 34.11313]]]} Restricted Access 2 Arroyo Seco Golf Course http://www.arroyosecogolf.com/Home.html 29411 1340 South Pasadena, City of 306 City 2 City Agency 2 http://www.ci.south-pasadena.ca.us/ City 2 31.165 Arroyo Seco GC  
12405 12405 12404 {"type": "Polygon", "coordinates": [[[-118.16833, 34.12281], [-118.16827, 34.12316], [-118.16819, 34.12339], [-118.16805, 34.12365], [-118.16806, 34.12387], [-118.168, 34.12391], [-118.16596, 34.12389], [-118.16631, 34.12303], [-118.16635, 34.12294], [-118.16642, 34.12286], [-118.16833, 34.12281]]]} Restricted Access 2 San Pascual Stables http://www.ci.south-pasadena.ca.us/index.aspx?page=67 29415 1340 South Pasadena, City of 306 City 2 City Agency 2 http://www.ci.south-pasadena.ca.us/ City 2 5.408 San Pascual Stables  
15514 15514 15513 {"type": "Polygon", "coordinates": [[[-118.17123, 34.11541], [-118.16918, 34.11752], [-118.16899, 34.11733], [-118.16859, 34.11755], [-118.16858, 34.11758], [-118.16862, 34.11762], [-118.16806, 34.11775], [-118.168, 34.11744], [-118.16778, 34.11722], [-118.1684, 34.11659], [-118.1687, 34.11633], [-118.16956, 34.11605], [-118.1699, 34.11588], [-118.17023, 34.11568], [-118.17064, 34.11524], [-118.17123, 34.11541]]]} Restricted Access 2 Arroyo Seco Racquet Center http://www.ci.south-pasadena.ca.us/index.aspx?page=66 29412 1340 South Pasadena, City of 306 City 2 City Agency 2 http://www.ci.south-pasadena.ca.us/ City 2 7.413 Arroyo Seco Racquet Ctr.  

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