Street_Tree_List

Data source: data.sfgov.org

148 rows where qSpecies = 69 sorted by Location

View and edit SQL

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location ▼
127683 85770 Permitted Site 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 1480 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/07/2007 12:00:00 AM 3 3x3   6008543.0 2109248.0 37.7720754271741 -122.41383893105801 (37.7720754271741, -122.413838931058)
145109 98188 Permitted Site 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 1498X Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 3x3   6008543.0 2109248.0 37.7720754271741 -122.41383893105801 (37.7720754271741, -122.413838931058)
99838 85776 DPW Maintained 3 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 1425 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/09/2015 11:16:00 AM 3 3x3   6008757.0 2109407.0 37.772524019699 -122.413109930192 (37.772524019699, -122.413109930192)
121518 98189 Permitted Site 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 1498X Folsom St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 3x3   6008828.0 2109520.0 37.7728382767515 -122.412872323828 (37.7728382767515, -122.412872323828)
90626 69599 Permitted Site 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 366 Page St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/24/2014 12:00:00 AM 3   Permit Number 773624 6004805.18148758 2109878.85249056 37.7735969721496 -122.42681328543001 (37.7735969721496, -122.42681328543)
14261 85782 Permitted Site 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 1265 Folsom St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/04/2014 03:09:00 PM 8 3x3   6009372.4773 2109973.5478 37.7741141600547 -122.411020947743 (37.7741141600547, -122.411020947743)
15103 85784 DPW Maintained 3 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 1257 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/09/2015 11:19:00 AM 3 3x3   6009427.6278 2110025.2513 37.7742592182749 -122.410833824093 (37.7742592182749, -122.410833824093)
82663 85791 DPW Maintained 3 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 1101X Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/07/2007 12:00:00 AM 3 3x3   6010323.0 2110925.0 37.776779882708205 -122.407800012097 (37.7767798827082, -122.407800012097)
129479 112783 Permitted Site 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 506 10th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/19/2015 12:00:00 AM     Permit Number 774416 5992870.4 2111974.5 37.7786690335249 -122.468249618869 (37.7786690335249, -122.468249618869)
111578 85758 DPW Maintained 3 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 984 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/07/2007 12:00:00 AM 3 3x3   6011059.0 2111650.0 37.7788117396287 -122.40530502246901 (37.7788117396287, -122.405305022469)
13595 85796 DPW Maintained 3 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 975 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/18/2014 12:00:00 AM 3 3x3   6011171.3417 2111690.3951 37.778928935443204 -122.404919231111 (37.7789289354432, -122.404919231111)
84955 85798 DPW Maintained 3 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 965 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/07/2007 12:00:00 AM 3 3x3   6011205.0 2111745.0 37.7790807491546 -122.404806638376 (37.7790807491546, -122.404806638376)
101326 85800 DPW Maintained 3 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 935 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/07/2007 12:00:00 AM 3 3x3 Permit Number 768011 6011398.0 2111930.0 37.7795995018672 -122.404151992929 (37.7795995018672, -122.404151992929)
111910 85801 DPW Maintained 3 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 935 Folsom St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/07/2007 12:00:00 AM 3 3x3 Permit Number 768011 6011398.0 2111930.0 37.7795995018672 -122.404151992929 (37.7795995018672, -122.404151992929)
124908 85802 DPW Maintained 3 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 935 Folsom St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/07/2007 12:00:00 AM 3 3x3 Permit Number 768011 6011398.0 2111930.0 37.7795995018672 -122.404151992929 (37.7795995018672, -122.404151992929)
361 85803 Planning Code 138.1 required 4 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 923 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 3x3 Permit Number 778048 6011427.0378 2111936.1074 37.779617893816 -122.40405196806002 (37.779617893816, -122.40405196806)
394 85804 Planning Code 138.1 required 4 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 923 Folsom St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 3x3 Permit Number 778048 6011441.4589 2111949.4191 37.7796552503769 -122.404003016031 (37.7796552503769, -122.404003016031)
99536 85808 DPW Maintained 3 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 901X Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/07/2007 12:00:00 AM 3 3x3   6011628.490476 2112144.478567 37.780201286185104 -122.40336971541402 (37.7802012861851, -122.403369715414)
81153 85749 DPW Maintained 3 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 900 Folsom St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/07/2007 12:00:00 AM 3 3x3   6011609.0 2112176.0 37.78028674810621 -122.403439360525 (37.7802867481062, -122.403439360525)
81492 85755 DPW Maintained 3 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 900 Folsom St 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/07/2007 12:00:00 AM 3 3x3   6011609.0 2112176.0 37.78028674810621 -122.403439360525 (37.7802867481062, -122.403439360525)
99191 85752 DPW Maintained 3 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 900 Folsom St 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/07/2007 12:00:00 AM 3 3x3   6011609.0 2112176.0 37.78028674810621 -122.403439360525 (37.7802867481062, -122.403439360525)
106010 85751 DPW Maintained 3 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 900 Folsom St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/07/2007 12:00:00 AM 3 3x3   6011609.0 2112176.0 37.78028674810621 -122.403439360525 (37.7802867481062, -122.403439360525)
107666 85746 DPW Maintained 3 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 900 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/07/2007 12:00:00 AM 3 3x3   6011609.0 2112176.0 37.78028674810621 -122.403439360525 (37.7802867481062, -122.403439360525)
111190 85747 DPW Maintained 3 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 900 Folsom St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/07/2007 12:00:00 AM 3 3x3   6011609.0 2112176.0 37.78028674810621 -122.403439360525 (37.7802867481062, -122.403439360525)
113931 85753 DPW Maintained 3 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 900 Folsom St 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/07/2007 12:00:00 AM 3 3x3   6011609.0 2112176.0 37.78028674810621 -122.403439360525 (37.7802867481062, -122.403439360525)
119684 85754 DPW Maintained 3 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 900 Folsom St 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/07/2007 12:00:00 AM 3 3x3   6011609.0 2112176.0 37.78028674810621 -122.403439360525 (37.7802867481062, -122.403439360525)
122473 85748 DPW Maintained 3 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 900 Folsom St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/07/2007 12:00:00 AM 3 3x3   6011609.0 2112176.0 37.78028674810621 -122.403439360525 (37.7802867481062, -122.403439360525)
146319 85750 DPW Maintained 3 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 900 Folsom St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/07/2007 12:00:00 AM 3 3x3   6011609.0 2112176.0 37.78028674810621 -122.403439360525 (37.7802867481062, -122.403439360525)
104550 85745 DPW Maintained 3 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 880 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/07/2007 12:00:00 AM 6 3x3   6011737.0 2112298.0 37.7806288802706 -122.403005130314 (37.7806288802706, -122.403005130314)
145445 85742 DPW Maintained 3 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 816 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/07/2007 12:00:00 AM 3 3x3   6012158.0 2112700.0 37.7817561793381 -122.40157694342501 (37.7817561793381, -122.401576943425)
160833 120786 Undocumented 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 253 21st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   5989295.33642 2113646.62963 37.78305310452279 -122.480739452185 (37.7830531045228, -122.480739452185)
105914 12817 DPW Maintained 3 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 2140 Lake St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/23/2014 12:00:00 AM 2 5   5988770.65902 2114708.68477 37.7859386982185 -122.482632451333 (37.7859386982185, -122.482632451333)
22936 104688 Planning Code 138.1 required 4 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 2655 Bush St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000851.7 2114462.1 37.7859570793449 -122.440817776746 (37.7859570793449, -122.440817776746)
95999 122427 Planning Code 138.1 required 4 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 2655 Bush St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000851.7 2114462.1 37.7859570793449 -122.440817776746 (37.7859570793449, -122.440817776746)
97542 122425 Planning Code 138.1 required 4 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 2655 Bush St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000851.7 2114462.1 37.7859570793449 -122.440817776746 (37.7859570793449, -122.440817776746)
101883 122422 Planning Code 138.1 required 4 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 2655 Bush St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000851.7 2114462.1 37.7859570793449 -122.440817776746 (37.7859570793449, -122.440817776746)
114824 122426 Planning Code 138.1 required 4 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 2655 Bush St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000851.7 2114462.1 37.7859570793449 -122.440817776746 (37.7859570793449, -122.440817776746)
119670 122424 Planning Code 138.1 required 4 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 2655 Bush St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000851.7 2114462.1 37.7859570793449 -122.440817776746 (37.7859570793449, -122.440817776746)
139186 122423 Planning Code 138.1 required 4 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 2655 Bush St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000851.7 2114462.1 37.7859570793449 -122.440817776746 (37.7859570793449, -122.440817776746)
142253 122428 Planning Code 138.1 required 4 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 2655 Bush St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000851.7 2114462.1 37.7859570793449 -122.440817776746 (37.7859570793449, -122.440817776746)
3858 35488 Planning Code 138.1 required 4 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 2655 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/31/2016 12:00:00 AM 3   Permit Number 770253 6000772.5656 2114469.8149 37.7859737553806 -122.441092113094 (37.7859737553806, -122.441092113094)
8186 35487 Planning Code 138.1 required 4 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 2655 Bush St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000866.3431 2114483.9624 37.7860179417845 -122.440768684557 (37.7860179417845, -122.440768684557)
44188 101645 DPW Maintained 3 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 2609 Pine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/08/2013 12:00:00 AM   3x3   6001467.0 2114916.0 37.787238394783394 -122.438721548179 (37.7872383947834, -122.438721548179)
258 251259 Undocumented 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 1050x Sacramento St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6009753.0 2116795.0 37.7928655753561 -122.410186352148 (37.7928655753561, -122.410186352148)
44759 137064 Undocumented 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 2781 Filbert St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5999684.54965 2118419.7892299998 37.7967573134519 -122.44514041869199 (37.7967573134519, -122.445140418692)
104712 117585 Undocumented 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 3100X FILLMORE ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6002493.0 2118872.0 37.7981588656011 -122.435454914846 (37.7981588656011, -122.435454914846)
43013 137065 Undocumented 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 11 Filbert St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     6012521.25442 2120194.7201 37.8023551696124 -122.40084696071399 (37.8023551696124, -122.400846960714)
39767 137066 Undocumented 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 12 Filbert St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7     6012425.54206 2120223.78485 37.8024296352708 -122.401180217987 (37.8024296352708, -122.401180217987)

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 23.233ms · Data source: data.sfgov.org