superunits_with_maps

Table actions

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

5 rows where MNG_AG_TYP = 2 and PARK_NAME = "Veteran's Park"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 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
10803 10803 10802 {"type": "Polygon", "coordinates": [[[-121.70958, 37.92667], [-121.70943, 37.92742], [-121.70767, 37.92741], [-121.70765, 37.92742], [-121.70622, 37.92743], [-121.70621, 37.92742], [-121.70653, 37.92713], [-121.70686, 37.92711], [-121.70703, 37.92706], [-121.70715, 37.92701], [-121.70724, 37.927], [-121.70725, 37.92699], [-121.7072, 37.92693], [-121.70717, 37.92697], [-121.70703, 37.92703], [-121.70685, 37.92709], [-121.70652, 37.92711], [-121.70618, 37.92741], [-121.70575, 37.9271], [-121.7054, 37.92676], [-121.70524, 37.92649], [-121.7051, 37.92615], [-121.70504, 37.92587], [-121.70503, 37.92565], [-121.70515, 37.92561], [-121.70876, 37.9256], [-121.70878, 37.92589], [-121.70958, 37.92667]], [[-121.70697, 37.92638], [-121.70699, 37.92637], [-121.70694, 37.9263], [-121.70691, 37.92631], [-121.70697, 37.92638]], [[-121.70698, 37.9266], [-121.70697, 37.92659], [-121.70695, 37.9266], [-121.70696, 37.92662], [-121.70698, 37.9266]], [[-121.70703, 37.92655], [-121.70702, 37.92654], [-121.70701, 37.92656], [-121.70702, 37.92656], [-121.70703, 37.92655]], [[-121.70734, 37.92716], [-121.70735, 37.92715], [-121.70732, 37.92712], [-121.70731, 37.92714], [-121.70734, 37.92716]], [[-121.70765, 37.92738], [-121.70766, 37.92738], [-121.70766, 37.92736], [-121.70764, 37.92736], [-121.70765, 37.92738]]]} Open Access 1 Veteran's Park http://gis.brentwoodca.gov/parksfinder/ 27016 1034 Brentwood, City of 348 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 16.859 Veteran's Park  
10804 10804 10803 {"type": "Polygon", "coordinates": [[[-117.02396, 32.61584], [-117.02393, 32.61586], [-117.02373, 32.61589], [-117.02343, 32.61597], [-117.02309, 32.61611], [-117.02279, 32.6162], [-117.02238, 32.61624], [-117.02184, 32.61624], [-117.02154, 32.6163], [-117.02121, 32.61641], [-117.02072, 32.61552], [-117.02075, 32.61546], [-117.02211, 32.61492], [-117.02254, 32.61476], [-117.02317, 32.6146], [-117.0237, 32.61451], [-117.02378, 32.61456], [-117.02394, 32.61552], [-117.02391, 32.61576], [-117.02396, 32.61584]]]} Open Access 1 Veteran's Park http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/veterans-park 27017 1056 Chula Vista, City of 117 City 2 City Agency 2 http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp City 2 10.03 Veteran's Park  
10805 10805 10804 {"type": "Polygon", "coordinates": [[[-117.43128, 34.09033], [-117.43029, 34.09035], [-117.43029, 34.09206], [-117.42712, 34.09208], [-117.42712, 34.09035], [-117.42919, 34.09033], [-117.42919, 34.08853], [-117.43127, 34.08852], [-117.43128, 34.09033]]]} Open Access 1 Veteran's Park   27018 1109 Fontana, City of 164 City 2 City Agency 2 http://www.fontana.org/index.aspx?NID=551 City 2 23.487 Veteran's Park  
10806 10806 10805 {"type": "Polygon", "coordinates": [[[-119.28949, 35.49274], [-119.28948, 35.49369], [-119.28934, 35.49371], [-119.28931, 35.49575], [-119.28733, 35.49575], [-119.28737, 35.49276], [-119.28744, 35.49273], [-119.28949, 35.49274]]]} Open Access 1 Veteran's Park   27019 1668 Shafter, City of 412 City 2 City Agency 2 http://www.shafter.com/73/Parks City 2 15.173 Veteran's Park  
12178 12178 12177 {"type": "Polygon", "coordinates": [[[-117.036, 32.97054], [-117.03563, 32.97054], [-117.03563, 32.9703], [-117.036, 32.9703], [-117.036, 32.97054]]]} Open Access 1 Veteran's Park http://poway.org/538/Veterans-Park 29158 1262 Poway, City of 129 City 2 City Agency 2 http://poway.org/204/Community-Services---Parks-Recreation City 2 0.229 Veteran's Park  

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