Street_Tree_List

Data source: data.sfgov.org

357 rows where qSpecies = 31 sorted by qLegalStatus

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize

Link rowid TreeID qLegalStatus ▼ qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
76 241180 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 300 Duboce Ave 3 Front Yard : Yard 7 Tree 1 Private 1   02/20/2001 12:00:00 AM 7 Width 3ft Permit Number 43693 6004770.13014 2108408.30025 37.7695572102182 -122.426829784767 (37.7695572102182, -122.426829784767)
82 241178 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 300 Duboce Ave 1 Front Yard : Yard 7 Tree 1 Private 1   02/20/2001 12:00:00 AM 8 Width 3ft Permit Number 43693 6004795.3896699995 2108410.1055900003 37.769563595403106 -122.42674254153299 (37.7695635954031, -122.426742541533)
90 241179 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 300 Duboce Ave 2 Front Yard : Yard 7 Tree 1 Private 1   02/20/2001 12:00:00 AM 7 Width 3ft Permit Number 43693 6004783.47466 2108409.88584 37.769562318364 -122.426783739481 (37.769562318364, -122.426783739481)
91 241181 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 300 Duboce Ave 4 Front Yard : Yard 7 Tree 1 Private 1   02/20/2001 12:00:00 AM 8 Width 3ft Permit Number 43693 6004757.3052900005 2108409.26199 37.7695591257908 -122.42687421397 (37.7695591257908, -122.42687421397)
6292 87392 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 3322 Fillmore St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/24/2015 12:00:00 AM 3 3x3 Permit Number 773384 6002333.63287 2119648.2941900003 37.800281314083705 -122.43606195061199 (37.8002813140837, -122.436061950612)
6671 87391 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 3322 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/24/2015 12:00:00 AM 3 3x3 Permit Number 773384 6002335.87278 2119635.99284 37.800247665053 -122.43605331890801 (37.800247665053, -122.436053318908)
15504 49998 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1101X 19th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/25/2003 12:00:00 AM 12 3x3 Permit Number 46740 6014225.48172 2105233.1729900003 37.7613690835438 -122.39390153433901 (37.7613690835438, -122.393901534339)
17013 16027 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 160 Monterey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/23/2005 12:00:00 AM 3 3X3   6001078.56062 2094701.12537 37.7317111799206 -122.43861646769899 (37.7317111799206, -122.438616467699)
18197 34055 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 375 Alabama St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/05/1997 12:00:00 AM     Permit Number 37958 6008950.19472335 2106493.86234805 37.7645360636147 -122.41223571697999 (37.7645360636147, -122.41223571698)
18492 63236 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 3634 20th St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1 FUF 1 01/13/1987 12:00:00 AM 12   Permit Number 23784 6006063.67565171 2104362.69748074 37.7585219924343 -122.422068008351 (37.7585219924343, -122.422068008351)
18713 34080 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 240 Shotwell St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/05/1997 12:00:00 AM 6 3x3 Permit Number 37968 6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551068999 (37.7627561815899, -122.41623551069)
24952 34654 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 2000 Kirkham St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/1997 12:00:00 AM 3   Permit Number 38332 5988619.0903 2105142.8889 37.7596648557466 -122.482455667505 (37.7596648557466, -122.482455667505)
26649 49071 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1970 Ocean Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/07/2003 12:00:00 AM     Permit Number 46231 5993706.31601319 2092791.54243423 37.7260457932168 -122.46396504093 (37.7260457932168, -122.46396504093)
29943 83166 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1089 Gilman Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/02/2009 12:00:00 AM 7 3x3 Permit Number 52361 6015096.6014 2089812.1317 37.719074451264 -122.389811494874 (37.719074451264, -122.389811494874)
31101 66988 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1445 Green St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/12/1992 12:00:00 AM 12   Permit Number 30339 6006117.71616 2118619.27503 37.7976701397196 -122.422894339811 (37.7976701397196, -122.422894339811)
47070 83362 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 3325 Rivera St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/01/2008 12:00:00 AM 5 3x3 Permit Number 51120 5982822.4546 2100126.935 37.745553538391206 -122.50213183404101 (37.7455535383912, -122.502131834041)
48125 36793 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1350 Donner Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM 8 3x3 Permit Number 39527 6015250.697000001 2090820.757 37.721852482589796 -122.38934923747601 (37.7218524825898, -122.389349237476)
54785 66435 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 154 Highland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/29/2016 12:00:00 AM 3   Permit Number 776442 6005832.64379623 2096619.46427693 37.7372478105316 -122.422316867971 (37.7372478105316, -122.422316867971)
54816 57900 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1324 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/09/1977 12:00:00 AM 5   Permit Number 16856 6001502.5818 2110462.7186 37.77501283944979 -122.438279288937 (37.7750128394498, -122.438279288937)
59569 115612 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1400 16th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 4x4   6012209.3182 2107055.3618 37.7662601539356 -122.401002678345 (37.7662601539356, -122.401002678345)
61689 42736 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 2155 Bay Shore Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/2000 12:00:00 AM     Permit Number 42735 6011836.19977805 2087516.89388515 37.712590845234296 -122.400920338197 (37.7125908452343, -122.400920338197)
62417 52600 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1360WASHINGTON Jones St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/03/2006 12:00:00 AM 9   Permit Number 48694 6008503.01401 2117214.59757 37.793947543601 -122.41454108323 (37.793947543601, -122.41454108323)
68713 69181 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1335 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/26/1994 12:00:00 AM 12   Permit Number 33220 5982114.4178 2105957.0803 37.761519851873295 -122.505012044902 (37.7615198518733, -122.505012044902)
69093 114917 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 86 Carr St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/04/2016 12:00:00 AM 8   Permit 774770 6012955.87899 2090602.59506 37.721125958889104 -122.397266597771 (37.7211259588891, -122.397266597771)
75251 84928 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1500@Polk Broadway 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/06/2007 12:00:00 AM 6   Permit Number 49344 6006295.343780001 2118001.00844 37.79598255651371 -122.422235750095 (37.7959825565137, -122.422235750095)
80153 82685 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 35 Jennings Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/08/2009 12:00:00 AM   3x3 Permit Number 52459 6012802.99497586 2089176.16957459 37.7172007679129 -122.397695078281 (37.7172007679129, -122.397695078281)
80956 34053 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 375 Alabama St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/05/1997 12:00:00 AM     Permit Number 37958 6008950.19472335 2106493.86234805 37.7645360636147 -122.41223571697999 (37.7645360636147, -122.41223571698)
81608 44006 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 2701X 17th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/12/2015 12:00:00 AM 3   Permit Number 43559. Tree 4 on 17th St 6009464.30573862 2106385.10315991 37.7642662704227 -122.41044985886299 (37.7642662704227, -122.410449858863)
81701 52306 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 715 Buena Vista Ave West 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/29/2016 12:00:00 AM 3   Permit Number 48465 5999876.8 2107852.1 37.7677521370965 -122.443715612896 (37.7677521370965, -122.443715612896)
82313 64622 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 350 San Carlos St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/15/1988 12:00:00 AM     Permit Number 25527 6006698.09280064 2104074.24597744 37.75776573278821 -122.41985343647801 (37.7577657327882, -122.419853436478)
83463 49161 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 804 Faxon Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/23/2003 12:00:00 AM     Permit Number 46282 5994926.32764665 2093370.69967083 37.7277062535492 -122.45978949774499 (37.7277062535492, -122.459789497745)
83681 34052 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 375 Alabama St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/05/1997 12:00:00 AM     Permit Number 37958 6008950.19472335 2106493.86234805 37.7645360636147 -122.41223571697999 (37.7645360636147, -122.41223571698)
86383 34081 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 240 SHOTWELL ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/05/1997 12:00:00 AM 6 3x3 Permit Number 37968 6007737.2 2106597.0 37.764751116814296 -122.41643845462299 (37.7647511168143, -122.416438454623)
86818 68587 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 104 Laidley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/24/1994 12:00:00 AM     Permit Number 32485 6003450.61209517 2097770.88653532 37.7402746975659 -122.430634780555 (37.7402746975659, -122.430634780555)
86898 34083 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 240 Shotwell St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/05/1997 12:00:00 AM 6 3x3 Permit Number 37968 6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551068999 (37.7627561815899, -122.41623551069)
87190 106452 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 56 Lucy St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/28/2014 12:00:00 AM 3   Permit Number 772906 6014092.7 2093830.3 37.7300518134974 -122.393562691323 (37.7300518134974, -122.393562691323)
87568 67821 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 669 Mississippi St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/12/1993 12:00:00 AM     Permit Number 31477 6014155.20534869 2104021.00071857 37.7580368157249 -122.394059730987 (37.7580368157249, -122.394059730987)
89328 31970 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1350 Florida St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/30/1995 12:00:00 AM     Permit Number 35371 6009512.01927897 2101306.3823381998 37.7503239226813 -122.409926287411 (37.7503239226813, -122.409926287411)
89857 49072 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1970 Ocean Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/07/2003 12:00:00 AM     Permit Number 46231 5993706.31601319 2092791.54243423 37.7260457932168 -122.46396504093 (37.7260457932168, -122.46396504093)
90069 40438 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 400 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/10/1999 12:00:00 AM     Permit Number 41530 6007160.84774193 2097270.742449 37.7391109088923 -122.417770796303 (37.7391109088923, -122.417770796303)
91227 67800 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 4318 26th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/17/1992 12:00:00 AM     Permit Number 31444 6001831.31402978 2100620.67337741 37.7480076719463 -122.43643756932501 (37.7480076719463, -122.436437569325)
93469 69068 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1407 14th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/10/1994 12:00:00 AM     Permit Number 33076 5991768.06854816 2105844.04694914 37.76177273191679 -122.471616117782 (37.7617727319168, -122.471616117782)
93667 49070 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1970 Ocean Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/07/2003 12:00:00 AM     Permit Number 46231 5993706.31601319 2092791.54243423 37.7260457932168 -122.46396504093 (37.7260457932168, -122.46396504093)
94065 41897 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 2500 Market St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/20/2000 12:00:00 AM     Permit Number 42262 6001987.05760353 2105790.14936536 37.762210660505 -122.436268917311 (37.762210660505, -122.436268917311)
94918 42310 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 249 Edna St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/23/2000 12:00:00 AM     Permit Number 42531 5998732.34943109 2093642.59637242 37.7286709604577 -122.446651628377 (37.7286709604577, -122.446651628377)
94982 39859 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 70 13th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/18/2008 12:00:00 AM   3x3 Permit Number 50122 6008235.62773227 2108364.64558499 37.7696326766808 -122.41483963035499 (37.7696326766808, -122.414839630355)
95230 67807 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 6 Fountain St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/17/1992 12:00:00 AM     Permit Number 31458 6000311.37446381 2101639.91617819 37.7507197829758 -122.441766583241 (37.7507197829758, -122.441766583241)
95324 49073 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1970 Ocean Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/07/2003 12:00:00 AM     Permit Number 46231 5993706.31601319 2092791.54243423 37.7260457932168 -122.46396504093 (37.7260457932168, -122.46396504093)
97141 88373 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 45 Sheridan St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/20/2005 12:00:00 AM   2x3 Permit Number 48123 6009306.0 2109414.0 37.77257404455771 -122.411211370961 (37.7725740445577, -122.411211370961)
98175 44261 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 300 Duboce Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/20/2001 12:00:00 AM     Permit Number 43693 6004891.25445895 2108442.06671817 37.769656772496795 -122.426413224583 (37.7696567724968, -122.426413224583)
98234 37726 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 2858 25th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/01/1998 12:00:00 AM     Permit Number 40090 6010246.00158069 2101670.73784629 37.7513654710612 -122.407413798897 (37.7513654710612, -122.407413798897)
98438 117606 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 420 Castro St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3X3   6002292.2454566 2105806.2278627 37.7622721434766 -122.43521453981701 (37.7622721434766, -122.435214539817)
98468 34082 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 240 Shotwell St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/05/1997 12:00:00 AM 6 3x3 Permit Number 37968 6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551068999 (37.7627561815899, -122.41623551069)
98537 34079 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 240 Shotwell St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/05/1997 12:00:00 AM 6 3x3 Permit Number 37968 6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551068999 (37.7627561815899, -122.41623551069)
98559 40735 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 84 Putnam St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/12/1999 12:00:00 AM     Permit Number 41714 6009129.35799057 2096983.96477733 37.7384340613324 -122.410944305546 (37.7384340613324, -122.410944305546)
99383 49074 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1970 Ocean Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/07/2003 12:00:00 AM     Permit Number 46231 5993706.31601319 2092791.54243423 37.7260457932168 -122.46396504093 (37.7260457932168, -122.46396504093)
100434 108225 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 240 Shotwell St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6007737.2 2106597.0 37.764751116814296 -122.41643845462299 (37.7647511168143, -122.416438454623)
101513 83941 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 60 13th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/18/2008 12:00:00 AM   3X3 Permit Number 50121 6008302.41836553 2108360.42350377 37.7696248364946 -122.41460830425899 (37.7696248364946, -122.414608304259)
101582 42735 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 2155 Bay Shore Blvd 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/2000 12:00:00 AM     Permit Number 42735 6011836.19977805 2087516.89388515 37.712590845234296 -122.400920338197 (37.7125908452343, -122.400920338197)
101783 47561 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 580 Capp St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/14/2002 12:00:00 AM     Permit Number 45422 6007250.69827751 2103936.71356757 37.7574192165742 -122.41793254418002 (37.7574192165742, -122.41793254418)
101992 66205 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 285 Mullen Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/03/1990 12:00:00 AM     Permit Number 29289 6010420.85602386 2100006.0506029 37.746804390663 -122.406691826217 (37.746804390663, -122.406691826217)
102992 34050 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 375 Alabama St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/05/1997 12:00:00 AM     Permit Number 37958 6008950.19472335 2106493.86234805 37.7645360636147 -122.41223571697999 (37.7645360636147, -122.41223571698)
103766 85491 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 4400 24th St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/05/2007 12:00:00 AM   3x3 Permit Number 52154 6000641.0 2101716.0 37.7509474670616 -122.440632169404 (37.7509474670616, -122.440632169404)
105088 67713 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 557 02nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/19/1992 12:00:00 AM     Permit Number 31325 6014732.24235944 2112894.33120186 37.782433074017504 -122.392684800601 (37.7824330740175, -122.392684800601)
105310 42309 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 249 Edna St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/23/2000 12:00:00 AM     Permit Number 42531 5998732.34943109 2093642.59637242 37.7286709604577 -122.446651628377 (37.7286709604577, -122.446651628377)
105965 108221 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 240 Shotwell St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6007737.2 2106597.0 37.764751116814296 -122.41643845462299 (37.7647511168143, -122.416438454623)
106308 34076 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 2851X 16th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/19/2011 12:00:00 AM 6 3x3 Permit Number 768574 6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551068999 (37.7627561815899, -122.41623551069)
106791 44009 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 2701X 17th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/12/2015 12:00:00 AM 3   Permit Number 43559. Tree 1 on 17th St 6009464.30573862 2106385.10315991 37.7642662704227 -122.41044985886299 (37.7642662704227, -122.410449858863)
107827 115617 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1400 16th St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4x4   6012270.55026102 2107054.03832976 37.7662599354936 -122.400790794031 (37.7662599354936, -122.400790794031)
107863 39860 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 70 13th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/18/2008 12:00:00 AM   3x3 Permit Number 50122 6008235.62773227 2108364.64558499 37.7696326766808 -122.41483963035499 (37.7696326766808, -122.414839630355)
108893 44008 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 2701X 17th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/12/2015 12:00:00 AM 3   Permit Number 43559. Tree 2 on 17th St 6009464.30573862 2106385.10315991 37.7642662704227 -122.41044985886299 (37.7642662704227, -122.410449858863)
109165 44264 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 300 Duboce Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/20/2001 12:00:00 AM     Permit Number 43693 6004891.25445895 2108442.06671817 37.769656772496795 -122.426413224583 (37.7696567724968, -122.426413224583)
109593 42738 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 2155 Bay Shore Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/2000 12:00:00 AM     Permit Number 42735 6011836.19977805 2087516.89388515 37.712590845234296 -122.400920338197 (37.7125908452343, -122.400920338197)
110007 115616 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1400 16th St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4x4   6012270.55026102 2107054.03832976 37.7662599354936 -122.400790794031 (37.7662599354936, -122.400790794031)
110283 34049 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 375 Alabama St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/05/1997 12:00:00 AM     Permit Number 37958 6008950.19472335 2106493.86234805 37.7645360636147 -122.41223571697999 (37.7645360636147, -122.41223571698)
111471 52313 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 4400HOFFMAN 24th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/22/2009 12:00:00 AM   3x3 Permit Number 52154 6000634.55195661 2101724.81174328 37.7509712947951 -122.440655099281 (37.7509712947951, -122.440655099281)
111680 34054 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 375 Alabama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/05/1997 12:00:00 AM     Permit Number 37958 6008950.19472335 2106493.86234805 37.7645360636147 -122.41223571697999 (37.7645360636147, -122.41223571698)
111888 49075 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1970 Ocean Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/07/2003 12:00:00 AM     Permit Number 46231 5993706.31601319 2092791.54243423 37.7260457932168 -122.46396504093 (37.7260457932168, -122.46396504093)
112114 42733 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 2155 Bay Shore Blvd 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/2000 12:00:00 AM     Permit Number 42735 6011836.19977805 2087516.89388515 37.712590845234296 -122.400920338197 (37.7125908452343, -122.400920338197)
112598 47560 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 580 Capp St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/14/2002 12:00:00 AM     Permit Number 45422 6007250.69827751 2103936.71356757 37.7574192165742 -122.41793254418002 (37.7574192165742, -122.41793254418)
113895 52312 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 4400HOFFMAN 24th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/22/2009 12:00:00 AM   3x3 Permit Number 52154 6000634.55195661 2101724.81174328 37.7509712947951 -122.440655099281 (37.7509712947951, -122.440655099281)
113940 107411 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 3634 20th St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1       3x3   6006068.0 2104353.0 37.7584956093101 -122.422052363883 (37.7584956093101, -122.422052363883)
114146 34047 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 375 Alabama St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/05/1997 12:00:00 AM     Permit Number 37958 6008950.19472335 2106493.86234805 37.7645360636147 -122.41223571697999 (37.7645360636147, -122.41223571698)
114868 83791 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 369 Prentiss St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/18/2008 12:00:00 AM   3x3 Permit Number 50933 6008828.16902132 2097088.78446754 37.7387049796432 -122.411993079981 (37.7387049796432, -122.411993079981)
115414 52311 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 4400HOFFMAN 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/22/2009 12:00:00 AM   3x3 Permit Number 52154 6000634.55195661 2101724.81174328 37.7509712947951 -122.440655099281 (37.7509712947951, -122.440655099281)
116223 44262 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 300 Duboce Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/20/2001 12:00:00 AM     Permit Number 43693 6004891.25445895 2108442.06671817 37.769656772496795 -122.426413224583 (37.7696567724968, -122.426413224583)
116426 65602 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 114 Maynard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/06/1990 12:00:00 AM 13   Permit Number 28504 6004165.03379 2093741.9135900002 37.729252495484 -122.427877581308 (37.729252495484, -122.427877581308)
117278 50801 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 466 Staples Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/11/2004 12:00:00 AM     Permit Number 47598 5997189.59146779 2093842.28323419 37.7291310061031 -122.451999409113 (37.7291310061031, -122.451999409113)
117733 62050 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 70 13th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/18/2008 12:00:00 AM   3x3 Permit Number 50122 6008120.0 2108416.0 37.769767186200795 -122.41524321981701 (37.7697671862008, -122.415243219817)
117817 42739 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 2155 Bay Shore Blvd 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/2000 12:00:00 AM     Permit Number 42735 6011836.19977805 2087516.89388515 37.712590845234296 -122.400920338197 (37.7125908452343, -122.400920338197)
118122 108224 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 240 Shotwell St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6007737.2 2106597.0 37.764751116814296 -122.41643845462299 (37.7647511168143, -122.416438454623)
118194 108227 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 240 Shotwell St 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6007737.2 2106597.0 37.764751116814296 -122.41643845462299 (37.7647511168143, -122.416438454623)
118249 39861 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 70 13th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/18/2008 12:00:00 AM   3x3 Permit Number 50122 6008235.62773227 2108364.64558499 37.7696326766808 -122.41483963035499 (37.7696326766808, -122.414839630355)
118491 106781 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1177 De Haro St 2 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   06/03/2014 12:00:00 AM     Permit Number 773142 6012276.4 2102941.5 37.7549681417933 -122.400481655091 (37.7549681417933, -122.400481655091)
119574 47386 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 400 Ellington Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/13/2002 12:00:00 AM     Permit Number 45302 5998534.7421818 2087640.83447452 37.712180218724896 -122.446903063491 (37.7121802187249, -122.446903063491)
119778 51920 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 45 Sheridan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/20/2005 12:00:00 AM   2x3 Permit Number 48123 6009316.82358159 2109402.74774996 37.772543755510895 -122.41117313594499 (37.7725437555109, -122.411173135945)
120475 108220 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 240 Shotwell St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6007737.2 2106597.0 37.764751116814296 -122.41643845462299 (37.7647511168143, -122.416438454623)
120632 42737 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 2155 Bay Shore Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/2000 12:00:00 AM     Permit Number 42735 6011836.19977805 2087516.89388515 37.712590845234296 -122.400920338197 (37.7125908452343, -122.400920338197)
120751 34077 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 2851X 16th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/19/2011 12:00:00 AM 6 3x3 Permit Number 768574 6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551068999 (37.7627561815899, -122.41623551069)
120865 49076 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1970 Ocean Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/07/2003 12:00:00 AM     Permit Number 46231 5993706.31601319 2092791.54243423 37.7260457932168 -122.46396504093 (37.7260457932168, -122.46396504093)

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