superunits_with_maps

Table actions

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

6 rows where ACCESS_TYP = 1 and ACRES = "0.282"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 2

ACCESS_TYP 1

  • Open Access · 6 ✖
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
51 51 50 {"type": "Polygon", "coordinates": [[[-122.28849, 37.84349], [-122.28816, 37.84358], [-122.28806, 37.84325], [-122.28838, 37.84316], [-122.28849, 37.84349]]]} Open Access 1 61st Street Mini Park   15207 1098 Emeryville, City of 769 City 2 City Agency 2 http://www.ci.emeryville.ca.us/158/City-Parks City 2 0.282 61st Street MP 1976
3387 3387 3386 {"type": "Polygon", "coordinates": [[[-122.40699, 37.65869], [-122.40686, 37.65906], [-122.40654, 37.65898], [-122.40672, 37.65863], [-122.40699, 37.65869]]]} Open Access 1 Cypress and Pine Playlot   17870 1341 South San Francisco, City of 58 City 2 City Agency 2 http://www.ssf.net/377/Parks-Recreation City 2 0.282 Cypress and Pine Playlot  
5200 5200 5199 {"type": "Polygon", "coordinates": [[[-117.81409, 33.75983], [-117.81374, 33.7598], [-117.81367, 33.75975], [-117.81366, 33.75914], [-117.81378, 33.75944], [-117.81391, 33.75962], [-117.81409, 33.75983]]]} Open Access 1 Holderman Park   20027 312 Orange, County of 138 County 3 County Agency 3 http://ocparks.com/ County 3 0.282 Holderman Park  
5791 5791 5790 {"type": "Polygon", "coordinates": [[[-117.88723, 33.5983], [-117.88719, 33.59833], [-117.88651, 33.59833], [-117.88649, 33.59832], [-117.88647, 33.59829], [-117.88647, 33.59812], [-117.88651, 33.59809], [-117.8872, 33.59828], [-117.88723, 33.5983]]]} Open Access 1 L Street Park   20737 1224 Newport Beach, City of 52 City 2 City Agency 2 http://www.newportbeachca.gov/index.aspx?page=66 City 2 0.282 L Street Park  
9357 9357 9356 {"type": "Polygon", "coordinates": [[[-122.14317, 37.42585], [-122.143, 37.42606], [-122.14261, 37.42586], [-122.14279, 37.42565], [-122.14317, 37.42585]]]} Open Access 1 Sarah Wallis Park   25156 1243 Palo Alto, City of 157 City 2 City Agency 2 http://www.cityofpaloalto.org/ City 2 0.282 Sarah Wallis Park  
14192 14192 14191 {"type": "Polygon", "coordinates": [[[-117.24904, 34.0543], [-117.24898, 34.05443], [-117.24893, 34.05447], [-117.24886, 34.05447], [-117.24865, 34.05442], [-117.24854, 34.05438], [-117.24851, 34.05433], [-117.2485, 34.05424], [-117.24851, 34.05422], [-117.24856, 34.05419], [-117.24864, 34.05418], [-117.24899, 34.05424], [-117.24904, 34.0543]]]} Open Access 1 Sonora Loop Park   33156 1181 Loma Linda, City of 181 City 2 City Agency 2 http://www.lomalinda-ca.gov/ City 2 0.282 Sonora Loop 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]);