home / trees

Street_Tree_List

Data source: data.sfgov.org

42 rows where qSiteInfo = 24

View and edit SQL

Suggested facets: qLegalStatus, qSpecies, qAddress, SiteOrder, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes, XCoord, YCoord, Latitude, Longitude, Location, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes, Neighborhoods

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
8973 110322 Undocumented 3 Tree(s) :: 13 1501x SHOTWELL ST 1 Unaccepted Street : Cutout 24 Tree 1 Private 2   05/15/2015 12:00:00 AM 3 3x3 Permit Number 775301 6008079.0 2099374.0 37.7449376155386 -122.41474504111099 (37.7449376155386, -122.414745041111) 2 7 7 28859 2
8974 110323 Undocumented 3 Tree(s) :: 13 1501x SHOTWELL ST 2 Unaccepted Street : Cutout 24 Tree 1 Private 2   05/15/2015 12:00:00 AM 3 3x3 Permit Number 775301 6008079.0 2099374.0 37.7449376155386 -122.41474504111099 (37.7449376155386, -122.414745041111) 2 7 7 28859 2
9226 110629 Undocumented 3 Pinus radiata :: Monterey Pine 1 1000X MANDALAY LN 1 Unaccepted Street : Cutout 24 Tree 1 Private 2           5991616.0 2101838.0 37.75076437998511 -122.47185008331101 (37.7507643799851, -122.471850083311) 1 8 4 29491 12
9228 110630 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 1050X MANDALAY LN 1 Unaccepted Street : Cutout 24 Tree 1 Private 2           5991857.0 2101850.0 37.7508112705894 -122.47101756601101 (37.7508112705894, -122.471017566011) 1 8 4 29491 12
9229 110631 Undocumented 3 Tree(s) :: 13 1001X Mandalay Ln   Unaccepted Street : Cutout 24 Tree 1 Private 2           5991736.200759999 2101819.33429 37.7507200830769 -122.47143306251002 (37.7507200830769, -122.47143306251) 1 8 4 29491 12
9230 110632 Undocumented 3 Tree(s) :: 13 1051X Mandalay Ln 1 Unaccepted Street : Cutout 24 Tree 1 Private 2           5991736.200759999 2101819.33429 37.7507200830769 -122.47143306251002 (37.7507200830769, -122.47143306251) 1 8 4 29491 12
9246 110647 Undocumented 3 Pittosporum spp :: Pittosporum spp 219 300x NAGLEE AVE 1 Unaccepted Street : Cutout 24 Tree 1 Private 2     12 3x3   5997872.0 2088397.0 37.7142185912398 -122.449248128432 (37.7142185912398, -122.449248128432) 9 7 6 28861 25
10398 111914 Undocumented 3 Pinus radiata :: Monterey Pine 1 60 LOWER TER 1 Unaccepted Street : Cutout 24 Tree 1 Private 2     28 3x3   6000264.0 2106046.0 37.7628151124003 -122.442246670025 (37.7628151124003, -122.442246670025) 15 5 5 28862 3
11223 112789 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 23x Joice St 1 Unaccepted Street : Cutout 24 Tree 1 Private 2     8 3x3   6010300.14411 2116243.45137 37.7913818092657 -122.408254279811 (37.7913818092657, -122.408254279811) 5 1 10 28857 21
11224 112790 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 110 20 Joice St 1 Unaccepted Street : Cutout 24 Tree 1 Private 2     11 3x3   6010307.8181300005 2116296.03331 37.791526616311295 -122.40823143793502 (37.7915266163113, -122.408231437935) 5 1 10 28857 21
11225 112791 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 23x Joice St 2 Unaccepted Street : Cutout 24 Tree 1 Private 2     7     6010302.18584 2116235.66689 37.791360549286104 -122.408246666156 (37.7913605492861, -122.408246666156) 5 1 10 28857 21
11226 112792 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 23x Joice St 3 Unaccepted Street : Cutout 24 Tree 1 Private 2     5     6010303.89255 2116225.84414 37.7913336739481 -122.40824006785101 (37.7913336739481, -122.408240067851) 5 1 10 28857 21
11227 112793 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 23x Joice St 4 Unaccepted Street : Cutout 24 Tree 1 Private 2     8     6010304.6147 2116218.08658 37.7913124139936 -122.40823702184099 (37.7913124139936, -122.408237021841) 5 1 10 28857 21
11228 112794 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 21x JOICE ST 5 Unaccepted Street : Cutout 24 Tree 1 Private 2           6010276.0 2116206.0 37.7912776248382 -122.40833517558599 (37.7912776248382, -122.408335175586) 5 1 10 28857 21
12580 114271 Undocumented 3 Pinus halepensis :: Allepo Pine 78 49x ESMERALDA AVE 1 Unaccepted Street : Cutout 24 Tree 1 Private 2     27 3x3   6006783.0 2099038.0 37.7439421324692 -122.41920255172501 (37.7439421324692, -122.419202551725) 2 7 7 28859 2
13019 114768 Undocumented 3 Pinus radiata :: Monterey Pine 1 155X Bronte St 1 Unaccepted Street : Cutout 24 Tree 1 Private 2     12     6009330.8 2096609.5 37.737417155901 -122.410221383029 (37.737417155901, -122.410221383029) 10 7 7 28859 2
14940 116778 Undocumented 3 Pinus radiata :: Monterey Pine 1 398x GAVEN ST 1 Unaccepted Street : Cutout 24 Tree 1 Private 2     30 3x3   6008462.0 2094745.0 37.732248905538704 -122.41309344179899 (37.7322489055387, -122.413093441799) 9 3 7 309 28
15213 117063 Undocumented 3 Aesculus californica :: California Buckeye 188 229 MONTCALM ST 1 Unaccepted Street : Cutout 24 Tree 1 Private 2       3x3   6009811.0 2099554.0 37.7455290185947 -122.40876877231001 (37.7455290185947, -122.40876877231) 2 7 7 28859 2
15222 117071 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 10 JOY ST 1 Unaccepted Street : Cutout 24 Tree 1 Private 2       3x3   6010420.0 2098909.0 37.7437920807055 -122.406617489968 (37.7437920807055, -122.406617489968) 2 7 7 28859 2
15624 117472 Undocumented 3 Populus nigra 'Italica' :: Lombardy Poplar 184 1201x MONTGOMERY ST 2 Unaccepted Street : Cutout 24 Tree 1 Private 2           6011733.0 2119731.0 37.8010379082809 -122.403542078239 (37.8010379082809, -122.403542078239) 3 1 10 308 23
15625 117473 Undocumented 3 Populus nigra 'Italica' :: Lombardy Poplar 184 1201x MONTGOMERY ST 1 Unaccepted Street : Cutout 24 Tree 1 Private 2           6011733.0 2119731.0 37.8010379082809 -122.403542078239 (37.8010379082809, -122.403542078239) 3 1 10 308 23
15626 117474 Undocumented 3 Populus nigra 'Italica' :: Lombardy Poplar 184 1200x MONTGOMERY ST 1 Unaccepted Street : Cutout 24 Tree 1 Private 2           6011580.0 2119440.0 37.800230345698 -122.404051036068 (37.800230345698, -122.404051036068) 3 1 10 308 23
15627 117475 Undocumented 3 Populus nigra 'Italica' :: Lombardy Poplar 184 1200x MONTGOMERY ST 2 Unaccepted Street : Cutout 24 Tree 1 Private 2           6011580.0 2119440.0 37.800230345698 -122.404051036068 (37.800230345698, -122.404051036068) 3 1 10 308 23
18382 120968 Undocumented 3 Eucalyptus sideroxylon :: Red Ironbark 117 79x Bradford St 1 Unaccepted Street : Cutout 24 Tree 1 Private 2     30 3x3   6009615.0 2098188.0 37.7417673011584 -122.409350130422 (37.7417673011584, -122.409350130422) 10 7 7 28859 2
18619 121204 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 206 44 MacOndray Ln 1 Unaccepted Street : Cutout 24 Tree 1 Private 2     52     6008473.20212 2119153.5676 37.799269800719294 -122.41478152415002 (37.7992698007193, -122.41478152415) 5 1 10 308 32
19202 121792 Undocumented 3 Pinus radiata :: Monterey Pine 1 2556 Broderick St 1 Unaccepted Street : Cutout 24 Tree 1 Private 2       3x3   6000243.0 2117343.0 37.7938325936105 -122.443130684772 (37.7938325936105, -122.443130684772) 13 9 1 57 27
123190 251807 DPW Maintained 1 Crateagus spp :: Hawthorn 286 2 Hangah St 1 Unaccepted Street : Cutout 24 Tree 1 DPW for City Agency 5 Rec/Park 5     3x3   6010544.0 2117119.0 37.7937995065594 -122.40747229387699 (37.7937995065594, -122.407472293877) 3 1 10 28857 4
123191 251809 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 2 Hangah St 2 Unaccepted Street : Cutout 24 Tree 1 DPW for City Agency 5 Rec/Park 5     3x3   6010544.0 2117119.0 37.7937995065594 -122.40747229387699 (37.7937995065594, -122.407472293877) 3 1 10 28857 4
123193 251810 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 2 Hangah St 3 Unaccepted Street : Cutout 24 Tree 1 DPW for City Agency 5 Rec/Park 5     3x3   6010544.0 2117119.0 37.7937995065594 -122.40747229387699 (37.7937995065594, -122.407472293877) 3 1 10 28857 4
123194 251811 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 2 Hangah St 4 Unaccepted Street : Cutout 24 Tree 1 DPW for City Agency 5 Rec/Park 5     3x3   6010544.0 2117119.0 37.7937995065594 -122.40747229387699 (37.7937995065594, -122.407472293877) 3 1 10 28857 4
123195 251813 DPW Maintained 1 Crateagus spp :: Hawthorn 286 2 Hangah St 6 Unaccepted Street : Cutout 24 Tree 1 DPW for City Agency 5 Rec/Park 5     3x3   6010544.0 2117119.0 37.7937995065594 -122.40747229387699 (37.7937995065594, -122.407472293877) 3 1 10 28857 4
124271 254235 Planning Code 138.1 required 8 Syzygium australe :: Eugenia 367 454 Ralston St 1 Unaccepted Street : Cutout 24 Tree 1 Private 2       10x10   5992261.0 2090872.0 37.7206918008503 -122.468821743954 (37.7206918008503, -122.468821743954) 9 8 6 64 24
125517 256139 Undocumented 3 Eucalyptus globulus :: Blue Gum 206 888 Moultrie St 1 Unaccepted Street : Cutout 24 Tree 1 Private 2       3x3   6007515.0 2095179.0 37.7333873668614 -122.416398174089 (37.7333873668614, -122.416398174089) 2 7 7 28859 2
126240 257930 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 114 1000X Hudson Ave   Unaccepted Street : Cutout 24 Tree 1 DPW 1       3x3   6018755.0 2095128.0 37.7338730033489 -122.37753437914101 (37.7338730033489, -122.377534379141) 10 3 8 58 1
188044 96173 Permitted Site 2 Sequoia sempervirens :: Coast Redwood 157     Unaccepted Street : Cutout 24 Tree 1 Private 2   04/04/2011 12:00:00 AM   3x3 Permit Number 767806                    
188045 96174 Permitted Site 2 Malus sylvestris :: Apple 141     Unaccepted Street : Cutout 24 Tree 1 Private 2   04/04/2011 12:00:00 AM   3x3 Permit Number 767807                    
188046 96175 Permitted Site 2 Malus sylvestris :: Apple 141     Unaccepted Street : Cutout 24 Tree 1 Private 2   04/04/2011 12:00:00 AM   3x3 Permit Number 767808                    
188047 96176 Permitted Site 2 Prunus domestica 'Santa Rosa' :: Santa Rosa Plum 523     Unaccepted Street : Cutout 24 Tree 1 Private 2   04/04/2011 12:00:00 AM   3x3 Permit Number 767809                    
188048 96177 Permitted Site 2 Diospyros kaki :: Persimmon 278     Unaccepted Street : Cutout 24 Tree 1 Private 2   04/04/2011 12:00:00 AM   3x3 Permit Number 767810                    
188049 96178 Permitted Site 2 Citrus aurantifolia 'Bearss' :: Seedless Lime 354     Unaccepted Street : Cutout 24 Tree 1 Private 2   04/04/2011 12:00:00 AM   3x3 Permit Number 767810                    
188050 96179 Permitted Site 2 Prunus domestica 'Santa Rosa' :: Santa Rosa Plum 523     Unaccepted Street : Cutout 24 Tree 1 Private 2       3x3 Permit Number 767811                    
188052 96180 Permitted Site 2 Prunus domestica 'Santa Rosa' :: Santa Rosa Plum 523     Unaccepted Street : Cutout 24 Tree 1 Private 2   04/04/2011 12:00:00 AM   3x3 Permit Number 767812                    

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" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 22.134ms · Data source: data.sfgov.org