Street_Tree_List

Data source: data.sfgov.org

102 rows where SiteOrder = 37

View and edit SQL

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
501 251171 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 201X Cargo Way 37 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/10/2017 11:21:00 AM 3              
1132 188688 DPW Maintained 3 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 1300 Evans Ave 37 : 4 Tree 1 DPW 2   03/18/2017 02:16:00 PM 3 Width 4ft   6017441.41972 2097257.16832 37.739646816543996 -122.382223941884 (37.739646816544, -122.382223941884)
3134 44852 Permitted Site 1 Tree(s) :: 17   37 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
5023 3601 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 37 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   04/10/2017 10:11:00 AM 3 3X3   6018206.00756 2098069.0742900004 37.7419183484432 -122.379636687689 (37.7419183484432, -122.379636687689)
6103 44532 Permitted Site 1 Tree(s) :: 17   37 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
9353 12157 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 1400X La Salle Ave 37 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6016176.76201 2095719.00601 37.73535340295211 -122.386489403775 (37.7353534029521, -122.386489403775)
9567 48195 Permitted Site 1 Tree(s) :: 17   37 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
9599 45926 Permitted Site 1 Tree(s) :: 17   37 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
10003 173619 Undocumented 2 Pinus radiata :: Monterey Pine 3 1200X JUNIPERO SERRA BLVD 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1   01/20/2017 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
10720 19638 DPW Maintained 3 Pinus Spp :: Pine Spp 105 100 STAIRWAY5 37 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 30            
13156 20391 DPW Maintained 3 Eucalyptus Spp :: Eucalyptus 40 262X Sunset Blvd 37 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 60            
14592 51137 Permitted Site 1 Koelreuteria paniculata :: Golden Rain Tree 56 420@ 6TH ST Berry St 37 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/27/2004 12:00:00 AM     Permit Number 47557 6013008.01748439 2109097.62504611 37.7719122726701 -122.398383421945 (37.7719122726701, -122.398383421945)
16472 11547 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 101X Jennings St 37 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6018868.04549 2097199.54045 37.7395672742039 -122.377287229525 (37.7395672742039, -122.377287229525)
16519 3732 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 401X Cargo Way 37 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6017092.791180001 2098843.12861 37.7439822808577 -122.383539742673 (37.7439822808577, -122.383539742673)
19129 12492 Permitted Site 1 Eucalyptus Spp :: Eucalyptus 40 307 Lake Merced Blvd 37 Sidewalk: Curb side : Cutout 1 Tree 1 PUC 13     36 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
21425 11754 DPW Maintained 3 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700X Junipero Serra Blvd 37 Median : Cutout 11 Tree 1 DPW 2   03/09/2013 12:00:00 AM 3 6X6   5991270.92454 2092589.2026099998 37.725349564621204 -122.472369212969 (37.7253495646212, -122.472369212969)
25644 126371 DPW Maintained 3 Cotoneaster SPP :: Cotoneaster 234 1306x Montgomery St 37 Median : Yard 3 Tree 1 DPW 2     4 Width 8ft   6011427.3089 2120158.66 37.8021950785935 -122.404630029046 (37.8021950785935, -122.404630029046)
27943 201789 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 724 Jamestown Ave 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 8ft   6015483.8795300005 2088094.9602400002 37.7143809005356 -122.388353026664 (37.7143809005356, -122.388353026664)
29248 187101 Undocumented 2 Melaleuca styphelliodes :: Paperbark Tree 239 2600 Sunset Blvd 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 0ft   5985154.9931 2097213.6802 37.7376912868614 -122.49385174405501 (37.7376912868614, -122.493851744055)
29281 186449 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1601 Sunset Blvd 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984739.2681 2103899.1733 37.7560234949851 -122.49578209696301 (37.7560234949851, -122.495782096963)
29985 193072 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 1601 Evans Ave 37 : 4 Tree 1 Private 1     3 Width 4ft   6015318.00876 2098725.46335 37.7435609430974 -122.38966837242201 (37.7435609430974, -122.389668372422)
31743 249705 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2400 Baker St 37 Front Yard : Yard 7 Tree 1 Private 1     23     5999691.230359999 2117200.88619 37.793410910039896 -122.44502963123101 (37.7934109100399, -122.445029631231)
32582 181404 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1500 Sunset Blvd 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     21 Width 0ft   5984893.3996 2104690.5846 37.7582055161201 -122.49530742906799 (37.7582055161201, -122.495307429068)
33033 223700 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1100 San Jose Ave 37 Front Yard : Yard 7 Tree 1 Private 1     32     6004786.16622 2096652.60405 37.7372797190785 -122.42593738210199 (37.7372797190785, -122.425937382102)
34150 211157 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 300x Marietta Dr 37 Median : Cutout 11 Tree 1 DPW 2     16 Width 5ft   5999448.78231 2097518.60545 37.7393544676471 -122.444453333051 (37.7393544676471, -122.444453333051)
35608 194288 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700x Quesada Ave 37 Median : Yard 3 Tree 1 DPW 2     34     6014411.93404 2095259.01392 37.733992504551296 -122.392558950849 (37.7339925045513, -122.392558950849)
36196 250612 Undocumented 2 Cupressocyparis leylandii :: Leyland Cypress 34 2201 Golden Gate Ave 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     32 Width 7ft   5998863.03763 2111421.5701099997 37.7774951176523 -122.447479040039 (37.7774951176523, -122.447479040039)
36731 220173 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1101 San Jose Ave 37 Front Yard : Yard 7 Tree 1 Private 1     16     6004965.33197 2096549.91203 37.737007873798596 -122.42531061759199 (37.7370078737986, -122.425310617592)
37997 249753 Undocumented 2 Juniperus chinensis :: Juniper 19 2500 Broderick St 37 : 4 Tree 1 Private 1     7 Width 1ft   6000238.5689199995 2117223.4057 37.793503966475 -122.44313742344801 (37.793503966475, -122.443137423448)
38738 125682 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 900 Green St 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 5ft   6008560.62871 2119023.68152 37.798918077657 -122.41446980113899 (37.798918077657, -122.414469801139)
39928 186152 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1700 Sunset Blvd 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     28 Width 0ft   5984960.1712 2103307.566 37.754412039318 -122.494974531355 (37.754412039318, -122.494974531355)
41377 228981 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 1300 San Jose Ave 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7     6003423.97246 2095615.4048 37.73435472807571 -122.430573123757 (37.7343547280757, -122.430573123757)
42536 176390 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 700x Mansell St 37 Median : Cutout 11 Tree 1 DPW 2     21 Width 0ft   6009150.9462 2089957.5754799999 37.7191423008581 -122.410373676998 (37.7191423008581, -122.410373676998)
45936 184776 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1301 Sunset Blvd 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984696.9053 2105942.9168 37.7616325639121 -122.49607937246901 (37.7616325639121, -122.496079372469)
46912 185894 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2000 Sunset Blvd 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     40 Width 0ft   5985020.8519 2101190.1004 37.748601612070004 -122.49460859166 (37.74860161207, -122.49460859166)
47273 10756 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1120X Hudson Ave 37 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
47799 186770 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1200 Sunset Blvd 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 0ft   5984865.2362 2106764.1427 37.763897278132 -122.49555776597 (37.763897278132, -122.49555776597)
55153 186370 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1801 Sunset Blvd 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984810.6867 2102537.171 37.7522879951786 -122.49543466483601 (37.7522879951786, -122.495434664836)
56595 211131 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 335x Pacheco St 37 Median : Yard 3 Tree 1 DPW 2     5 Width 8ft   5994094.61365 2101539.2804900003 37.7500872773246 -122.463257210957 (37.7500872773246, -122.463257210957)
57544 191973 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1322 Hudson Ave 37 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 3ft   6017413.418380001 2095064.5219 37.7336246998239 -122.382168264862 (37.7336246998239, -122.382168264862)
59344 185312 Undocumented 2 Shrub :: Shrub 98 2601 Sunset Blvd 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984965.1696 2097238.5346 37.737748422490604 -122.494509877006 (37.7377484224906, -122.494509877006)
60561 189226 Undocumented 2 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 101 Pennsylvania Ave 37 Front Yard : Yard 7 Tree 1 Private 1     1     6014251.36443 2106690.81124 37.765372877885106 -122.393914054695 (37.7653728778851, -122.393914054695)
61777 206452 Undocumented 2 Cotoneaster SPP :: Cotoneaster 234 500 Junipero Serra Blvd 37 : 4 Tree 1 Private 1     12 Width 0ft   5991336.42216 2093557.70772 37.7280126289541 -122.472213362281 (37.7280126289541, -122.472213362281)
62029 142422 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 10 MAYFAIR DR 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 0ft   5997618.0335 2114520.9492 37.7859339729155 -122.452009568816 (37.7859339729155, -122.452009568816)
67666 185656 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2100 Sunset Blvd 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 0ft   5985042.305 2100549.4408 37.746843791076 -122.49448718724301 (37.746843791076, -122.494487187243)
67761 206306 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 500x Junipero Serra Blvd 37 Median : Cutout 11 Tree 1 DPW 2     5 Width 0ft   5991444.74092 2094236.6421299998 37.7298830812226 -122.471888366154 (37.7298830812226, -122.471888366154)
67982 181559 Undocumented 2 Pinus radiata :: Monterey Pine 3 1300 Sunset Blvd 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 0ft   5984856.3619 2106074.0712 37.7620020156588 -122.49553755883801 (37.7620020156588, -122.495537558838)
68524 187352 Undocumented 2 Ilex aquifolium :: European Holly 277 2200 Sunset Blvd 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5985089.5104 2099749.8522 37.744651100545 -122.49426503067 (37.744651100545, -122.49426503067)
69239 191385 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 800 Vermont St 37 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   6011271.65755 2104161.44484 37.7582617567794 -122.404042206986 (37.7582617567794, -122.404042206986)
69723 185553 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2201 Sunset Blvd 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984885.8095 2099839.3869 37.744885015964705 -122.49497597852199 (37.7448850159647, -122.494975978522)
72034 197843 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 6ft   6011998.75435 2091272.95857 37.722913307489 -122.40062218776899 (37.722913307489, -122.400622187769)
76287 189388 Undocumented 2 Cordyline australis :: Dracena Palm 141 1190 Fairfax Ave 37 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6017704.60452 2096656.13327 37.738011027092796 -122.381272171384 (37.7380110270928, -122.381272171384)
97787 25873 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 800X The Embarcadero 37 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   10/30/1995 12:00:00 AM 6 4X4   6012698.46901 2120014.53101 37.8018702969661 -122.40022104474899 (37.8018702969661, -122.400221044749)
98774 3527 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 201X Cargo Way 37 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/07/2006 12:00:00 AM 3 3X3   6016626.76696 2099218.04074 37.7449859443431 -122.38517728139 (37.7449859443431, -122.38517728139)
103186 99154 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 302X Pacheco St 37 Median : Cutout 11 Tree 1 Private 1     9     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
112227 93354 DPW Maintained 3 Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 449 2100X Turk Blvd 37 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/21/2008 12:00:00 AM 3 3x3   5999954.2 2112061.6 37.779314771487996 -122.44375035157302 (37.779314771488, -122.443750351573)
113461 111447 Permitted Site 1 Quercus agrifolia :: Coast Live Oak 180 241 Oneida Ave 37 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 SFUSD 6         5999776.65760108 2091115.95638647 37.72179298789 -122.442860041334 (37.72179298789, -122.442860041334)
129906 186226 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1701 Sunset Blvd 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984811.8118 2103374.3628 37.7545867587784 -122.49549251499501 (37.7545867587784, -122.495492514995)
131940 187018 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2501 Sunset Blvd 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     64 Width 0ft   5984958.1911 2097916.1040000003 37.739608437718395 -122.494583941282 (37.7396084377184, -122.494583941282)
137795 187254 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 2401 Sunset Blvd 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 0ft   5984957.2356 2098455.4733 37.7410893446535 -122.494626998091 (37.7410893446535, -122.494626998091)
138214 191589 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 750 Phelps St 37 : 4 Tree 1 Private 1     4 Width 2ft   6015171.71316 2097880.19375 37.7412318941435 -122.390115192457 (37.7412318941435, -122.390115192457)
142018 39020 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 2701X Mariposa St 37 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/18/1998 12:00:00 AM     Permit Number 40772 6009326.637 2105908.456 37.7629497877468 -122.410892350936 (37.7629497877468, -122.410892350936)
146629 185706 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2101 Sunset Blvd 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     39 Width 0ft   5984860.1074 2100483.4684 37.746651983887794 -122.49511233597401 (37.7466519838878, -122.495112335974)
146842 186566 Undocumented 2 Cordyline australis :: Dracena Palm 141 1501 Sunset Blvd 37 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5984742.1992 2104682.6054 37.7581747535408 -122.49582974929 (37.7581747535408, -122.49582974929)
149845 184918 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 1990 41st Ave 37 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5983532.5797 2102094.6082 37.7509979199961 -122.49982178293399 (37.7509979199961, -122.499821782934)
151848 184848 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1201 Sunset Blvd 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 0ft   5984690.0704 2106845.3199 37.764109909126205 -122.496169592258 (37.7641099091262, -122.496169592258)
154852 202245 Undocumented 2 Melaleuca quinquenervia :: Cajeput 50 1 Kalmanovitz St 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 2ft   6013200.83525 2093230.7571400001 37.728355994623996 -122.396603988992 (37.728355994624, -122.396603988992)
156986 186042 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1900 Sunset Blvd 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     45 Width 0ft   5984981.8854 2102165.144 37.7512765340519 -122.49481521448 (37.7512765340519, -122.49481521448)
157793 185109 Undocumented 2 Pinus radiata :: Monterey Pine 3 2801 Sunset Blvd 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 0ft   5985034.9918 2095922.7999 37.734139852548 -122.494171522442 (37.734139852548, -122.494171522442)
158043 187175 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2301 Sunset Blvd 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984938.908 2099248.7285 37.743266336375896 -122.494748837407 (37.7432663363759, -122.494748837407)
158230 180067 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 1900x Alemany Blvd 37 Median : Cutout 11 Tree 1 DPW 2     2 Width 2ft   6000510.614080001 2090253.83095 37.7194676036275 -122.440261155949 (37.7194676036275, -122.440261155949)
158532 205332 DPW Maintained 3 Cordyline australis :: Dracena Palm 141 1x Minerva St 37 Median : Cutout 11 Tree 1 DPW 2     12 Width 0ft   5996356.8338 2088999.78722 37.7157869222184 -122.454528620522 (37.7157869222184, -122.454528620522)
160853 204711 DPW Maintained 3 Ceanothus Sps :: California lilac 270 400x Marietta Dr 37 Median : Cutout 11 Tree 1 DPW 2     5 Width 3ft   5999138.58947 2096999.87001 37.737912439812796 -122.445488548067 (37.7379124398128, -122.445488548067)
163818 197194 Undocumented 2 Quercus agrifolia :: Coast Live Oak 180 602 Arthur Ave 37 Front Yard : Yard 7 Tree 1 Private 1     12     6015675.196819999 2099860.1770900004 37.746696432096 -122.388512480964 (37.746696432096, -122.388512480964)
164196 185484 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 2400 Sunset Blvd 37 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5985117.0889 2098499.1184 37.741218537266796 -122.494077507295 (37.7412185372668, -122.494077507295)
164264 219590 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1201 San Jose Ave 37 Front Yard : Yard 7 Tree 1 Private 1     1     6004431.32479 2096032.9751400002 37.7355582979675 -122.42712011110399 (37.7355582979675, -122.427120111104)
164583 186680 Undocumented 2 Pinus radiata :: Monterey Pine 3 1401 Sunset Blvd 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     46 Width 0ft   5984729.4281 2105398.2043 37.760138840627796 -122.495926705976 (37.7601388406278, -122.495926705976)
165210 180469 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 599 University St 37 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6008151.81482 2092695.5003099998 37.726604001951706 -122.414020889251 (37.7266040019517, -122.414020889251)
167160 137618 Undocumented 2 Fraxinus americana :: American Ash 23 2000 TURK BLVD 37 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5999494.1594 2111936.8449 37.778945976017795 -122.445332845737 (37.7789459760178, -122.445332845737)
167193 185978 Undocumented 2 Pinus radiata :: Monterey Pine 3 2001 Sunset Blvd 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 0ft   5984834.9358 2101095.1072 37.7483299034009 -122.495244473331 (37.7483299034009, -122.495244473331)
167602 185011 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 2701 Sunset Blvd 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985034.3637 2096468.1875 37.7356373047826 -122.49421387938601 (37.7356373047826, -122.494213879386)
167996 186482 Undocumented 2 Myoporum laetum :: Myoporum 1 1400 Lower Great Hwy 37 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5980889.9955 2105407.5862 37.7599389849374 -122.50920593411199 (37.7599389849374, -122.509205934112)
168424 179756 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 201 Trumbull St 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 4ft   6004864.308119999 2094360.1184200002 37.7309894829744 -122.42550410583401 (37.7309894829744, -122.425504105834)
169172 200560 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1400x La Salle Ave 37 Median : Cutout 11 Tree 1 DPW 2     13 Width 0ft   6016311.7963 2095496.5134 37.7347499571366 -122.38600703115401 (37.7347499571366, -122.386007031154)
169299 191042 Undocumented 2 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 1301 Minnesota St 37 Front Yard : Yard 7 Tree 1 Private 1     6     6015379.59979 2102513.14016 37.7539645262576 -122.38971990086701 (37.7539645262576, -122.389719900867)
174081 186091 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1901 Sunset Blvd 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984808.6672 2101798.457 37.7502595713091 -122.49538717298401 (37.7502595713091, -122.495387172984)
175436 204152 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 900 Junipero Serra Blvd 37 : 4 Tree 1 Private 1     1 Width 0ft   5991169.92245 2090751.38969 37.7202975393725 -122.472584434247 (37.7202975393725, -122.472584434247)
177017 185421 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2300 Sunset Blvd 37 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5985094.1378 2099288.8619999997 37.7433856170495 -122.494215058601 (37.7433856170495, -122.494215058601)
177467 184037 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1600 Sunset Blvd 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984932.8309 2103810.0952 37.7557902450486 -122.49510613395901 (37.7557902450486, -122.495106133959)
177994 211394 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 300 Junipero Serra Blvd 37 : 4 Tree 1 Private 1     7 Width 0ft   5991385.475930001 2094405.95622 37.7303445458499 -122.47210558662701 (37.7303445458499, -122.472105586627)
178220 199651 Undocumented 2 :: 54 0 37 : 4 Tree 1 Private 1     0 Width 0ft   6018297.01834 2097895.80454 37.7414476037323 -122.37930996579901 (37.7414476037323, -122.379309965799)
178239 181477 Undocumented 2 Pinus radiata :: Monterey Pine 3 1400 Sunset Blvd 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 0ft   5984869.4504 2105294.0498 37.759861061253794 -122.495434760928 (37.7598610612538, -122.495434760928)
178398 135079 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1401 The Embarcadero 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7     6010377.54006 2122303.65444 37.808025975171105 -122.40841414062 (37.8080259751711, -122.40841414062)
180024 229767 Undocumented 2 Jacaranda mimosifolia :: Jacaranda 52 1201 Vermont St 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 4ft   6011451.55336 2102410.70185 37.7534646524788 -122.40329688663799 (37.7534646524788, -122.403296886638)
180177 211656 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 200x Terrace Dr 37 Median : Yard 3 Tree 1 DPW 2     15     5993885.28493 2096476.0493 37.7361728559925 -122.463613650077 (37.7361728559925, -122.463613650077)
182248 232293 Undocumented 2 Myoporum laetum :: Myoporum 1 200 Eugenia Ave 37 Front Yard : Yard 7 Tree 1 Private 1     17     6006572.50895 2098130.46557 37.741438390175205 -122.41986599782301 (37.7414383901752, -122.419865997823)
182952 205103 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 800x Junipero Serra Blvd 37 Median : Cutout 11 Tree 1 DPW 2     4 Width 0ft   5991326.973119999 2092437.01185 37.724934930379206 -122.47216437168899 (37.7249349303792, -122.472164371689)
183770 185185 Undocumented 2 Pinus radiata :: Monterey Pine 3 2500 Sunset Blvd 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     33 Width 0ft   5985131.3657 2097848.0278 37.739431652929895 -122.493980171096 (37.7394316529299, -122.493980171096)
185004 186299 Undocumented 2 Olea europaea :: Olive Tree 41 1800 Sunset Blvd 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5985021.1385 2102711.497 37.7527789669048 -122.49471975093701 (37.7527789669048, -122.494719750937)
185459 241144 Undocumented 2 Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 310 Liberty St 37 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   6003932.042169999 2103938.25616 37.7572361204712 -122.42940988577699 (37.7572361204712, -122.429409885777)

Next page

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