Street_Tree_List

Data source: data.sfgov.org

6,952 rows where qSpecies = 26 sorted by PermitNotes

View and edit SQL

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes ▼ XCoord YCoord Latitude Longitude Location
3183 132950 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 2074 Jackson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 5ft   6004267.0 2117052.0 37.7932622027482 -122.42918651023999 (37.7932622027482, -122.42918651024)
3192 5265 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1245 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/19/1992 12:00:00 AM 6 3X3   6001286.0183 2112790.7677 37.781392753559 -122.439195323402 (37.781392753559, -122.439195323402)
3210 194747 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1580 Burke Ave 2 : 4 Tree 1 Private 1     3 Width 4ft   6016181.61808 2099214.241 37.74495087589921 -122.386716274933 (37.7449508758992, -122.386716274933)
3220 5325 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 2880X Sacramento St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6001005.78593 2115601.06101 37.7890931461666 -122.44036639549 (37.7890931461666, -122.44036639549)
3223 8124 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 875 Fulton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/15/2005 12:00:00 AM 3 3X3   6003614.3663 2111395.0391 37.777692645638794 -122.431040728139 (37.7776926456388, -122.431040728139)
3304 2735 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 2261 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/08/2003 12:00:00 AM 3 3x3   6002669.315 2114735.7471 37.786811791741 -122.434548907064 (37.786811791741, -122.434548907064)
3310 8019 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 457 Fulton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/11/1992 12:00:00 AM 12 3X3   6005584.1273 2111672.955 37.7785671526871 -122.42424641558901 (37.7785671526871, -122.424246415589)
3312 19273 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1355 Scott St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6001744.1568 2113114.3836 37.7823073795972 -122.437633572993 (37.7823073795972, -122.437633572993)
3333 140460 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1410 TURK ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/15/1996 12:00:00 AM 5 Width 0ft   6003106.8567 2112412.5475 37.780457699101206 -122.432869084795 (37.7804576991012, -122.432869084795)
3340 140461 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1410 TURK ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/01/1991 12:00:00 AM 7 Width 0ft   6003069.601 2112407.5024 37.780441733392 -122.432997609121 (37.780441733392, -122.432997609121)
3341 8013 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 440 Fulton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/07/2014 12:00:00 AM 3 3X3   6005616.7891 2111728.1123 37.7787204453524 -122.424137349487 (37.7787204453524, -122.424137349487)
3359 20213 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1428 Steiner St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     16 3x3   6002747.1929 2113184.3178 37.7825563803095 -122.4341685179 (37.7825563803095, -122.4341685179)
3367 102770 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1400 Filbert St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 4x4   6006139.52673 2119365.14566 37.799719342134296 -122.42287190623699 (37.7997193421343, -122.422871906237)
3377 194746 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 500 Hampshire St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6010050.23596 2105797.64874 37.7626860840206 -122.408381844163 (37.7626860840206, -122.408381844163)
3397 194745 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 500 Hampshire St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6010051.12155 2105827.11031 37.7627670283973 -122.40838085938499 (37.7627670283973, -122.408380859385)
3411 181033 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 39 Curtis St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 4ft   6000587.53239 2088326.47 37.71417988317489 -122.439857163381 (37.7141798831749, -122.439857163381)
3417 236135 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 44 Franklin St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 4ft   6006548.03614 2110351.8359 37.7749940580768 -122.42081806330799 (37.7749940580768, -122.420818063308)
3429 236137 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 44 Franklin St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 4ft   6006540.30314 2110387.22291 37.775090786432294 -122.42084732634 (37.7750907864323, -122.42084732634)
3431 98631 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 3500X Fillmore St 10 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   6 4x4   6002262.16905 2120180.85898 37.801739536897294 -122.436347379249 (37.8017395368973, -122.436347379249)
3438 2733 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 2256 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6002707.4731 2114797.1964 37.786982681927796 -122.43442128422 (37.7869826819278, -122.43442128422)
3461 9635 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1455 Golden Gate Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/11/1997 12:00:00 AM 3 3X3   6002683.6157 2111959.35 37.7791893181143 -122.43430086301201 (37.7791893181143, -122.434300863012)
3475 236136 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 44 Franklin St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/11/2014 12:00:00 AM 3 Width 4ft   6006544.21691 2110371.8259 37.775048730543205 -122.42083269437201 (37.7750487305432, -122.420832694372)
3482 19260 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1320 Scott St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 4X4   6001795.5969 2113030.7934 37.7820807867545 -122.43744962568 (37.7820807867545, -122.43744962568)
3508 21563 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1450 Sutter St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 4X4   6005662.55853 2114856.43275 37.7873126270251 -122.424201559266 (37.7873126270251, -122.424201559266)
3522 7953 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1745 Franklin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/25/2008 12:00:00 AM 6 3X3   6005687.08424 2116140.5409 37.790839852634605 -122.424208065867 (37.7908398526346, -122.424208065867)
3551 103250 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 2659 Green St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 3x3   6000309.9677099995 2117811.76496 37.7951235169026 -122.442932649645 (37.7951235169026, -122.442932649645)
3558 7824 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 807 Franklin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1992 12:00:00 AM 3 4x4   6006129.00475 2112968.14036 37.7821541670221 -122.42245352721001 (37.7821541670221, -122.42245352721)
3580 7849 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 885 Franklin St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1997 12:00:00 AM 3 4X4   6006124.86369 2113018.24445 37.7822915069765 -122.422471414725 (37.7822915069765, -122.422471414725)
3652 8053 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 608 Fulton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/24/1990 12:00:00 AM 30 3X3   6004781.8955 2111614.8115 37.778362174466295 -122.427017501013 (37.7783621744663, -122.427017501013)
3653 18293 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 2000 Post St 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 4X4   6002259.4651 2114036.7138 37.7848691499899 -122.435916853386 (37.7848691499899, -122.435916853386)
3664 18949 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 2838 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6001202.00999 2115627.7019 37.7891774657247 -122.43968939755699 (37.7891774657247, -122.439689397557)
3731 15515 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 2763 Mission St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6007078.6273 2102287.5862 37.7528814055888 -122.41841070542401 (37.7528814055888, -122.418410705424)
3746 253553 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 2763 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4X4   6007078.6273 2102287.5862 37.7528814055888 -122.41841070542401 (37.7528814055888, -122.418410705424)
3778 23411 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1755 Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6006198.56305 2116531.68812 37.7919427119246 -122.42246617527799 (37.7919427119246, -122.422466175278)
3895 20182 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1225 Steiner St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 3X3   6002796.4844 2112525.5787 37.7807504459126 -122.433950889197 (37.7807504459126, -122.433950889197)
3907 253159 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 500 Peru Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/28/2017 02:21:00 PM 3 3x3   6004815.0 2092724.0 37.7264942782417 -122.425558174045 (37.7264942782417, -122.425558174045)
3908 5846 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 909X Franklin St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 4X4   6006100.84256 2113204.14293 37.7828005835141 -122.422567731241 (37.7828005835141, -122.422567731241)
3931 179081 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 72 Edinburgh St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/04/2017 10:13:00 AM 3 Width 3ft   6004328.31139 2093147.65709 37.7276300348981 -122.42727080240499 (37.7276300348981, -122.427270802405)
3942 179080 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 72X Edinburgh St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/04/2017 10:09:00 AM 3 Width 3ft   6004338.45578 2093161.16244 37.7276676912897 -122.42723669472099 (37.7276676912897, -122.427236694721)
3961 176258 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 2 Edinburgh St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 09:09:00 AM 3 Width 3ft   6004488.69759 2093400.00725 37.7283320015991 -122.42673430826 (37.7283320015991, -122.42673430826)
3975 102690 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 2121 Scott St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 3x3   6001369.63978 2115762.6346400003 37.789557495824106 -122.43911909516501 (37.7895574958241, -122.439119095165)
3976 179076 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 2 Edinburgh St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 09:01:00 AM 3 Width 3ft   6004498.06671 2093415.7797400001 37.7283758390625 -122.426703041509 (37.7283758390625, -122.426703041509)
4004 251722 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 18 Lobos St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/05/2017 03:08:00 PM 3     5996685.56427 2088703.70423 37.7149927956564 -122.45337101855101 (37.7149927956564, -122.453371018551)
4014 216033 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 4 Lobos St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/05/2017 03:13:00 PM 3     5996833.19651 2088697.5304900003 37.7149843051513 -122.452860296276 (37.7149843051513, -122.452860296276)
4026 216034 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 8 Lobos St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/05/2017 03:11:00 PM 3     5996778.28459 2088695.06883 37.714974399131705 -122.45304991653099 (37.7149743991317, -122.453049916531)
4056 6316 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1830 Ellis St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 4X4   6002062.1887 2112973.0079 37.7819372750965 -122.43652320334299 (37.7819372750965, -122.436523203343)
4057 216656 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 193 Granada Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 02:36:00 PM 3 Width 3ft   5995617.14688 2091155.9703400002 37.7216648398335 -122.457241192542 (37.7216648398335, -122.457241192542)
4107 98607 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 2340 Jackson St 6 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   9 3x3   6002988.210519999 2116859.68166 37.792661671341705 -122.43359745208599 (37.7926616713417, -122.433597452086)
4146 216707 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 230 Faxon Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/06/2017 08:46:00 AM 3 Width 3ft   5994758.05727 2090129.91465 37.7187981581945 -122.460136518501 (37.7187981581945, -122.460136518501)
4153 216751 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 31 Granada Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/06/2017 08:38:00 AM 3 Width 3ft   5995599.77101 2090122.1597400003 37.718825243070604 -122.45722650749799 (37.7188252430706, -122.457226507498)
4159 216846 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 246 Farallones St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/06/2017 02:48:00 PM 3 Width 3ft   5994526.67673 2088421.6269099999 37.7140942946914 -122.460812565857 (37.7140942946914, -122.460812565857)
4176 9422 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 701X Golden Gate Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/09/1999 12:00:00 AM 3 3X3   6006084.9503 2112434.4577 37.7806863196559 -122.422568001024 (37.7806863196559, -122.422568001024)
4180 180661 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 551 Cordova St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/10/2017 01:41:00 PM 3 Width 5ft   6002181.0 2086340.0 37.7088160489029 -122.434207604104 (37.7088160489029, -122.434207604104)
4193 14866 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1399 McAllister St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6002549.1256 2111595.7053 37.7781832063518 -122.434740108006 (37.7781832063518, -122.434740108006)
4204 18292 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 2000 Post St 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/26/1993 12:00:00 AM 6 4X4   6002281.8567 2114040.95 37.7848820534936 -122.43583968903 (37.7848820534936, -122.43583968903)
4280 6310 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1810 Ellis St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 4X4   6002083.1708 2112974.3616 37.7819421842971 -122.43645071198 (37.7819421842971, -122.43645071198)
4298 102769 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1400 Filbert St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 3x3   6006151.87056 2119366.39832 37.7997234781035 -122.422829281062 (37.7997234781035, -122.422829281062)
4308 102694 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 2799 Clay St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 4x4   6001416.78196 2115941.58593 37.7900515321059 -122.43896881846202 (37.7900515321059, -122.438968818462)
4360 8196 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1310X Fulton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     30 3X3   6001489.6126 2111152.0859 37.7769049310776 -122.438373551392 (37.7769049310776, -122.438373551392)
4387 175897 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 275 Munich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/11/2017 09:28:00 AM 3 Width 4ft   6004496.9517 2090791.26121 37.721169426695795 -122.426520093344 (37.7211694266958, -122.426520093344)
4395 7977 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 2007 Franklin St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 3X3   6005570.41069 2117004.7305400004 37.793206111926395 -122.424673253679 (37.7932061119264, -122.424673253679)
4400 251729 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 35 Bruce Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/11/2017 10:39:00 AM 3 Width 3ft   5997172.50242 2091270.81822 37.7220693917577 -122.45187305021099 (37.7220693917577, -122.451873050211)
4415 216758 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 35 Bruce Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/11/2017 10:35:00 AM 3 Width 3ft   5997172.50242 2091270.81822 37.7220693917577 -122.45187305021099 (37.7220693917577, -122.451873050211)
4453 253083 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 2849X Alemany Blvd 23 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/13/2017 10:53:00 AM 3 3X3   5997618.33471 2088040.74004 37.7132258706419 -122.45009922742399 (37.7132258706419, -122.450099227424)
4463 14823 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1234 McAllister St 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/19/2001 12:00:00 AM 3 4X4   6003134.879 2111723.2201 37.778566567554 -122.432722886511 (37.778566567554, -122.432722886511)
4493 253082 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 2849X Alemany Blvd 15 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/13/2017 10:25:00 AM 3 3X3   5997618.33471 2088040.74004 37.7132258706419 -122.45009922742399 (37.7132258706419, -122.450099227424)
4525 23475 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 2363 Van Ness Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     8 3X3   6005818.66321 2118523.8401900004 37.7973912212721 -122.42392235573601 (37.7973912212721, -122.423922355736)
4544 253638 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 859 Vallejo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/16/2017 12:00:00 AM 3 3x3   6009440.103999999 2118743.01656 37.7981968084542 -122.411406675592 (37.7981968084542, -122.411406675592)
4554 18291 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 2000 Post St 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/20/1992 12:00:00 AM 6 4X4   6002309.6948 2114045.1862 37.7848952663203 -122.435743681544 (37.7848952663203, -122.435743681544)
4564 142521 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 301 FRANCISCO ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4   05/04/2013 12:00:00 AM 0 Width 0ft   6009485.2617 2121177.5361 37.8048839283261 -122.41142249927401 (37.8048839283261, -122.411422499274)
4571 142549 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 301 FRANCISCO ST 11 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4     9 Width 0ft   6009666.9453 2121202.0395 37.8049613971858 -122.41079549257799 (37.8049613971858, -122.410795492578)
4573 142546 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 301 FRANCISCO ST 8 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4   03/26/2016 09:47:00 AM 23 Width 0ft   6009592.8375 2121191.8795 37.8049293448711 -122.411051233847 (37.8049293448711, -122.411051233847)
4581 142526 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 301 FRANCISCO ST 17 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4     10 Width 0ft   6009810.3798 2121222.957 37.8050268727325 -122.410300597206 (37.8050268727325, -122.410300597206)
4583 142550 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 301 FRANCISCO ST 16 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4   03/26/2016 09:53:00 AM 22 Width 0ft   6009784.6811 2121219.3711 37.805015586162796 -122.41038927752199 (37.8050155861628, -122.410389277522)
4590 142522 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 301 FRANCISCO ST 12 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4     8 Width 0ft   6009689.0581 2121206.8206 37.804975764730294 -122.410719306308 (37.8049757647303, -122.410719306308)
4591 142544 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 301 FRANCISCO ST 6 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4   03/23/2016 02:55:00 PM 26 Width 0ft   6009534.8661 2121184.7078 37.8049064021217 -122.41125134413299 (37.8049064021217, -122.411251344133)
4595 142523 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 301 FRANCISCO ST 13 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4     7 Width 0ft   6009712.3662 2121206.8206 37.804977071531404 -122.410638645677 (37.8049770715314, -122.410638645677)
4612 142548 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 301 FRANCISCO ST 10 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4     7 Width 0ft   6009639.4537 2121197.2583 37.8049467277157 -122.410890292822 (37.8049467277157, -122.410890292822)
4618 20216 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1428 Steiner St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 3x3   6002742.6384 2113206.5206 37.7826170851045 -122.434185862237 (37.7826170851045, -122.434185862237)
4625 19259 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1320 Scott St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 4X4   6001796.9506 2113006.0886 37.782013030605995 -122.437443172865 (37.782013030606, -122.437443172865)
4633 160570 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 795 Naples St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/18/2017 11:41:00 AM 3 Width 0ft   6002146.9194 2089087.66438 37.716358596934796 -122.43452171951598 (37.7163585969348, -122.434521719516)
4656 160582 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 725 Naples St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/18/2017 03:12:00 PM 3 Width 0ft   6002352.537690001 2089413.73171 37.7172655758154 -122.433834295726 (37.7172655758154, -122.433834295726)
4676 160569 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 797 Naples St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/18/2017 11:33:00 AM 3 Width 0ft   6002135.10796 2089068.7183299998 37.7163059047739 -122.434561191648 (37.7163059047739, -122.434561191648)
4688 160571 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 793 Naples St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/18/2017 11:54:00 AM 3 Width 0ft   6002167.83829 2089121.34733 37.716452270331295 -122.43445182061899 (37.7164522703313, -122.434451820619)
4689 95648 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1681 Greenwich St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 3x3   6004869.27424 2119488.56695 37.799986470461 -122.42727624513 (37.799986470461, -122.42727624513)
4727 253673 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 600 x Sanchez St 1 Unaccepted Street : Yard 14 Tree 1 DPW 2       3x3   6003598.0 2104743.0 37.75942683738779 -122.43062255590701 (37.7594268373878, -122.430622555907)
4746 206086 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1337 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/19/2009 12:00:00 AM 5 Width 3ft   5991588.39226 2106545.66282 37.7636887858255 -122.472288687689 (37.7636887858255, -122.472288687689)
4860 14685 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 772 McAllister St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 4x4   6005444.6106 2112052.626 37.779601757581396 -122.42475607462099 (37.7796017575814, -122.424756074621)
4882 206247 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 502 Irving St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   5994193.69759 2106695.40852 37.7642503845792 -122.463288680925 (37.7642503845792, -122.463288680925)
4883 206248 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 502 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   5994216.193940001 2106696.29316 37.7642541095667 -122.46321093723301 (37.7642541095667, -122.463210937233)
4908 9754 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 725 Gough St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4x4   6005755.7491 2112191.3137 37.7800001281921 -122.423689574884 (37.7800001281921, -122.423689574884)
4927 5213 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 824 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2006 12:00:00 AM 5 3x3   6001558.6916 2111280.8681 37.77726246348279 -122.438143814078 (37.7772624634828, -122.438143814078)
5056 14820 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1234 McAllister St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6003198.6113 2111732.1009 37.778594566288795 -122.43250304678301 (37.7785945662888, -122.432503046783)
5235 18964 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 2900X Sacramento St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6000852.4357199995 2115585.85435 37.789042660041204 -122.440895874969 (37.7890426600412, -122.440895874969)
5240 8038 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 555 Fulton St 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   09/18/2015 12:00:00 AM 12 3X3   6005189.4271 2111616.4778 37.778389785584295 -122.425607814865 (37.7783897855843, -122.425607814865)
5241 18090 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 3000 Pine St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     16 3X3   5999493.6958 2114692.3125 37.786511749732 -122.44553264282699 (37.786511749732, -122.445532642827)
5244 235111 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 200X Prospect Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6006667.0 2098452.0 37.7423265745703 -122.41956208669599 (37.7423265745703, -122.419562086696)
5247 235113 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 200X Prospect Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6006667.0 2098452.0 37.7423265745703 -122.41956208669599 (37.7423265745703, -122.419562086696)
5248 235112 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 200X Prospect Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6006667.0 2098452.0 37.7423265745703 -122.41956208669599 (37.7423265745703, -122.419562086696)
5255 18091 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 3000 Pine St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   5999467.4746 2114690.2424 37.786504568796296 -122.44562321243299 (37.7865045687963, -122.445623212433)

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