Street_Tree_List

Data source: data.sfgov.org

6,952 rows where qSpecies = 26

View and edit SQL

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
2418 235026 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 541 Douglass St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/22/1991 12:00:00 AM 7 Width 3ft Permit Number 29690 6001207.084969999 2103119.58489 37.7548335932981 -122.43877516473499 (37.7548335932981, -122.438775164735)
2428 235022 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 571 Douglass St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/11/1986 12:00:00 AM 14 Width 3ft Permit Number 22679 6001215.76301 2102992.6268700003 37.7544854909317 -122.43873605683399 (37.7544854909317, -122.438736056834)
2432 235024 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 553 Douglass St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/11/1986 12:00:00 AM 12 Width 3ft Permit Number 22676 6001208.88522 2103083.2214200003 37.754733850411 -122.4387663334 (37.754733850411, -122.4387663334)
2443 235025 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 547 Douglass St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/11/1986 12:00:00 AM 12 Width 3ft Permit Number 22675 6001207.505890001 2103104.6823400003 37.754792698442294 -122.43877264125099 (37.7547926984423, -122.438772641251)
2450 235023 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 559 Douglass St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/11/1986 12:00:00 AM 14 Width 3ft Permit Number 22677 6001213.00854 2103053.34864 37.7546520615499 -122.438749933385 (37.7546520615499, -122.438749933385)
2474 13234 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 2301X Lombard St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6001261.9345 2119300.1034 37.7992643314035 -122.439745463198 (37.7992643314035, -122.439745463198)
2486 98136 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 3101 Scott St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 3x3   6000916.131030001 2119057.7300299997 37.798579149274 -122.440924663139 (37.798579149274, -122.440924663139)
2495 13230 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 2301X Lombard St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     15 3X3   6001287.1241 2119305.7914 37.7992813828917 -122.439658706658 (37.7992813828917, -122.439658706658)
2545 138184 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1865 Buchanan St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     10 Width 0ft   6003938.7944 2114760.9916 37.7869530894134 -122.430158607711 (37.7869530894134, -122.430158607711)
2558 98632 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 3500X Fillmore St 11 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   6 3x4   6002258.48202 2120196.40471 37.801782011886 -122.43636125128799 (37.801782011886, -122.436361251288)
2575 253126 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 182 London St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/19/2017 12:00:00 AM 3 3x3 Permit Number 779117 6002742.73008 2092646.2038099999 37.726163358663705 -122.432716365158 (37.7261633586637, -122.432716365158)
2584 178485 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 277 Edinburgh St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6003684.78158 2092034.78148 37.724537911193295 -122.429416163945 (37.7245379111933, -122.429416163945)
2600 143226 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1931 GRANT AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 0ft   6010322.1986 2121149.6678 37.804854315613 -122.408524208369 (37.804854315613, -122.408524208369)
2610 253145 Significant Tree 6 Pittosporum undulatum :: Victorian Box 26 801X Santiago St 1 Side Yard : Yard 17 Tree 1 Private 1           5990274.0 2099728.0 37.7448931297685 -122.47633667765699 (37.7448931297685, -122.476336677657)
2612 120193 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 400 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   5987807.29514 2113237.3235 37.7818426655183 -122.485857349295 (37.7818426655183, -122.485857349295)
2623 120194 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 400 26th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5987832.0 2113186.0 37.781703185313795 -122.485768115014 (37.7817031853138, -122.485768115014)
2649 97548 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 2812 Laguna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 3x3   6003949.4047300005 2118518.5197799997 37.7972709063909 -122.43039009285299 (37.7972709063909, -122.430390092853)
2650 253148 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 375 Naples St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/13/2000 12:00:00 AM   3x3 Permit Number 43092 6003622.0 2091383.0 37.722744709081205 -122.42958672889 (37.7227447090812, -122.42958672889)
2662 22725 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1525 Turk St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/08/1992 12:00:00 AM 12 3X3   6002739.4553 2112318.0771 37.780177462084495 -122.434133342281 (37.7801774620845, -122.434133342281)
2694 6083 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1981 Eddy St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 4X4   6000965.1944 2112415.458 37.780343987670996 -122.44027829238199 (37.780343987671, -122.440278292382)
2723 18890 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 2509 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/01/1990 12:00:00 AM 12 3X3   6002664.991880001 2115784.46882 37.7896910685235 -122.434638881376 (37.7896910685235, -122.434638881376)
2787 247283 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 521 Ashbury St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/10/1999 12:00:00 AM 5 Width 0ft Permit Number 41847 5998913.4577 2108893.2022 37.7705557475505 -122.44712261725799 (37.7705557475505, -122.447122617258)
2789 214105 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 252 Farallones St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/05/2017 12:00:00 AM 3 3x3 Permit Number 779963 5994448.04607 2088422.67439 37.714092646244396 -122.46108441741801 (37.7140926462444, -122.461084417418)
2790 20006 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 100 STAIRWAY46 26 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 2            
2804 5964 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1521X Eddy St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/09/1995 12:00:00 AM 6 3X3   6003157.2632 2112724.1229 37.7813160659364 -122.432716968768 (37.7813160659364, -122.432716968768)
2812 206249 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 450 Irving St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5994303.087119999 2106698.53981 37.7642652836473 -122.46291056368601 (37.7642652836473, -122.462910563686)
2815 206250 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 450 Irving St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5994346.04433 2106700.69098 37.7642736644092 -122.462762144062 (37.7642736644092, -122.462762144062)
2889 102687 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 2155 Scott St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 4x4   6001348.89021 2115903.63348 37.7899434614624 -122.43920099642901 (37.7899434614624, -122.439200996429)
2925 26961 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 2075X Sutter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X3   6002606.079 2114377.3094 37.7858240230682 -122.434742047375 (37.7858240230682, -122.434742047375)
2930 246112 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1261 Waller St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/29/1979 12:00:00 AM 10 Width 0ft Permit Number 17674 5999700.0931 2108425.5315 37.7693165555408 -122.44436803302901 (37.7693165555408, -122.444368033029)
3003 139363 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1590 LYON ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/14/2017 12:00:00 AM 3 Width 0ft   5999671.8855 2114244.4195 37.7852921232377 -122.444883944489 (37.7852921232377, -122.444883944489)
3124 20200 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1300X Steiner St 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/24/2005 12:00:00 AM 3 3X3   6002780.7817 2112950.9036 37.78191739001421 -122.434035624824 (37.7819173900142, -122.434035624824)
3149 253338 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 324 Carl St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       6x10   5996595.0 2107026.0 37.7652961513923 -122.455007196131 (37.7652961513923, -122.455007196131)
3179 253343 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 200 Arguello Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x6 Permit Number 778434 5995550.1802199995 2114806.2223 37.786598594028504 -122.459184390305 (37.7865985940285, -122.459184390305)
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)
3189 253342 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 200 Arguello Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x6 Permit Number 778434 5995550.1802199995 2114806.2223 37.786598594028504 -122.459184390305 (37.7865985940285, -122.459184390305)
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)
3436 100973 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 450X Chestnut St 5 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW 4   0   Permit Number 37341 6009614.0 2121059.9 37.8045681487804 -122.410968670823 (37.8045681487804, -122.410968670823)
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)
3509 235175 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 410 Diamond St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2000 12:00:00 AM 7 Width 3ft Permit Number 43122 6001776.62521 2103418.64193 37.7556871173699 -122.436826947206 (37.7556871173699, -122.436826947206)
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)
3687 152811 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 2901 25th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/18/2017 12:00:00 AM 3 6x6 Permit Number 777487 6009988.15821 2101607.87857 37.7511784382559 -122.40830102206999 (37.7511784382559, -122.40830102207)
3691 152812 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 2901 25th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/18/2017 12:00:00 AM 3 6x6 Permit Number 777487 6010002.42353 2101608.75594 37.751181646126795 -122.40825175271401 (37.7511816461268, -122.408251752714)
3700 152810 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 2901 25th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/18/2017 12:00:00 AM 3 6x6 Permit Number 777487 6009973.24314 2101608.01571 37.751177979599206 -122.408352609887 (37.7511779795992, -122.408352609887)
3720 54865 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1845 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/17/1972 12:00:00 AM 14   Permit Number 10724 5998997.2724 2110063.1394 37.77377288550579 -122.44691690335199 (37.7737728855058, -122.446916903352)
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)

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