home / trees

Street_Tree_List

Data source: data.sfgov.org

576 rows where qSpecies = 60

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize, 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
306 100314 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 1683 Galvez Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 3x3   6015409.74359 2097962.08476 37.7414699491892 -122.389297877816 (37.7414699491892, -122.389297877816) 10 3 8 58 1
307 100315 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 1683 Galvez Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3   6015443.91077 2097940.33755 37.7414121299803 -122.38917822030399 (37.7414121299803, -122.389178220304) 10 3 8 58 1
391 100424 Permitted Site 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 200X Stonecrest Dr 1 Sidewalk: Property side : Cutout 9 Tree 1 Private 2       3x6   5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264) 9 8 4 64 40
392 100425 Permitted Site 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 200X Stonecrest Dr 2 Sidewalk: Property side : Cutout 9 Tree 1 Private 2       3x6   5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264) 9 8 4 64 40
1438 101627 Permitted Site 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 1585X Jerrold Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/05/2012 12:00:00 AM   3x3 Permit Number 768640 6015457.6 2096890.8 37.7385310737434 -122.38905762495199 (37.7385310737434, -122.389057624952) 10 3 8 58 1
1439 101628 Permitted Site 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 1585X Jerrold Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/05/2012 12:00:00 AM   3x3 Permit Number 768640 6015457.6 2096890.8 37.7385310737434 -122.38905762495199 (37.7385310737434, -122.389057624952) 10 3 8 58 1
1440 101629 Permitted Site 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 1585X Jerrold Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/05/2012 12:00:00 AM   3x3 Permit Number 768640 6015457.6 2096890.8 37.7385310737434 -122.38905762495199 (37.7385310737434, -122.389057624952) 10 3 8 58 1
1442 101630 Permitted Site 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 1585X Jerrold Ave 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   10/06/2015 12:00:00 AM 3 3x3 Permit Number 768640 6015457.6 2096890.8 37.7385310737434 -122.38905762495199 (37.7385310737434, -122.389057624952) 10 3 8 58 1
1443 101631 Permitted Site 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 1585X Jerrold Ave 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/05/2012 12:00:00 AM   3x3 Permit Number 768640 6015457.6 2096890.8 37.7385310737434 -122.38905762495199 (37.7385310737434, -122.389057624952) 10 3 8 58 1
1444 101632 Permitted Site 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 1585X Jerrold Ave 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/05/2012 12:00:00 AM   3x3 Permit Number 768640 6015457.6 2096890.8 37.7385310737434 -122.38905762495199 (37.7385310737434, -122.389057624952) 10 3 8 58 1
1445 101633 Permitted Site 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 1585X Jerrold Ave 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/05/2012 12:00:00 AM   3x3 Permit Number 768640 6015457.6 2096890.8 37.7385310737434 -122.38905762495199 (37.7385310737434, -122.389057624952) 10 3 8 58 1
1446 101634 Permitted Site 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 1585X Jerrold Ave 8 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/05/2012 12:00:00 AM   3x3 Permit Number 768640 6015457.6 2096890.8 37.7385310737434 -122.38905762495199 (37.7385310737434, -122.389057624952) 10 3 8 58 1
3631 104044 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 1601X Kansas St 8 Sidewalk: Property side : Cutout 9 Tree 1 DPW 1     70 9x9   6011818.89895 2100809.64818 37.749089017243904 -122.401913980245 (37.7490890172439, -122.401913980245) 10 3 8 58 1
3632 104045 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 1601X Kansas St 7 Sidewalk: Property side : Cutout 9 Tree 1 DPW 1     4 3x6   6011820.27046 2100794.2900099996 37.7490469235803 -122.40190815805 (37.7490469235803, -122.40190815805) 10 3 8 58 1
3633 104046 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 1601X Kansas St 6 Sidewalk: Property side : Cutout 9 Tree 1 DPW 1     4 3x6   6011820.47885 2100780.87152 37.7490100909441 -122.401906494295 (37.7490100909441, -122.401906494295) 10 3 8 58 1
3961 104460 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 1601X Kansas St 2 Sidewalk: Property side : Cutout 9 Tree 1 DPW 1     4 3x6   6011835.24913 2100548.938 37.7483740760146 -122.401839117097 (37.7483740760146, -122.401839117097) 10 3 8 58 1
10259 111741 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 498x 11th Ave 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 3x3   5992530.718830001 2112167.7442799998 37.7791800053719 -122.469438767189 (37.7791800053719, -122.469438767189) 11 6 2 54 11
17456 119966 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 524 28th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 Width 4ft   5987215.946719999 2112352.1893599997 37.7793778617147 -122.487838060827 (37.7793778617147, -122.487838060827) 11 6 2 55 26
18252 120834 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 2033 Cabrillo St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 Width 3ft   5989271.19606 2110543.25177 37.7745306911578 -122.48059571456498 (37.7745306911578, -122.480595714565) 11 6 2 55 26
18324 120913 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 499X South Van Ness Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     5 3x3   6007431.0 2106864.0 37.7654670122947 -122.41751644763 (37.7654670122947, -122.41751644763) 8 4 7 28853 19
18326 120915 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 499X South Van Ness Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     4 3x3   6007431.0 2106864.0 37.7654670122947 -122.41751644763 (37.7654670122947, -122.41751644763) 8 4 7 28853 19
18364 120951 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 741 South Van Ness Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     8 3x3   6007568.0 2105341.0 37.76129291599771 -122.416934678899 (37.7612929159977, -122.416934678899) 2 4 7 28859 19
18677 121263 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 700 South Van Ness Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     5 3x3   6007449.0 2105508.0 37.7617447647779 -122.41735808585 (37.7617447647779, -122.41735808585) 2 4 7 28859 19
18986 121589 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 270x South Van Ness Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1       3x3   6007359.0 2108191.0 37.76910659118089 -122.417859552844 (37.7691065911809, -122.417859552844) 8 4 7 28853 19
19436 122016 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 1633 Cabrillo St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 Width 4ft   5990486.56458 2110588.66917 37.774725954752796 -122.47639488146099 (37.7747259547528, -122.476394881461) 11 6 2 55 26
20492 123105 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 498 11th Ave 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 Width 3ft   5992529.16869 2112181.64232 37.7792180760249 -122.46944514164801 (37.7792180760249, -122.469445141648) 11 6 2 54 11
20572 123179 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 771 10th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 3ft   5992862.96444 2110216.5600400004 37.7738417753505 -122.468147428182 (37.7738417753505, -122.468147428182) 11 6 2 54 11
20604 123208 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 400 09th Ave 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     11 Width 3ft   5993131.19371 2112699.04699 37.780673502077896 -122.467400140372 (37.7806735020779, -122.467400140372) 11 6 2 54 11
20607 123210 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 400 09th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     13 Width 3ft   5993133.98431 2112655.94122 37.7805553064396 -122.467387351051 (37.7805553064396, -122.467387351051) 11 6 2 54 11
20608 123211 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 400 09th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     13 Width 3ft   5993134.492000001 2112639.5046599996 37.780510205416704 -122.46738439918501 (37.7805102054167, -122.467384399185) 11 6 2 54 11
21536 124090 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 601 Funston Ave 5 Sidewalk: Property side : Yard 5 Tree 1 Private 2     12     5991893.39709 2111137.1044099997 37.776313297478204 -122.471568380763 (37.7763132974782, -122.471568380763) 11 6 2 54 11
34662 136175 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 3103 Pierce St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 Width 3ft   6001391.85411 2119087.81282 37.7986888314695 -122.439280672761 (37.7986888314695, -122.439280672761) 13 9 1 57 17
34663 136176 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 2134 Green St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 Width 3ft   6002833.9768 2118210.69092 37.7963624418193 -122.434227733841 (37.7963624418193, -122.434227733841) 13 9 1 57 17
34664 136177 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 2028 Filbert St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 Width 3ft   6003216.31619 2118958.4665599996 37.7984373333682 -122.432958210354 (37.7984373333682, -122.432958210354) 13 9 1 57 17
34665 136178 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 2400 Greenwich St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 Width 4ft   6001367.93231 2119047.53981 37.798576891075 -122.439360561339 (37.798576891075, -122.439360561339) 13 9 1 57 17
34666 136179 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 2400 Greenwich St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     9 Width 4ft   6001333.810430001 2119043.17386 37.79856296146029 -122.43947832036501 (37.7985629614603, -122.439478320365) 13 9 1 57 17
34668 136180 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 3134 Baker St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     11 Width 3ft   5999407.16472 2119635.33058 37.8000790286731 -122.44618771161699 (37.8000790286731, -122.446187711617) 13 9 1 57 17
34669 136181 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 3140 Baker St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 Width 2ft   5999405.9068599995 2119644.67772 37.8001046215781 -122.44619273701299 (37.8001046215781, -122.446192737013) 13 9 1 57 17
34670 136182 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 3140 Baker St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 Width 2ft   5999403.041730001 2119664.02877 37.800157590747105 -122.446204044176 (37.8001575907471, -122.446204044176) 13 9 1 57 17
34671 136183 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 1100 Chestnut St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 Width 4ft   6006523.02231 2120459.93681 37.8027469916359 -122.421622667864 (37.8027469916359, -122.421622667864) 5 9 1 28858 32
34672 136184 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 1100 Chestnut St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 4ft   6006503.30451 2120455.88239 37.8027347473741 -122.421690613452 (37.8027347473741, -122.421690613452) 5 9 1 28858 32
34673 136185 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 800 Powell St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 Width 3ft   6010045.724640001 2116634.21167 37.7924404929984 -122.409162155311 (37.7924404929984, -122.409162155311) 3 1 10 28857 4
34674 136186 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 800 Powell St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 Width 3ft   6010043.141009999 2116645.97985 37.7924726608324 -122.40917192556999 (37.7924726608324, -122.40917192557) 3 1 10 28857 4
34675 136187 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 840 Powell St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 2ft   6010038.55828 2116686.60963 37.7925839636381 -122.409190650353 (37.7925839636381, -122.409190650353) 3 1 10 28857 4
50565 179275 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 716 Peru Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 Width 2ft   6005245.16074 2092477.2139400002 37.725840954193295 -122.424053582122 (37.7258409541933, -122.424053582122) 9 7 6 309 5
50566 179276 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 716 Peru Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 Width 2ft   6005258.78381 2092467.95462 37.7258162992748 -122.424005829932 (37.7258162992748, -122.424005829932) 9 7 6 309 5
50567 179277 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 716 Peru Ave 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 Width 2ft   6005276.23831 2092458.42558 37.725791120054396 -122.423944813618 (37.7257911200544, -122.423944813618) 9 7 6 309 5
50568 179278 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 223 Pioche St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 Width 3ft   6006228.66725 2093396.90262 37.7284216981869 -122.420718924746 (37.7284216981869, -122.420718924746) 9 7 7 309 5
50569 179279 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 223 Pioche St 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 Width 2ft   6006275.12702 2093408.7720700002 37.7284569075468 -122.420559152977 (37.7284569075468, -122.420559152977) 9 7 7 309 5
50570 179280 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 16 Hale St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 Width 3ft   6010456.33755 2094955.50587 37.732938666383205 -122.406213356571 (37.7329386663832, -122.406213356571) 10 3 7 309 28
50571 179281 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 16 Hale St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 Width 3ft   6010435.48171 2094947.68687 37.7329160304499 -122.406284910247 (37.7329160304499, -122.406284910247) 10 3 7 309 28
68911 196963 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 500 18th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 3ft   6015947.26389 2105849.11258 37.7631558583726 -122.38798953960101 (37.7631558583726, -122.387989539601) 14 3 8 28856 29
68912 196964 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 500 18th St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 3ft   6015932.05228 2105848.0016400004 37.7631519652185 -122.3880420744 (37.7631519652185, -122.3880420744) 14 3 8 28856 29
68913 196965 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 500 18th St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 3ft   6015917.99613 2105847.4159999997 37.763149578419 -122.38809064946999 (37.763149578419, -122.38809064947) 14 3 8 28856 29
68914 196966 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 500 18th St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 3ft   6015902.3504800005 2105846.23751 37.7631454756938 -122.38814468075701 (37.7631454756938, -122.388144680757) 14 3 8 28856 29
68915 196967 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 500 18th St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 Width 3ft   6015888.58147 2105846.04273 37.7631441779792 -122.38819228996799 (37.7631441779792, -122.388192289968) 14 3 8 28856 29
68916 196968 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 500 18th St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 3ft   6015876.458740001 2105845.10564 37.7631409332394 -122.38823415338899 (37.7631409332394, -122.388234153389) 14 3 8 28856 29
68917 196969 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 500 18th St 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 Width 3ft   6015866.243419999 2105844.6030099997 37.763138987107 -122.388269449981 (37.763138987107, -122.388269449981) 14 3 8 28856 29
68919 196970 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 500 18th St 8 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 3ft   6015850.66313 2105843.80284 37.763135926706795 -122.38832328159599 (37.7631359267068, -122.388323281596) 14 3 8 28856 29
68920 196971 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 500 18th St 9 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 Width 3ft   6015840.83077 2105843.6976400004 37.7631350930254 -122.38835728138201 (37.7631350930254, -122.388357281382) 14 3 8 28856 29
68921 196972 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 900 Pennsylvania Ave 10 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     11 Width 4ft   6014458.90845 2102627.41024 37.7542271903342 -122.392911888877 (37.7542271903342, -122.392911888877) 10 3 8 28856 29
68922 196973 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 900 Pennsylvania Ave 11 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 Width 4ft   6014457.83967 2102608.3730099997 37.754174858803296 -122.39291425318899 (37.7541748588033, -122.392914253189) 10 3 8 28856 29
68923 196974 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 223 Mississippi St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14 Width 3ft   6014047.89224 2106015.09524 37.763506200065706 -122.394570502234 (37.7635062000657, -122.394570502234) 14 3 8 28856 29
68924 196975 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 209 Mississippi St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 Width 3ft   6014043.29115 2106063.3256200003 37.7636383743244 -122.39458979361099 (37.7636383743244, -122.394589793611) 14 3 8 28856 29
68925 196976 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 209 Mississippi St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     15 Width 3ft   6014043.63491 2106091.78418 37.7637165344031 -122.39459059758998 (37.7637165344031, -122.39459059759) 14 3 8 28856 29
68926 196977 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 209 Mississippi St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     15 Width 3ft   6014040.95878 2106120.30389 37.763794694494706 -122.39460185080799 (37.7637946944947, -122.394601850808) 14 3 8 28856 29
68927 196978 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 1551 20th St 1 : 14 Tree 1 Private 2     6 Width 4ft   6013296.03231 2104723.49575 37.7599179239891 -122.397080394946 (37.7599179239891, -122.397080394946) 10 3 8 28856 29
68928 196979 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 1551 20th St 2 : 14 Tree 1 Private 2     5 Width 4ft   6013315.21298 2104723.80911 37.7599198521353 -122.39701407983802 (37.7599198521353, -122.397014079838) 10 3 8 28856 29
68929 196980 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 320 Missouri St 1 : 14 Tree 1 Private 2     14 Width 3ft   6013452.78538 2105563.26016 37.76223245789279 -122.396597126255 (37.7622324578928, -122.396597126255) 10 3 8 28856 29
68930 196981 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 2460 Alameda St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 Width 3ft   6009761.09751 2107855.1809 37.7683194004524 -122.40952709750401 (37.7683194004524, -122.409527097504) 8 4 8 28853 19
68931 196982 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 1601 Kansas St 2 Sidewalk: Property side : Yard 5 Tree 1 Private 2     9 Width 6ft   6011835.24913 2100548.938 37.7483740760146 -122.401839117097 (37.7483740760146, -122.401839117097) 10 3 8 58 1
68932 196983 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 1601 Kansas St 2 Sidewalk: Property side : Yard 5 Tree 1 Private 2     9 Width 6ft   6011835.24913 2100548.938 37.7483740760146 -122.401839117097 (37.7483740760146, -122.401839117097) 10 3 8 58 1
68933 196984 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 1601 Kansas St 6 Sidewalk: Property side : Yard 5 Tree 1 Private 2     8 Width 5ft   6011820.47885 2100780.87152 37.7490100909441 -122.401906494295 (37.7490100909441, -122.401906494295) 10 3 8 58 1
68934 196985 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 1601 Kansas St 6 Sidewalk: Property side : Yard 5 Tree 1 Private 2     8 Width 5ft   6011820.47885 2100780.87152 37.7490100909441 -122.401906494295 (37.7490100909441, -122.401906494295) 10 3 8 58 1
68935 196986 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 1601 Kansas St 7 Sidewalk: Property side : Yard 5 Tree 1 Private 2     7 Width 5ft   6011820.27046 2100794.2900099996 37.7490469235803 -122.40190815805 (37.7490469235803, -122.40190815805) 10 3 8 58 1
68936 196987 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 1601 Kansas St 7 Sidewalk: Property side : Yard 5 Tree 1 Private 2     7 Width 5ft   6011820.27046 2100794.2900099996 37.7490469235803 -122.40190815805 (37.7490469235803, -122.40190815805) 10 3 8 58 1
68937 196988 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 1601 Kansas St 8 Sidewalk: Property side : Yard 5 Tree 1 Private 2     6 Width 5ft   6011818.89895 2100809.64818 37.749089017243904 -122.401913980245 (37.7490890172439, -122.401913980245) 10 3 8 58 1
68938 196989 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 1601 Kansas St 8 Sidewalk: Property side : Yard 5 Tree 1 Private 2     6 Width 5ft   6011818.89895 2100809.64818 37.749089017243904 -122.401913980245 (37.7490890172439, -122.401913980245) 10 3 8 58 1
68940 196990 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 2 Napoleon St 1 : 14 Tree 1 Private 2     6 Width 4ft   6014143.12746 2100151.41021 37.7474110756645 -122.39383064437901 (37.7474110756645, -122.393830644379) 10 3 8 58 1
68941 196991 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 2 Napoleon St 2 : 14 Tree 1 Private 2     5 Width 4ft   6014086.846369999 2100149.18925 37.7474018495283 -122.394025106589 (37.7474018495283, -122.394025106589) 10 3 8 58 1
68942 196992 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 2 Napoleon St 5 : 14 Tree 1 Private 2     7 Width 4ft   6013942.24849 2100140.56785 37.747370139416205 -122.394524516312 (37.7473701394162, -122.394524516312) 10 3 8 58 1
68943 196993 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 2 Napoleon St 6 : 14 Tree 1 Private 2     7 Width 4ft   6013912.096059999 2100139.0238799998 37.7473642236913 -122.39462867398501 (37.7473642236913, -122.394628673985) 10 3 8 58 1
68944 196994 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 2 Napoleon St 7 : 14 Tree 1 Private 2     7 Width 4ft   6013884.28274 2100137.93009 37.7473596740254 -122.39472477462401 (37.7473596740254, -122.394724774624) 10 3 8 58 1
68945 196995 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 2 Napoleon St 8 : 14 Tree 1 Private 2     8 Width 4ft   6013853.97089 2100136.72086 37.7473546683845 -122.394829506973 (37.7473546683845, -122.394829506973) 10 3 8 58 1
68946 196996 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 2 Napoleon St 10 : 14 Tree 1 Private 2     8 Width 4ft   6013793.66265 2100133.46781 37.7473423827584 -122.395037822335 (37.7473423827584, -122.395037822335) 10 3 8 58 1
68947 196997 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 2 Napoleon St 11 : 14 Tree 1 Private 2     7 Width 4ft   6013762.67186 2100131.60985 37.747335557807496 -122.395144856947 (37.7473355578075, -122.395144856947) 10 3 8 58 1
68948 196998 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 2 Napoleon St 13 : 14 Tree 1 Private 2     5 Width 4ft   6013702.500030001 2100126.86267 37.7473191766464 -122.39535259585101 (37.7473191766464, -122.395352595851) 10 3 8 58 1
68949 196999 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 2 Napoleon St 14 : 14 Tree 1 Private 2     4 Width 4ft   6013629.21679 2100123.8728 37.7473068910098 -122.39560579639401 (37.7473068910098, -122.395605796394) 10 3 8 58 1
68953 197000 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 2 Napoleon St 15 : 14 Tree 1 Private 2     6 Width 4ft   6013614.06576 2100123.51682 37.7473050707808 -122.39565816299401 (37.7473050707808, -122.395658162994) 10 3 8 58 1
68954 197001 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 2 Napoleon St 16 : 14 Tree 1 Private 2     9 Width 4ft   6013598.90827 2100122.82985 37.7473023413409 -122.395710528743 (37.7473023413409, -122.395710528743) 10 3 8 58 1
68955 197002 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 2251 Silver Ave 3 : 14 Tree 1 Private 2     6 Width 3ft   6012830.37736 2096288.90355 37.736732407869205 -122.398099143384 (37.7367324078692, -122.398099143384) 10 3 8 58 1
68956 197003 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 503 Beale St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     13 Width 2ft   6015964.6605 2113962.87673 37.7854354289412 -122.38849574371001 (37.7854354289412, -122.38849574371) 6 2 9 28856 6
68957 197004 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 503 Beale St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14 Width 2ft   6015943.643630001 2113959.00175 37.7854236244348 -122.388568185881 (37.7854236244348, -122.388568185881) 6 2 9 28856 6
68958 197005 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 503 Beale St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 2ft   6015945.83282 2113971.21012 37.7854572671771 -122.388561464349 (37.7854572671771, -122.388561464349) 6 2 9 28856 6
68959 197006 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 503 Beale St 9 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     15 Width 6ft   6015876.10983 2114035.38454 37.7856296114719 -122.38880716903601 (37.7856296114719, -122.388807169036) 6 2 9 28856 6
68960 197007 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 503 Beale St 14 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     13 Width 6ft   6015822.854169999 2114091.9182 37.7857818882589 -122.388995368366 (37.7857818882589, -122.388995368366) 6 2 9 28856 6
68961 197008 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 503 Beale St 15 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 Width 6ft   6015819.96471 2114109.17282 37.785829105370105 -122.389006570307 (37.7858291053701, -122.389006570307) 6 2 9 28856 6
69593 19758 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 100 STAIRWAY15 16 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     3 20ST                      
70746 19922 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 100 STAIRWAY37 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     3 20ST                      
70747 19923 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 60 100 STAIRWAY37 3 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     3 20ST                      

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