superunits_with_maps

Table actions

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

5 rows where MNG_AGENCY = 521 sorted by LAYER descending

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • San Francisco Parks Alliance · 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
463 463 462 {"type": "Polygon", "coordinates": [[[-122.39117, 37.78541], [-122.39071, 37.78573], [-122.39028, 37.78609], [-122.39017, 37.78649], [-122.38985, 37.78623], [-122.39103, 37.78533], [-122.39117, 37.78541]]]} Open Access 1 Rincon Hill Dog Park https://www.rinconhilldogpark.org/about 33503 3308 San Francisco Parks Alliance 521 Non Profit 6 Non Profit - Other 20 http://www.sfparksalliance.org/ Non Governmental Organization 10 0.621 Rincon Hill Dog Park 2007
789 789 788 {"type": "Polygon", "coordinates": [[[-122.39104, 37.75772], [-122.39035, 37.75777], [-122.39033, 37.7576], [-122.39101, 37.75756], [-122.39104, 37.75772]]]} Open Access 1 Woods Yard https://www.sfparksalliance.org/our-parks/parks/woods-yard 33552 3308 San Francisco Parks Alliance 521 Non Profit 6 Non Profit - Other 20 http://www.sfparksalliance.org/ Non Governmental Organization 10 0.275 Woods Yard  
802 802 801 {"type": "Polygon", "coordinates": [[[-122.39106, 37.77842], [-122.38914, 37.77987], [-122.38862, 37.78032], [-122.38843, 37.78055], [-122.38828, 37.78079], [-122.38819, 37.78101], [-122.38806, 37.78144], [-122.388, 37.78149], [-122.38791, 37.78151], [-122.38783, 37.7815], [-122.38776, 37.78145], [-122.38774, 37.78141], [-122.38768, 37.7806], [-122.38752, 37.77914], [-122.38746, 37.77826], [-122.38762, 37.77821], [-122.38757, 37.77825], [-122.3878, 37.78026], [-122.38849, 37.78024], [-122.38857, 37.78028], [-122.391, 37.77836], [-122.39106, 37.77842]]]} Open Access 1 South Beach Park https://www.sfparksalliance.org/our-parks/parks/south-beach-park 33553 3308 San Francisco Parks Alliance 521 Non Profit 6 Non Profit - Other 20 http://www.sfparksalliance.org/ Non Governmental Organization 10 2.85 South Beach Park  
819 819 818 {"type": "Polygon", "coordinates": [[[-122.47779, 37.71752], [-122.47794, 37.71754], [-122.47824, 37.71766], [-122.47841, 37.71779], [-122.47855, 37.71794], [-122.47864, 37.71809], [-122.47866, 37.71822], [-122.47864, 37.7183], [-122.4786, 37.71838], [-122.47849, 37.71848], [-122.47837, 37.71855], [-122.47824, 37.71859], [-122.4781, 37.71859], [-122.47795, 37.71857], [-122.47777, 37.71849], [-122.47759, 37.71838], [-122.47748, 37.71829], [-122.47737, 37.71816], [-122.47731, 37.71806], [-122.47729, 37.71796], [-122.4773, 37.71787], [-122.47733, 37.71778], [-122.47742, 37.71767], [-122.47753, 37.71758], [-122.47764, 37.71754], [-122.47779, 37.71752]]]} Open Access 1 Robert Pender Park https://www.sfparksalliance.org/our-parks/parks/robert-pender-park 33555 3308 San Francisco Parks Alliance 521 Non Profit 6 Non Profit - Other 20 http://www.sfparksalliance.org/ Non Governmental Organization 10 2.547 Robert Pender Park  
4028 4028 4027 {"type": "Polygon", "coordinates": [[[-122.44958, 37.76633], [-122.44898, 37.7664], [-122.44881, 37.76647], [-122.44849, 37.76654], [-122.44848, 37.76657], [-122.44806, 37.76662], [-122.44802, 37.76642], [-122.44844, 37.76637], [-122.44847, 37.7664], [-122.44872, 37.76635], [-122.44892, 37.76627], [-122.44902, 37.7662], [-122.44899, 37.76602], [-122.4495, 37.76595], [-122.44958, 37.76633]]]} Open Access 1 Richard Gamble Memorial Park https://www.sfparksalliance.org/our-parks/parks/gamble-memorial-park 33627 3308 San Francisco Parks Alliance 521 Non Profit 6 Non Profit - Other 20 http://www.sfparksalliance.org/ Non Governmental Organization 10 0.913 Richard Gamble Memorial 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]);