home / trees

Street_Tree_List

Data source: data.sfgov.org

2,981 rows where qSpecies = 28

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes

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
91 100087 Permitted Site 2 Pyrus calleryana :: Ornamental Pear 28 2028 Filbert St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6003216.8 2118972.8 37.798476716718895 -122.432957560795 (37.7984767167189, -122.432957560795) 13 9 1 57 17
154 100150 Undocumented 3 Pyrus calleryana :: Ornamental Pear 28 4007 18th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 3x3   6002942.0 2105314.0 37.7609574805046 -122.432932117926 (37.7609574805046, -122.432932117926) 2 4 5 28862 3
204 100201 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 255 Golden Gate Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 3x3 Permit Number 51875 6008346.927130001 2112747.04212 37.7816719523255 -122.414764839028 (37.7816719523255, -122.414764839028) 7 10 9 28852 36
305 100313 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 1683 Galvez Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/08/2012 12:00:00 AM 1 3x3 Permit Number 769149 6015385.12474 2097976.75918 37.7415088772353 -122.389384026569 (37.7415088772353, -122.389384026569) 10 3 8 58 1
415 100464 Significant Tree 4 Pyrus calleryana :: Ornamental Pear 28 145 Irving St 3 Front Yard : Yard 4 Tree 1 Private 2   08/21/2012 12:00:00 AM     Permit Number 768746 5995340.8 2106458.8 37.76366673695 -122.45930407086 (37.76366673695, -122.45930407086) 15 5 11 56 12
819 100958 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 1520 Lyon St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/21/2012 12:00:00 AM 10 3x3 Permit Number 769191 5999686.3 2114075.9 37.784830235107705 -122.444821957123 (37.7848302351077, -122.444821957123) 15 6 1 29490 31
820 100959 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 1520 Lyon St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/21/2012 12:00:00 AM 9 3x3 Permit Number 769191 5999686.3 2114075.9 37.784830235107705 -122.444821957123 (37.7848302351077, -122.444821957123) 15 6 1 29490 31
822 100960 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 1520 Lyon St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/21/2012 12:00:00 AM 6 3x3 Permit Number 769191 5999686.3 2114075.9 37.784830235107705 -122.444821957123 (37.7848302351077, -122.444821957123) 15 6 1 29490 31
823 100961 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 1520 Lyon St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/21/2012 12:00:00 AM   3x3 Permit Number 769191 5999686.3 2114075.9 37.784830235107705 -122.444821957123 (37.7848302351077, -122.444821957123) 15 6 1 29490 31
1175 101339 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 600 Chestnut St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/01/1993 12:00:00 AM 10   Permit Number 32655 6008874.1379 2120789.2367 37.8037834596872 -122.41350988733299 (37.8037834596872, -122.413509887333) 3 1 10 308 23
1176 101340 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 600 Chestnut St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/01/1993 12:00:00 AM 9   Permit Number 32655 6008863.3062 2120787.3529 37.803777679043996 -122.41354723786199 (37.803777679044, -122.413547237862) 3 1 10 308 23
1177 101341 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 600 Chestnut St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/01/1993 12:00:00 AM 10   Permit Number 32655 6008852.9454 2120786.8819999998 37.8037758043003 -122.413583058795 (37.8037758043003, -122.413583058795) 3 1 10 308 23
1178 101342 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 600 Chestnut St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/01/1993 12:00:00 AM 12   Permit Number 32655 6008822.334 2120781.2306 37.803758568044294 -122.413688591667 (37.8037585680443, -122.413688591667) 3 1 10 308 23
1179 101343 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 600 Chestnut St 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/01/1993 12:00:00 AM 9   Permit Number 32655 6008800.1996 2120778.8759 37.8037508596523 -122.41376502259399 (37.8037508596523, -122.413765022594) 3 1 10 308 23
1180 101344 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 600 Chestnut St 8 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/01/1993 12:00:00 AM 9   Permit Number 32655 6008790.3098 2120778.405 37.803749011292894 -122.413799213582 (37.8037490112929, -122.413799213582) 3 1 10 308 23
1192 101356 Permitted Site 2 Pyrus calleryana :: Ornamental Pear 28 2201X Mason St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/01/1993 12:00:00 AM   5x5 Permit Number 32655 6008936.1 2120783.7 37.803771736238 -122.41329507143601 (37.803771736238, -122.413295071436) 3 1 10 308 23
1193 101357 Permitted Site 2 Pyrus calleryana :: Ornamental Pear 28 2201X Mason St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/01/1993 12:00:00 AM   5x5 Permit Number 32655 6008936.1 2120783.7 37.803771736238 -122.41329507143601 (37.803771736238, -122.413295071436) 3 1 10 308 23
1196 101360 Permitted Site 2 Pyrus calleryana :: Ornamental Pear 28 2201X Mason St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/01/1993 12:00:00 AM   5x5 Permit Number 32655 6008936.1 2120783.7 37.803771736238 -122.41329507143601 (37.803771736238, -122.413295071436) 3 1 10 308 23
1204 101368 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 555 Minna St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   10/17/2012 12:00:00 AM 1 3x5 Permit Number 769424 6009870.786169999 2111925.3371200003 37.77950124702579 -122.40943497635901 (37.7795012470258, -122.409434976359) 14 2 9 28853 34
1816 102099 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 236 Linden St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2   4 6   6006248.049 2110932.5353900003 37.776571605618 -122.421897043808 (37.776571605618, -122.421897043808) 7 9 11 28852 10
1820 102102 Undocumented 3 Pyrus calleryana :: Ornamental Pear 28 43-45 Pond St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3 Permit Number 769434 6003182.0 2106269.0 37.7635932901021 -122.43217026586399 (37.7635932901021, -122.432170265864) 15 4 5 28862 3
2097 102389 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 90X Harriet St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 3x3   6010750.24129 2111421.87021 37.7781680812419 -122.406357067338 (37.7781680812419, -122.406357067338) 14 2 9 28853 34
2101 102393 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 30X Harriet St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 3x3   6010484.4318 2111700.90158 37.7789193631694 -122.407296278794 (37.7789193631694, -122.407296278794) 14 2 9 28853 34
2102 102394 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 30X Harriet St 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 3x3   6010499.119030001 2111685.94424 37.778879115810795 -122.407244414896 (37.7788791158108, -122.407244414896) 14 2 9 28853 34
2120 102415 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 286 06th St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 3x3   6010900.79062 2111559.68279 37.7785549030328 -122.405845970014 (37.7785549030328, -122.405845970014) 14 2 9 28853 34
2125 10242 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 80X Haight St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     8 3X3   6005765.1512 2109670.3256 37.77307863760571 -122.423477773641 (37.7730786376057, -122.423477773641) 7 9 11 28852 10
2136 10243 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 80X Haight St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   05/15/2000 12:00:00 AM 8 3X3   6005750.7633 2109671.0107 37.7730797066295 -122.423527591987 (37.7730797066295, -122.423527591987) 7 9 11 28852 10
2158 10245 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 99X Haight St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   05/01/2008 12:00:00 AM 6 3X3 Permit Number 769626 6005669.1162393 2109600.6288971 37.7728818463732 -122.42380501439399 (37.7728818463732, -122.423805014394) 7 9 11 28852 10
2195 102486 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 2001 McAllister St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   5999317.5032 2111146.63 37.776766163239 -122.44588711953399 (37.776766163239, -122.445887119534) 15 5 11 29492 16
2197 102488 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 2001 McAllister St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3   5999353.3759 2111151.3679 37.776781220552 -122.44576336643298 (37.776781220552, -122.445763366433) 15 5 11 29492 16
2198 102489 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 2001 McAllister St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 3x3   5999366.9128 2111153.3984 37.77678756867871 -122.445716684478 (37.7767875686787, -122.445716684478) 15 5 11 29492 16
2200 102490 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 2001 McAllister St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   5999398.0476 2111156.4442 37.776797709247106 -122.445609199356 (37.7767977092471, -122.445609199356) 15 5 11 29492 16
2201 102491 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 2001 McAllister St 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   01/28/2013 12:00:00 AM 10 3x3 Permit Number 769781 5999572.3 2111193.9 37.7769105000816 -122.445009103471 (37.7769105000816, -122.445009103471) 15 5 11 29492 16
2202 102492 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 2001 McAllister St 8 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3   5999446.4419 2111164.2279 37.776821844078704 -122.445442349386 (37.7768218440787, -122.445442349386) 15 5 11 29492 16
2204 102494 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 2001 McAllister St 10 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   5999485.3604 2111169.9811 37.7768398625415 -122.445308132817 (37.7768398625415, -122.445308132817) 15 5 11 29492 16
2205 102495 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 2001 McAllister St 11 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 3x3   5999506.3426 2111173.3653 37.776850352386106 -122.445235792686 (37.7768503523861, -122.445235792686) 15 5 11 29492 16
2206 102496 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 2001 McAllister St 12 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     9 3x3   5999527.3247 2111175.3959 37.7768571255416 -122.445163355541 (37.7768571255416, -122.445163355541) 15 5 11 29492 16
2207 102497 Permitted Site 2 Pyrus calleryana :: Ornamental Pear 28 2001 McAllister St 13 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5999572.3 2111193.9 37.7769105000816 -122.445009103471 (37.7769105000816, -122.445009103471) 15 5 11 29492 16
2368 102675 Permitted Site 2 Pyrus calleryana :: Ornamental Pear 28 333 Eucalyptus Dr 1 Front Yard : Yard 4 Tree 1 Private 2   12/01/2006 12:00:00 AM     Permit Number 58781 5990098.7 2094672.6 37.731002133154995 -122.476573573496 (37.731002133155, -122.476573573496) 1 8 4 64 14
2369 102676 Permitted Site 2 Pyrus calleryana :: Ornamental Pear 28 333 Eucalyptus Dr 2 Front Yard : Yard 4 Tree 1 Private 2   12/01/2006 12:00:00 AM     Permit Number 58781 5990098.7 2094672.6 37.731002133154995 -122.476573573496 (37.731002133155, -122.476573573496) 1 8 4 64 14
2370 102677 Permitted Site 2 Pyrus calleryana :: Ornamental Pear 28 333 Eucalyptus Dr 3 Front Yard : Yard 4 Tree 1 Private 2   12/01/2006 12:00:00 AM     Permit Number 58781 5990098.7 2094672.6 37.731002133154995 -122.476573573496 (37.731002133155, -122.476573573496) 1 8 4 64 14
2371 102678 Permitted Site 2 Pyrus calleryana :: Ornamental Pear 28 333 Eucalyptus Dr 4 Front Yard : Yard 4 Tree 1 Private 2   12/01/2006 12:00:00 AM     Permit Number 58781 5990098.7 2094672.6 37.731002133154995 -122.476573573496 (37.731002133155, -122.476573573496) 1 8 4 64 14
2372 102679 Permitted Site 2 Pyrus calleryana :: Ornamental Pear 28 333 Eucalyptus Dr 5 Front Yard : Yard 4 Tree 1 Private 2   12/01/2006 12:00:00 AM     Permit Number 58781 5990098.7 2094672.6 37.731002133154995 -122.476573573496 (37.731002133155, -122.476573573496) 1 8 4 64 14
2374 102680 Permitted Site 2 Pyrus calleryana :: Ornamental Pear 28 333 Eucalyptus Dr 6 Front Yard : Yard 4 Tree 1 Private 2   12/01/2006 12:00:00 AM     Permit Number 58781 5990098.7 2094672.6 37.731002133154995 -122.476573573496 (37.731002133155, -122.476573573496) 1 8 4 64 14
2407 102718 Undocumented 3 Pyrus calleryana :: Ornamental Pear 28 1689 Folsom St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 3x3   6008052.0 2108400.0 37.7697194320745 -122.415477297726 (37.7697194320745, -122.415477297726) 8 4 9 28853 19
2409 102720 Undocumented 3 Pyrus calleryana :: Ornamental Pear 28 1675X Folsom St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 3x3   6008073.0 2108468.0 37.7699073244585 -122.41540947387199 (37.7699073244585, -122.415409473872) 8 2 9 28853 19
2410 102721 Undocumented 3 Pyrus calleryana :: Ornamental Pear 28 1669X Folsom St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 3x3   6008081.0 2108497.0 37.7699874012951 -122.415383855279 (37.7699874012951, -122.415383855279) 8 2 9 28853 19
2564 102881 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 5075 03rd St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/08/2013 12:00:00 AM   3x3   6014754.3 2094747.4 37.7326067241724 -122.39133952421801 (37.7326067241724, -122.391339524218) 10 3 8 58 1
2580 102898 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 124 Jones St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 3x3   6009090.71716 2113027.45874 37.7824836723291 -122.412211492861 (37.7824836723291, -122.412211492861) 14 10 9 28852 36
2706 103044 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 450X Octavia St 5 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     3 3x3   6005621.8 2110912.7 37.7764818047314 -122.424062011758 (37.7764818047314, -122.424062011758) 7 9 11 28852 10
2707 103045 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 450X Octavia St 6 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     3 3x3   6005621.8 2110912.7 37.7764818047314 -122.424062011758 (37.7764818047314, -122.424062011758) 7 9 11 28852 10
2708 103046 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 400X Octavia St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     3 3x3   6005072.0 2110257.0 37.774650355650394 -122.42591724231501 (37.7746503556504, -122.425917242315) 7 9 11 28852 10
2709 103047 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 400X Octavia St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     3 3x3   6005072.0 2110257.0 37.774650355650394 -122.42591724231501 (37.7746503556504, -122.425917242315) 7 9 11 28852 10
2710 103048 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 400X Octavia St 3 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     3 3x3   6005072.0 2110257.0 37.774650355650394 -122.42591724231501 (37.7746503556504, -122.425917242315) 7 9 11 28852 10
2735 103075 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 445 Octavia St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     3 3x3   6005464.0 2110963.0 37.7766110057417 -122.42461146641399 (37.7766110057417, -122.424611466414) 7 9 11 28852 10
2736 103076 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 445 Octavia St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     3 3x3   6005464.0 2110963.0 37.7766110057417 -122.42461146641399 (37.7766110057417, -122.424611466414) 7 9 11 28852 10
2737 103077 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 445 Octavia St 3 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     3 3x3   6005464.0 2110963.0 37.7766110057417 -122.42461146641399 (37.7766110057417, -122.424611466414) 7 9 11 28852 10
2907 103257 Undocumented 3 Pyrus calleryana :: Ornamental Pear 28 4191 26th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 3x3   6002662.0 2100623.0 37.7480612271304 -122.433565259879 (37.7480612271304, -122.433565259879) 2 4 5 63 22
3151 103514 Undocumented 3 Pyrus calleryana :: Ornamental Pear 28 1205 04th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   04/16/2015 02:38:00 PM 3 5x9 415-564-3245 marykittner@att.net 5994830.1 2107339.6 37.766055809628604 -122.46113425886699 (37.7660558096286, -122.461134258867) 15 5 11 56 12
3642 104066 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 162 06th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     3 3x3   6010375.22772 2112112.8976 37.7800444950845 -122.407703118631 (37.7800444950845, -122.407703118631) 14 2 9 28853 34
3782 104257 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 8X Octavia St Frontage East 11 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     3 4x4   6005716.34743 2109200.23605 37.771785130185 -122.423613163533 (37.771785130185, -122.423613163533) 7 2 11 28852 10
3783 104258 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 8X Octavia St Frontage East 12 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     3 4x4   6005716.34743 2109200.23605 37.771785130185 -122.423613163533 (37.771785130185, -122.423613163533) 7 2 11 28852 10
3784 104259 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 8X Octavia St Frontage East 13 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     3 4x4   6005716.34743 2109200.23605 37.771785130185 -122.423613163533 (37.771785130185, -122.423613163533) 7 2 11 28852 10
3786 104260 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 8 Octavia St 14 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     3 4x4   6005716.34743 2109200.23605 37.771785130185 -122.423613163533 (37.771785130185, -122.423613163533) 7 2 11 28852 10
3830 104317 Private 7 Pyrus calleryana :: Ornamental Pear 28 13011305 SANCHEZ ST 2 Sidewalk: Property side : Cutout 9 Tree 1 Private 2     12 3x3   6003956.0 2100665.0 37.748249883960796 -122.429093651106 (37.7482498839608, -122.429093651106) 2 4 5 63 22
3885 104376 Permitted Site 2 Pyrus calleryana :: Ornamental Pear 28 241 06th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       5X3   6010759.7 2111824.8 37.77927496148111 -122.406352743846 (37.7792749614811, -122.406352743846) 14 2 9 28853 34
4063 104570 Permitted Site 2 Pyrus calleryana :: Ornamental Pear 28 201X Channel St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       5x5   6011985.487369999 2113104.0493099997 37.7828559770513 -122.402202175758 (37.7828559770513, -122.402202175758) 6 2 9 28853 34
4064 104571 Permitted Site 2 Pyrus calleryana :: Ornamental Pear 28 201X Channel St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       5x5 Permit Number 769108 6011985.487369999 2113104.0493099997 37.7828559770513 -122.402202175758 (37.7828559770513, -122.402202175758) 6 2 9 28853 34
4065 104572 Permitted Site 2 Pyrus calleryana :: Ornamental Pear 28 201X Channel St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       5x5   6011985.487369999 2113104.0493099997 37.7828559770513 -122.402202175758 (37.7828559770513, -122.402202175758) 6 2 9 28853 34
4066 104573 Permitted Site 2 Pyrus calleryana :: Ornamental Pear 28 201X Channel St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       5x5   6011985.487369999 2113104.0493099997 37.7828559770513 -122.402202175758 (37.7828559770513, -122.402202175758) 6 2 9 28853 34
4067 104574 Permitted Site 2 Pyrus calleryana :: Ornamental Pear 28 201X Channel St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       5x5   6011985.487369999 2113104.0493099997 37.7828559770513 -122.402202175758 (37.7828559770513, -122.402202175758) 6 2 9 28853 34
4068 104575 Permitted Site 2 Pyrus calleryana :: Ornamental Pear 28 201X Channel St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       5x5   6011985.487369999 2113104.0493099997 37.7828559770513 -122.402202175758 (37.7828559770513, -122.402202175758) 6 2 9 28853 34
4069 104576 Permitted Site 2 Pyrus calleryana :: Ornamental Pear 28 201X Channel St 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       5x5 Permit Number 769108 6011985.487369999 2113104.0493099997 37.7828559770513 -122.402202175758 (37.7828559770513, -122.402202175758) 6 2 9 28853 34
4070 104577 Permitted Site 2 Pyrus calleryana :: Ornamental Pear 28 201X Channel St 8 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       5x5 Permit Number 769108 6011985.487369999 2113104.0493099997 37.7828559770513 -122.402202175758 (37.7828559770513, -122.402202175758) 6 2 9 28853 34
4071 104578 Permitted Site 2 Pyrus calleryana :: Ornamental Pear 28 201X Channel St 9 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       5x5 Permit Number 769108 6011985.487369999 2113104.0493099997 37.7828559770513 -122.402202175758 (37.7828559770513, -122.402202175758) 6 2 9 28853 34
4072 104579 Permitted Site 2 Pyrus calleryana :: Ornamental Pear 28 201X Channel St 10 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       5x5   6011985.487369999 2113104.0493099997 37.7828559770513 -122.402202175758 (37.7828559770513, -122.402202175758) 6 2 9 28853 34
4074 104580 Permitted Site 2 Pyrus calleryana :: Ornamental Pear 28 201X Channel St 11 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       5x5   6011985.487369999 2113104.0493099997 37.7828559770513 -122.402202175758 (37.7828559770513, -122.402202175758) 6 2 9 28853 34
4075 104581 Permitted Site 2 Pyrus calleryana :: Ornamental Pear 28 201X Channel St 12 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       5x5   6011985.487369999 2113104.0493099997 37.7828559770513 -122.402202175758 (37.7828559770513, -122.402202175758) 6 2 9 28853 34
4076 104582 Permitted Site 2 Pyrus calleryana :: Ornamental Pear 28 201X Channel St 13 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       5x5 Permit Number 769108 6011985.487369999 2113104.0493099997 37.7828559770513 -122.402202175758 (37.7828559770513, -122.402202175758) 6 2 9 28853 34
4077 104583 Permitted Site 2 Pyrus calleryana :: Ornamental Pear 28 201X Channel St 14 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       5x5   6011985.487369999 2113104.0493099997 37.7828559770513 -122.402202175758 (37.7828559770513, -122.402202175758) 6 2 9 28853 34
4078 104584 Permitted Site 2 Pyrus calleryana :: Ornamental Pear 28 201X Channel St 15 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       5x5   6011985.487369999 2113104.0493099997 37.7828559770513 -122.402202175758 (37.7828559770513, -122.402202175758) 6 2 9 28853 34
4081 104587 Permitted Site 2 Pyrus calleryana :: Ornamental Pear 28 2711 18th St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6009734.8 2105398.2 37.7615716193074 -122.40944463693998 (37.7615716193074, -122.40944463694) 2 4 8 28859 19
4082 104588 Permitted Site 2 Pyrus calleryana :: Ornamental Pear 28 2711 18th St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6009734.8 2105398.2 37.7615716193074 -122.40944463693998 (37.7615716193074, -122.40944463694) 2 4 8 28859 19
4083 104589 Permitted Site 2 Pyrus calleryana :: Ornamental Pear 28 2711 18th St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6009734.8 2105398.2 37.7615716193074 -122.40944463693998 (37.7615716193074, -122.40944463694) 2 4 8 28859 19
4085 104590 Permitted Site 2 Pyrus calleryana :: Ornamental Pear 28 2711 18th St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6009734.8 2105398.2 37.7615716193074 -122.40944463693998 (37.7615716193074, -122.40944463694) 2 4 8 28859 19
4086 104591 Permitted Site 2 Pyrus calleryana :: Ornamental Pear 28 600 York St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6009795.0 2105479.0 37.7617968506256 -122.409242130861 (37.7617968506256, -122.409242130861) 8 4 8 28859 19
4087 104592 Permitted Site 2 Pyrus calleryana :: Ornamental Pear 28 600 York St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6009795.0 2105479.0 37.7617968506256 -122.409242130861 (37.7617968506256, -122.409242130861) 8 4 8 28859 19
4088 104593 Permitted Site 2 Pyrus calleryana :: Ornamental Pear 28 600 York St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6009795.0 2105479.0 37.7617968506256 -122.409242130861 (37.7617968506256, -122.409242130861) 8 4 8 28859 19
4089 104594 Permitted Site 2 Pyrus calleryana :: Ornamental Pear 28 600 York St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6009795.0 2105479.0 37.7617968506256 -122.409242130861 (37.7617968506256, -122.409242130861) 8 4 8 28859 19
4090 104595 Permitted Site 2 Pyrus calleryana :: Ornamental Pear 28 600 York St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3 Permit Number 768703 6009795.0 2105479.0 37.7617968506256 -122.409242130861 (37.7617968506256, -122.409242130861) 8 4 8 28859 19
4331 104870 Undocumented 3 Pyrus calleryana :: Ornamental Pear 28 35 Mirabel Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6007485.7 2099934.0 37.746441896906205 -122.416836236399 (37.7464418969062, -122.416836236399) 2 7 7 28859 2
4660 105275 Planning Code 138.1 required 8 Pyrus calleryana :: Ornamental Pear 28 64 Townsend St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015531.53579 2112438.89481 37.7812269075454 -122.389887748547 (37.7812269075454, -122.389887748547) 6 2 9 28856 6
4661 105276 Planning Code 138.1 required 8 Pyrus calleryana :: Ornamental Pear 28 64 Townsend St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015520.229280001 2112423.42174 37.7811837949483 -122.38992578265699 (37.7811837949483, -122.389925782657) 6 2 9 28856 6
4662 105277 Planning Code 138.1 required 8 Pyrus calleryana :: Ornamental Pear 28 64 Townsend St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015510.23316 2112419.2864900003 37.781171886114706 -122.38996007562 (37.7811718861147, -122.38996007562) 6 2 9 28856 6
4727 105351 Significant Tree 4 Pyrus calleryana :: Ornamental Pear 28 2040 Jackson St 1 Front Yard : Yard 4 Tree 1 Private 2   01/16/2014 12:00:00 AM 3   Permit Number 769933 6004399.13095 2117053.27366 37.7932731788779 -122.428729419132 (37.7932731788779, -122.428729419132) 13 9 1 28858 27
4856 105505 Undocumented 3 Pyrus calleryana :: Ornamental Pear 28 184 HARTFORD ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 4x4   6002645.1 2104805.9 37.7595455158901 -122.433922644582 (37.7595455158901, -122.433922644582) 2 4 5 28862 3
4857 105506 Undocumented 3 Pyrus calleryana :: Ornamental Pear 28 184 HARTFORD ST 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     15 4x4   6002645.1 2104805.9 37.7595455158901 -122.433922644582 (37.7595455158901, -122.433922644582) 2 4 5 28862 3
4858 105507 Undocumented 3 Pyrus calleryana :: Ornamental Pear 28 4050 19TH ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     11 3x3   6002636.9 2104802.3 37.759535165813496 -122.433950746894 (37.7595351658135, -122.433950746894) 2 4 5 28862 3
5105 105783 Permitted Site 2 Pyrus calleryana :: Ornamental Pear 28 200 06th St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3 Permit Number 770993 6010568.2 2111882.9 37.779423776156 -122.40701932133999 (37.779423776156, -122.40701932134) 14 2 9 28853 34
5773 106622 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 156 Commonwealth Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     9 3x6 Permit Number 778450 5996579.2478 2113322.09 37.78258266885771 -122.455516779687 (37.7825826688577, -122.455516779687) 11 6 1 54 31

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