Street_Tree_List

Data source: data.sfgov.org

21 rows where qLegalStatus = 4 and qSpecies = 26

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, qSiteInfo, PlantDate, PlotSize, PermitNotes, XCoord, YCoord, Latitude, Longitude, Location

qLegalStatus ✖

  • Planning Code 138.1 required · 21 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
54 54 121137 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 1388x Minna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/08/2016 12:00:00 AM 3 3x3            
60 60 121139 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 1388x Minna St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/08/2016 12:00:00 AM 3 3x3            
70 70 121138 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 1388x Minna St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/08/2016 12:00:00 AM 3 3x3            
347 347 250073 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 1599X Bush St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6006083.0 2115238.0 37.7883840466687 -122.422774045373 (37.7883840466687, -122.422774045373)
373 373 250075 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 1599X Bush St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6006083.0 2115238.0 37.7883840466687 -122.422774045373 (37.7883840466687, -122.422774045373)
377 377 250072 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 1599X Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6006083.0 2115238.0 37.7883840466687 -122.422774045373 (37.7883840466687, -122.422774045373)
415 415 250074 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 1599X Bush St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6006083.0 2115238.0 37.7883840466687 -122.422774045373 (37.7883840466687, -122.422774045373)
2129 2129 156905 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 3201x 17th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/26/2017 12:00:00 AM 3 3x6 Permit Number 777588 6007417.0 2106083.0 37.763321780718705 -122.417509514421 (37.7633217807187, -122.417509514421)
2133 2133 252909 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 3201x 17th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/26/2017 12:00:00 AM 3 3x6 Permit Number 777588 6007417.0 2106083.0 37.763321780718705 -122.417509514421 (37.7633217807187, -122.417509514421)
2142 2142 252906 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 600 South Van Ness Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/26/2017 12:00:00 AM 3 3x3 Permit Number 777588 6007451.05071 2106154.24093 37.7635193076139 -122.417396792879 (37.7635193076139, -122.417396792879)
2143 2143 252905 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 600 South Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/26/2017 12:00:00 AM 3 3x3 Permit Number 777588 6007451.05071 2106154.24093 37.7635193076139 -122.417396792879 (37.7635193076139, -122.417396792879)
2147 2147 252908 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 600 South Van Ness Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/26/2017 12:00:00 AM 3 3x3 Permit Number 777588 6007451.05071 2106154.24093 37.7635193076139 -122.417396792879 (37.7635193076139, -122.417396792879)
2575 2575 253126 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 182 London St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/19/2017 12:00:00 AM 3 3x3 Permit Number 779117 6002742.73008 2092646.2038099999 37.726163358663705 -122.432716365158 (37.7261633586637, -122.432716365158)
3179 3179 253343 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 200 Arguello Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x6 Permit Number 778434 5995550.1802199995 2114806.2223 37.786598594028504 -122.459184390305 (37.7865985940285, -122.459184390305)
3189 3189 253342 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 200 Arguello Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x6 Permit Number 778434 5995550.1802199995 2114806.2223 37.786598594028504 -122.459184390305 (37.7865985940285, -122.459184390305)
3687 3687 152811 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 2901 25th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/18/2017 12:00:00 AM 3 6x6 Permit Number 777487 6009988.15821 2101607.87857 37.7511784382559 -122.40830102206999 (37.7511784382559, -122.40830102207)
3691 3691 152812 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 2901 25th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/18/2017 12:00:00 AM 3 6x6 Permit Number 777487 6010002.42353 2101608.75594 37.751181646126795 -122.40825175271401 (37.7511816461268, -122.408251752714)
3700 3700 152810 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 2901 25th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/18/2017 12:00:00 AM 3 6x6 Permit Number 777487 6009973.24314 2101608.01571 37.751177979599206 -122.408352609887 (37.7511779795992, -122.408352609887)
5087 5087 150676 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 548 Rhode Island St 1 Front Yard : Cutout 8 Tree 1 Private 1   11/07/2017 12:00:00 AM 3 3x3 Permit Number 780811 6011754.983990001 2105812.52377 37.762822244976505 -122.402486741392 (37.7628222449765, -122.402486741392)
80040 80040 53968 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 1354 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/20/2015 12:00:00 AM   3x3 Permit Number 773113 5988678.33594659 2106104.92629407 37.762309795805294 -122.48232125545799 (37.7623097958053, -122.482321255458)
86420 86420 113721 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 1526 22nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/08/2015 12:00:00 AM   3x3   5989360.0 2104938.6 37.7591470062831 -122.479878309336 (37.7591470062831, -122.479878309336)

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 77.028ms · Data source: data.sfgov.org