Street_Tree_List

Data source: data.sfgov.org

711 rows where qSpecies = 36 sorted by rowid descending

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant

Link rowid ▲ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
188809 246135 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1556 Waller St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     30 Width 0ft   5998164.5983 2108256.0986 37.7687636084249 -122.449666999674 (37.7687636084249, -122.449666999674)
188666 224021 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1300 San Jose Ave 20 Front Yard : Yard 7 Tree 1 Private 1     22     6003548.3510300005 2095664.8984299998 37.734497671711296 -122.430146636467 (37.7344976717113, -122.430146636467)
188514 141287 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1855 ELLIS ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     27 Width 0ft   6001856.4282 2112885.6951 37.7816858418255 -122.43722878495701 (37.7816858418255, -122.437228784957)
188255 224438 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 177 Powhattan Ave 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17 Width 3ft   6008219.66372 2098116.4731099997 37.7414926273921 -122.414169698278 (37.7414926273921, -122.414169698278)
188187 250125 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1730 Pine St 1 : 4 Tree 1 Private 1     25 Width 4ft   6005649.1110000005 2115549.12657 37.7892138324921 -122.424297370338 (37.7892138324921, -122.424297370338)
188093 224447 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 40 Fillmore St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6003872.78638 2108597.53578 37.770026027713 -122.42994716323 (37.770026027713, -122.42994716323)
187755 199379 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 200 Jennings St 17 : 4 Tree 1 Private 1     14 Width 3ft   6018388.0029 2096644.9074400002 37.738017905995896 -122.378908520106 (37.7380179059959, -122.378908520106)
187560 224032 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 149 Prentiss St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     23 Width 2ft   6008847.93319 2097848.3204900003 37.7407916085566 -122.411978404795 (37.7407916085566, -122.411978404795)
187175 246156 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 658 Cole St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 0ft   5997926.8774 2108272.4514 37.7687949060021 -122.450490433762 (37.7687949060021, -122.450490433762)
187024 248372 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1609 Waller St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 0ft   5997820.1302 2108164.6442 37.768492784741895 -122.450851888359 (37.7684927847419, -122.450851888359)
186929 199392 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1199 Ingalls St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 Width 3ft   6018085.49835 2093997.2932900002 37.730731395525396 -122.379770541 (37.7307313955254, -122.379770541)
185697 138647 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 600 PRESIDIO AVE 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 0ft   5999215.4534 2114556.1413 37.786121970664894 -122.44648548868099 (37.7861219706649, -122.446485488681)
185210 199369 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1500 Michigan St 4 : 4 Tree 1 Private 1     13 Width 3ft   6016517.96989 2101024.03295 37.74993880734289 -122.38567933235201 (37.7499388073429, -122.385679332352)
184969 137848 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1900 Pine St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 0ft   6004770.9565 2115424.5161 37.7888220583291 -122.42732679883301 (37.7888220583291, -122.427326798833)
184177 102292 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 801 Cesar Chavez St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 3x3   6016451.98974 2101145.15055 37.750267719991605 -122.38591593857099 (37.7502677199916, -122.385915938571)
183607 250103 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1634 Pine St 2 : 4 Tree 1 Private 1     2 Width 4ft   6006023.8446 2115600.71368 37.7893766304877 -122.423004504073 (37.7893766304877, -122.423004504073)
183400 224013 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1000 San Jose Ave 86 Front Yard : Yard 7 Tree 1 Private 1     16     6005014.2312 2096961.20623 37.738139957502796 -122.42517080809601 (37.7381399575028, -122.425170808096)
183147 66382 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 661 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/04/1991 12:00:00 AM 12   Permit Number 29508 6003420.5252 2110677.1492 37.7757105120941 -122.431660023451 (37.7757105120941, -122.431660023451)
182494 206282 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 201 Elk St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 2ft   6000786.60453 2095932.3655299998 37.7350752667125 -122.43971405517901 (37.7350752667125, -122.439714055179)
182167 199388 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1333 Hudson Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 Width 3ft   6017834.132540001 2094632.9776599999 37.73246299156 -122.380683731476 (37.73246299156, -122.380683731476)
181793 206291 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 500x Junipero Serra Blvd 38 Median : Cutout 11 Tree 1 DPW 2     7 Width 0ft   5991445.95006 2094262.4550299998 37.7299540269465 -122.471886066612 (37.7299540269465, -122.471886066612)
181489 247933 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1099 Esmeralda Ave 6 Side Yard : Yard 17 Tree 1 Private 1     25     6010316.772530001 2098765.05298 37.7433910575536 -122.40696428417601 (37.7433910575536, -122.406964284176)
181459 206298 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 74 Vista Verde Ct 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     24 Width 3ft   5999168.51536 2096155.83752 37.735596635183605 -122.445324411018 (37.7355966351836, -122.445324411018)
181384 102291 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 801 Cesar Chavez St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 3x3   6016420.3361599995 2101143.32913 37.7502609669785 -122.38602527277399 (37.7502609669785, -122.386025272774)
181295 247092 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 2301 Castro St 10 Front Yard : Yard 7 Tree 1 Private 1     3     6002754.09625 2098614.08678 37.742550445936395 -122.43310328180901 (37.7425504459364, -122.433103281809)
180713 244109 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1890 Page St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 0ft   5997547.3781 2108866.1758 37.770403393000606 -122.45184592528099 (37.7704033930006, -122.451845925281)
180081 224015 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1000 San Jose Ave 89 Front Yard : Yard 7 Tree 1 Private 1     21     6005001.605909999 2096940.71634 37.7380829836485 -122.42521300248801 (37.7380829836485, -122.425213002488)
178619 182752 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1790 31st Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 0ft   5986608.9591 2103091.7966 37.7539159776066 -122.48925681152599 (37.7539159776066, -122.489256811526)
178608 137847 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1900 Pine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 0ft   6004787.7852 2115427.8819 37.7888322517036 -122.427268813718 (37.7888322517036, -122.427268813718)
178569 176383 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 199 Peninsula Ave 1 Front Yard : Yard 7 Tree 1 Private 1     17     6012515.53938 2087594.1826400002 37.7128409356448 -122.39857773288799 (37.7128409356448, -122.398577732888)
178257 247074 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 2401 Castro St 10 Front Yard : Yard 7 Tree 1 Private 1     25     6002773.69931 2098494.22235 37.7422224380182 -122.43302693833799 (37.7422224380182, -122.433026938338)
177148 248496 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 110 Beulah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     33 Width 0ft   5997529.2628 2107821.3875 37.7675336345309 -122.451833202371 (37.7675336345309, -122.451833202371)
176523 121988 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 528 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 Width 4ft   5991288.02079 2111782.83574 37.778051257453704 -122.473709641027 (37.7780512574537, -122.473709641027)
176451 199344 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1801 03rd St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     30 Width 4ft   6015727.94816 2106771.64308 37.7656767749832 -122.38881249299801 (37.7656767749832, -122.388812492998)
176279 224023 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1300 San Jose Ave 24 Front Yard : Yard 7 Tree 1 Private 1     12     6003511.08148 2095643.96545 37.734438083547104 -122.430273996654 (37.7344380835471, -122.430273996654)
176220 224433 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 280 Putnam St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6009053.875 2096083.33646 37.7359568981934 -122.411141689959 (37.7359568981934, -122.411141689959)
175253 224019 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1300 San Jose Ave 17 Front Yard : Yard 7 Tree 1 Private 1     12     6003580.635530001 2095660.4174400002 37.7344871964146 -122.430034698739 (37.7344871964146, -122.430034698739)
174816 116636 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 2100 20th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 3x3   6011793.53885 2104686.09338 37.759731470241604 -122.402274190217 (37.7597314702416, -122.402274190217)
174729 121615 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1406 Rhode Island St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 3x3   6011976.5645 2101798.75104 37.751813677063495 -122.401438271261 (37.7518136770635, -122.401438271261)
174662 141604 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1890 ASHBURY ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     27 Width 0ft   5998742.3324 2110445.1748 37.7748072887689 -122.447826286931 (37.7748072887689, -122.447826286931)
173602 138924 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 978 HAYES ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 Width 0ft   6003177.0889 2110688.227 37.7757271274592 -122.432502921072 (37.7757271274592, -122.432502921072)
172515 224427 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 74 Arbor St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6001884.73387 2096844.23678 37.7376414974551 -122.435982662785 (37.7376414974551, -122.435982662785)
171934 199387 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1335 Hudson Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6017568.18175 2094804.8827099998 37.7329203283169 -122.38161514674499 (37.7329203283169, -122.381615146745)
171664 137851 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1900 Pine St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 0ft   6004700.2761 2115415.5408 37.7887934168266 -122.427570703503 (37.7887934168266, -122.427570703503)
171543 140328 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1435 LAGUNA ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 0ft   6004571.2725 2113745.3183 37.784200106361105 -122.427897976235 (37.7842001063611, -122.427897976235)
171481 224441 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 310 Liberty St 41 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 3ft   6003891.83885 2103931.1825 37.757214421627395 -122.42954842002399 (37.7572144216274, -122.429548420024)
171025 224033 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 309 Prospect Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 3ft   6006492.3244199995 2098046.7122 37.7412039045359 -122.42013730619499 (37.7412039045359, -122.420137306195)
170634 38226 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1099 Mississippi St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/21/1998 12:00:00 AM 11   Permit Number 40351 6014262.677019999 2102083.6302 37.752723184838295 -122.393552456191 (37.7527231848383, -122.393552456191)
170233 199346 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 467 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     37 Width 6ft   6014392.30341 2104959.03416 37.7606256274859 -122.39330537915501 (37.7606256274859, -122.393305379155)
169973 61914 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 801 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/27/1985 12:00:00 AM 12   Permit Number 21965 6016347.85341 2101137.90293 37.75024205603879 -122.386275546874 (37.7502420560388, -122.386275546874)
169546 250104 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1634 Pine St 1 : 4 Tree 1 Private 1     2 Width 4ft   6006039.94152 2115602.86884 37.789383456327705 -122.422948963731 (37.7893834563277, -122.422948963731)
169526 247073 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 2401 Castro St 9 Front Yard : Yard 7 Tree 1 Private 1     24     6002776.09275 2098476.71227 37.742174495166395 -122.433017411837 (37.7421744951664, -122.433017411837)
169441 224010 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1000 San Jose Ave 31 Front Yard : Yard 7 Tree 1 Private 1     18     6005156.6976 2097181.32171 37.738752392204205 -122.424693884126 (37.7387523922042, -122.424693884126)
169310 176391 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1669 Geneva Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 8ft   6003898.25323 2087460.6657900002 37.711990473755606 -122.42835236038401 (37.7119904737556, -122.428352360384)
168669 247078 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 2401 Castro St 14 Front Yard : Yard 7 Tree 1 Private 1     25     6002758.90176 2098529.69857 37.7423190081102 -122.433080637766 (37.7423190081102, -122.433080637766)
168540 199394 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 818 Mendell St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     28 Width 4ft   6015978.55484 2096747.59262 37.738166719509394 -122.387246410905 (37.7381667195094, -122.387246410905)
168302 224440 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 680 Noe St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 Width 3ft   6003015.35914 2104247.09039 37.75803216346179 -122.43260218946301 (37.7580321634618, -122.432602189463)
168267 117354 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 500 Hayes St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 3x3   6005385.3892 2111000.9525 37.7767107741663 -122.42488610508002 (37.7767107741663, -122.42488610508)
167988 140151 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 270 Ashbury St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 0ft   5998833.2999 2109787.1903 37.7730058307472 -122.4474642414 (37.7730058307472, -122.4474642414)
166362 246047 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1260 Waller St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 0ft   5999598.1911 2108456.8743 37.769396800404 -122.44472275905599 (37.769396800404, -122.444722759056)
166280 123309 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 401 05th Ave 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 4ft   5994326.71646 2112582.77127 37.7804231861892 -122.463255844547 (37.7804231861892, -122.463255844547)
166171 123313 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 401 05th Ave 17 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 4ft   5994324.87447 2112727.37957 37.7808201355721 -122.46327271312599 (37.7808201355721, -122.463272713126)
165437 138649 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 3073 Pine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 0ft   5999235.7723 2114604.2128 37.786255122975504 -122.44641865052 (37.7862551229755, -122.44641865052)
165042 218785 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 230 Edna St 5 Side Yard : Yard 17 Tree 1 Private 1     8     5998782.76063 2095352.74135 37.733369495591795 -122.446600344857 (37.7333694955918, -122.446600344857)
164748 224034 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 5210 Diamond Heights Blvd 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6001015.66904 2099302.9649400003 37.7443431769966 -122.439163600842 (37.7443431769966, -122.439163600842)
164518 248513 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 23 Beulah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 0ft   5997819.2217 2107818.3592 37.767541922496 -122.450830059129 (37.767541922496, -122.450830059129)
163721 141298 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1835 ELLIS ST 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 0ft   6002114.3056 2112921.2293 37.7817980655656 -122.436339196325 (37.7817980655656, -122.436339196325)
162867 224012 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1000 San Jose Ave 85 Front Yard : Yard 7 Tree 1 Private 1     26     6005023.67021 2096975.18783 37.738178881048704 -122.425139167258 (37.7381788810487, -122.425139167258)
162695 206275 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 531 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 Width 8ft   5993329.29471 2096110.62255 37.735137433227294 -122.465509381364 (37.7351374332273, -122.465509381364)
162370 224436 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 98 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     26 Width 3ft   6006240.51388 2097682.8061900004 37.7401905088725 -122.42098214730801 (37.7401905088725, -122.420982147308)
162340 200569 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1480 McKinnon Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 Width 0ft   6015968.5912 2095510.6463 37.73476976318889 -122.387194605139 (37.7347697631889, -122.387194605139)
162071 176385 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 10x Mansell St 9 Median : Cutout 11 Tree 1 DPW 2     15 Width 0ft   6011675.69162 2090725.79104 37.7213928740681 -122.401700514484 (37.7213928740681, -122.401700514484)
161708 206289 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 155 Monterey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     23 Width 3ft   6001037.098230001 2094617.6771900002 37.7314796917331 -122.438753833738 (37.7314796917331, -122.438753833738)
160557 200565 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1440 McKinnon Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 Width 0ft   6016176.2996 2095352.8619 37.734348019214295 -122.38646548119101 (37.7343480192143, -122.386465481191)
160411 199378 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 200 Jennings St 16 : 4 Tree 1 Private 1     21 Width 4ft   6018401.90254 2096662.3376799999 37.7380665323305 -122.37886167173401 (37.7380665323305, -122.378861671734)
160018 206274 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 130 Saint Francis Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 10ft   5992348.03804 2095988.5894400002 37.7347457173231 -122.468893032011 (37.7347457173231, -122.468893032011)
159517 250101 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1634 Pine St 4 : 4 Tree 1 Private 1     13 Width 4ft   6005978.51572 2115593.66659 37.78935472300171 -122.42316083590299 (37.7893547230017, -122.423160835903)
158585 199396 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 822 Mendell St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     27 Width 3ft   6015911.756680001 2096647.34572 37.737887762395296 -122.38747037626301 (37.7378877623953, -122.387470376263)
158477 138990 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 989 Hayes St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 0ft   6003149.6711 2110641.7 37.775597821027006 -122.432594441858 (37.775597821027, -122.432594441858)
158289 206296 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1495 Monterey Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 3ft   5993533.84781 2095106.3143799999 37.7323916474557 -122.464729266269 (37.7323916474557, -122.464729266269)
158273 250109 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1688 Pine St 5 : 4 Tree 1 Private 1     20 Width 4ft   6005867.157869999 2115579.68143 37.7893100383746 -122.42354512700899 (37.7893100383746, -122.423545127009)
158262 176380 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 229 Hester Ave 1 Front Yard : Yard 7 Tree 1 Private 1     38     6012521.81555 2087619.26728 37.7129101627473 -122.398557799413 (37.7129101627473, -122.398557799413)
157434 206269 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 576 Dewey Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 6ft   5994053.8446 2099403.66341 37.744221064358705 -122.463243244477 (37.7442210643587, -122.463243244477)
157373 246154 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1730 Waller St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 0ft   5997434.1745 2108152.8339 37.768438254928704 -122.45218601649401 (37.7684382549287, -122.452186016494)
157239 224025 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1193 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 5ft   6004485.645169999 2101988.85608 37.7519148526121 -122.427356445766 (37.7519148526121, -122.427356445766)
156619 123312 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 401 05th Ave 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 4ft   5994326.95545 2112691.62436 37.7807220812689 -122.46326291878201 (37.7807220812689, -122.463262918782)
156597 176395 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 5 Lisbon St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 4ft   6003928.40899 2093435.3216799998 37.728397273506 -122.42867376727699 (37.728397273506, -122.428673767277)
155601 248526 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 75 Beulah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 0ft   5997669.6241 2107795.1927 37.7674697483814 -122.451345824031 (37.7674697483814, -122.451345824031)
154600 224031 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 822 Clayton St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     30 Width 4ft   5998688.13035 2107403.24761 37.766451833222604 -122.447794742535 (37.7664518332226, -122.447794742535)
153777 224008 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1000 San Jose Ave 29 Front Yard : Yard 7 Tree 1 Private 1     17     6005152.83634 2097199.08838 37.7388009573938 -122.42470849810499 (37.7388009573938, -122.424708498105)
153651 199341 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 400 Mariposa St 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     24 Width 6ft   6015776.44164 2106315.00515 37.764425633653296 -122.388612884902 (37.7644256336533, -122.388612884902)
153494 199348 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1501 25th St 23 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     6014219.92848 2101970.08813 37.7524090471553 -122.393692343051 (37.7524090471553, -122.393692343051)
153389 138863 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 700 STEINER ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 0ft   6003116.7145 2110679.9186 37.775700890816395 -122.43271117741101 (37.7757008908164, -122.432711177411)
153010 224448 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 36 McCoppin St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     32 Width 4ft   6006371.64374 2109173.2323 37.7717479515507 -122.421344528235 (37.7717479515507, -122.421344528235)
152916 182758 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1762 31st Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   5986605.2662 2103225.2032 37.7542820602368 -122.48927939027 (37.7542820602368, -122.48927939027)
152830 199362 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 936 Wisconsin St 1 : 4 Tree 1 Private 1     13 Width 4ft   6012742.61969 2103151.37524 37.7555704024715 -122.39888405366699 (37.7555704024715, -122.398884053667)
152750 206265 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1223 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 4ft   5995764.11125 2107172.86823 37.765651712687394 -122.45789165508002 (37.7656517126874, -122.45789165508)
152670 200711 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1485 McKinnon Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 Width 0ft   6016014.8171 2095413.88 37.734506622191 -122.387028037996 (37.734506622191, -122.387028037996)
152422 199345 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 473 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 3ft   6014395.760480001 2104935.64517 37.7605615984582 -122.39329178588699 (37.7605615984582, -122.393291785887)
152285 199383 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 400x Cargo Way 6 Median : Yard 3 Tree 1 DPW 2     10     6017000.482369999 2098965.68052 37.7443136810333 -122.38386746011801 (37.7443136810333, -122.383867460118)

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