home / trees

Street_Tree_List

Data source: data.sfgov.org

131 rows where qSpecies = 99

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, DBH, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes, Neighborhoods

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
757 100848 Undocumented 3 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 1 Estero Ave 5 Sidewalk: Property side : Yard 5 Tree 1 Private 2           5992057.7 2091642.6 37.7227959320346 -122.469580550695 (37.7227959320346, -122.469580550695) 9 8 4 59 40
7385 108508 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 1617 16th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773653 5991122.736880001 2104392.51863 37.757749863741104 -122.47374214623301 (37.7577498637411, -122.473742146233) 1 8 4 56 12
7386 108509 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 1617 16th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773653 5991122.736880001 2104392.51863 37.757749863741104 -122.47374214623301 (37.7577498637411, -122.473742146233) 1 8 4 56 12
7391 108513 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 1627 16th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773657 5991127.72815 2104318.94699 37.7575481445436 -122.473719517598 (37.7575481445436, -122.473719517598) 1 8 4 56 12
7413 108533 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 816 Ortega St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/24/2014 12:00:00 AM 3 3x3 Permit Number 770006 5991523.87072 2102514.09627 37.752615432978104 -122.47221794939199 (37.7526154329781, -122.472217949392) 1 8 4 56 12
7414 108534 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 816 Ortega St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/24/2014 12:00:00 AM 3 3x3 Permit Number 770006 5991523.87072 2102514.09627 37.752615432978104 -122.47221794939199 (37.7526154329781, -122.472217949392) 1 8 4 56 12
8160 109256 DPW Maintained 1 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 1447 45th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 02/05/2015 12:00:00 AM 3 3x3 Permit Number 773538 5982122.4 2105246.9 37.7595703689296 -122.504931809897 (37.7595703689296, -122.504931809897) 1 8 3 56 35
8587 109746 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 1210 12th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 03/03/2015 12:00:00 AM 3 3x3 Permit Number 775052 5992416.0 2107171.8 37.765455855162 -122.469471856315 (37.765455855162, -122.469471856315) 11 8 11 56 12
11200 112765 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 324 Lakeview Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 08/19/2015 12:00:00 AM     Permit Number 776404 5996821.8 2089680.8 37.7176834813126 -122.45297062041 (37.7176834813126, -122.45297062041) 9 8 6 28861 24
13501 115270 DPW Maintained 1 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 2218 31st Ave 2 Sidewalk: Property side : Cutout 9 Tree 1 Private 2   01/21/2016 12:00:00 AM     Permit Number 775791 5986730.3 2100136.4 37.7458083387155 -122.48861998421499 (37.7458083387155, -122.488619984215) 1 8 3 29491 35
135107 34249 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 174 Majestic Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 07/01/2003 12:00:00 AM     Permit Number 46663 5996827.5342502 2089032.06513255 37.7159025350879 -122.452903999886 (37.7159025350879, -122.452903999886) 9 8 6 28861 24
136369 35399 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 582 29th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/16/1998 12:00:00 AM     Permit Number 38855 5986926.69713917 2111975.9353796 37.7783278988019 -122.48881101823 (37.7783278988019, -122.48881101823) 11 6 2 55 26
136379 35407 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 350 Day St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 03/16/1998 12:00:00 AM     Permit Number 38862 6003669.60279278 2098674.23740749 37.742767495227795 -122.42994201993601 (37.7427674952278, -122.429942019936) 2 7 5 63 22
136384 35411 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 1528 Noe St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 03/16/1998 12:00:00 AM     Permit Number 38866 6003290.08254962 2099339.0502527 37.744571416819205 -122.43130173778299 (37.7445714168192, -122.431301737783) 2 7 5 63 22
136395 35421 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 448 Valley St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 03/16/1998 12:00:00 AM     Permit Number 38872 6003007.05069515 2099228.88574516 37.7442528866618 -122.432272538365 (37.7442528866618, -122.432272538365) 2 7 5 63 22
136834 35828 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 759 Edinburg St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 04/23/1998 12:00:00 AM     Permit Number 39061 6002024.18545855 2089388.29442785 37.7171770923434 -122.43496743528699 (37.7171770923434, -122.434967435287) 9 7 6 28861 5
136835 35829 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 759 Edinburg St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 04/23/1998 12:00:00 AM     Permit Number 39061 6002024.18545855 2089388.29442785 37.7171770923434 -122.43496743528699 (37.7171770923434, -122.434967435287) 9 7 6 28861 5
137030 36011 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 1521 Treat Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 04/27/1998 12:00:00 AM     Permit Number 39159 6008760.15552632 2099946.60050822 37.746548097814 -122.41243018793399 (37.746548097814, -122.412430187934) 2 7 7 28859 2
137104 36082 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 350 Treat Ave 8 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 04/28/1998 12:00:00 AM     Permit Number 39194 6008595.45763242 2106539.09484621 37.7646403500491 -122.413465859831 (37.7646403500491, -122.413465859831) 8 4 7 28859 19
137375 36327 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 20 Eastwood Dr 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 05/14/1998 12:00:00 AM     Permit Number 39299 5995528.33629131 2092650.23439199 37.725762630941205 -122.457656249881 (37.7257626309412, -122.457656249881) 9 7 4 28861 40
137379 36330 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 40@San Ramon Eastwood Dr 1 Sidewalk: Property side : Cutout 9 Tree 1 Private 2   05/14/1998 12:00:00 AM     Permit Number 39300 5995640.5044713 2092769.77027097 37.7260972907371 -122.457277138944 (37.7260972907371, -122.457277138944) 9 7 4 28861 40
137381 36332 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 40 Eastwood Dr 2 Sidewalk: Property side : Cutout 9 Tree 1 Private 2   05/14/1998 12:00:00 AM     Permit Number 39300 5995640.5044713 2092769.77027097 37.7260972907371 -122.457277138944 (37.7260972907371, -122.457277138944) 9 7 4 28861 40
137459 36402 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 40 Hazelwood Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 05/18/1998 12:00:00 AM     Permit Number 39330 5996637.162687 2093931.82467289 37.729345207184 -122.453915653763 (37.729345207184, -122.453915653763) 9 7 4 28861 40
137460 36403 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 40 Hazelwood Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 05/18/1998 12:00:00 AM     Permit Number 39330 5996637.162687 2093931.82467289 37.729345207184 -122.453915653763 (37.729345207184, -122.453915653763) 9 7 4 28861 40
138519 37373 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 755 Morse St 7 Sidewalk: Property side : Cutout 9 Tree 1 Private 2 FUF 2 06/15/1998 12:00:00 AM 3 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993) 9 7 6 28861 5
138521 37375 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 755 Morse St 9 Sidewalk: Property side : Cutout 9 Tree 1 Private 2 FUF 2 06/15/1998 12:00:00 AM 3 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993) 9 7 6 28861 5
138528 37381 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 755 Morse St 15 Sidewalk: Property side : Cutout 9 Tree 1 Private 2 FUF 2 06/15/1998 12:00:00 AM 3 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993) 9 7 6 28861 5
138530 37383 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 755 Morse St 17 Sidewalk: Property side : Cutout 9 Tree 1 Private 2 FUF 2 06/15/1998 12:00:00 AM 3 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993) 9 7 6 28861 5
138532 37385 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 755 Morse St 19 Sidewalk: Property side : Cutout 9 Tree 1 Private 2 FUF 2 06/15/1998 12:00:00 AM 3 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993) 9 7 6 28861 5
138533 37386 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 755 Morse St 20 Sidewalk: Property side : Cutout 9 Tree 1 Private 2 FUF 2 06/15/1998 12:00:00 AM 3 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993) 9 7 6 28861 5
138640 37482 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 1440 16th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/30/2014 12:00:00 AM 3   Permit Number 773208 5991178.05147208 2105601.75289786 37.761073303993705 -122.473639055541 (37.7610733039937, -122.473639055541) 1 8 4 56 12
138651 37493 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 731 Judah St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/22/1998 12:00:00 AM     Permit Number 39962 5992316.91775959 2105881.3475753004 37.7619068878184 -122.469720600579 (37.7619068878184, -122.469720600579) 1 8 4 56 12
138953 37772 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 1100 Bowdoin St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 07/06/1998 12:00:00 AM     Permit Number 40110 6009544.53719553 2091052.7220808999 37.72217140174129 -122.40909041121901 (37.7221714017413, -122.409090411219) 9 3 7 309 28
138976 37794 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 347 Hamilton St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 07/06/1998 12:00:00 AM     Permit Number 40121 6009401.21501229 2092719.75650999 37.7267406980156 -122.409703450889 (37.7267406980156, -122.409703450889) 10 3 7 309 28
139030 37846 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 138 Brewster St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 07/07/1998 12:00:00 AM     Permit Number 40138 6010281.81622096 2099169.89945676 37.744500721818 -122.40711368565701 (37.744500721818, -122.407113685657) 2 7 7 28859 2
139065 37880 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 53 Hazelwood Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 07/07/1998 12:00:00 AM     Permit Number 40159 5996581.99025287 2093999.06423661 37.729526667434605 -122.454111243292 (37.7295266674346, -122.454111243292) 9 7 4 28861 40
139274 38085 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 2501 Sutter St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/04/1999 12:00:00 AM     Permit Number 40260 6000626.16659083 2114103.31583795 37.784959103725704 -122.441572302214 (37.7849591037257, -122.441572302214) 15 6 11 29490 13
139276 38087 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 2501 Sutter St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/04/1999 12:00:00 AM     Permit Number 40260 6000626.16659083 2114103.31583795 37.784959103725704 -122.441572302214 (37.7849591037257, -122.441572302214) 15 6 11 29490 13
139571 38362 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 1642 Great Hwy 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 10/27/2001 12:00:00 AM     Permit Number 40426 5980999.10411901 2103880.73539886 37.755753121966706 -122.508715227831 (37.7557531219667, -122.508715227831) 1 8 3 56 35
139855 38630 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 1540 Shafter Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 09/17/1998 12:00:00 AM     Permit Number 40564 6015248.11018923 2093961.33763054 37.7304757491105 -122.38957740844299 (37.7304757491105, -122.389577408443) 10 3 8 58 1
140947 39634 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 532 Arch St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/29/1998 12:00:00 AM     Permit Number 41029 5992763.77558421 2090734.51245254 37.720343327582995 -122.467073829079 (37.720343327583, -122.467073829079) 9 8 6 64 24
140948 39635 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 545 Arch St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/29/1998 12:00:00 AM     Permit Number 41030 5992712.45358581 2090818.32890073 37.720570504620596 -122.46725732212 (37.7205705046206, -122.46725732212) 9 8 6 64 24
140949 39636 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 545 Arch St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/29/1998 12:00:00 AM     Permit Number 41030 5992712.45358581 2090818.32890073 37.720570504620596 -122.46725732212 (37.7205705046206, -122.46725732212) 9 8 6 64 24
140950 39637 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 551 Arch St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/29/1998 12:00:00 AM     Permit Number 41031 5992712.7917316 2090860.02627115 37.7206850149703 -122.467259183552 (37.7206850149703, -122.467259183552) 9 8 6 64 24
140952 39639 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 556 Arch St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/29/1998 12:00:00 AM     Permit Number 41033 5992765.12816761 2090901.30196023 37.7208013690683 -122.46708127369101 (37.7208013690683, -122.467081273691) 9 8 6 64 24
140954 39640 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 559 Arch St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/29/1998 12:00:00 AM     Permit Number 41034 5992713.24259274 2090915.62277372 37.7208376954569 -122.467261665472 (37.7208376954569, -122.467261665472) 9 8 6 64 24
140955 39641 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 560 Arch St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/29/1998 12:00:00 AM     Permit Number 41035 5992765.35359829 2090929.1002244998 37.7208777093482 -122.467082514469 (37.7208777093482, -122.467082514469) 9 8 6 64 24
140956 39642 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 567 Arch St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/29/1998 12:00:00 AM     Permit Number 41036 5992713.69345387 2090971.21927628 37.7209903759396 -122.46726414740101 (37.7209903759396, -122.467264147401) 9 8 6 64 24
140957 39643 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 571 Arch St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/26/2000 12:00:00 AM     Permit Number 42734 5992713.91888455 2090999.01754055 37.7210667162153 -122.46726538837 (37.7210667162153, -122.46726538837) 9 8 6 64 24
140958 39644 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 574 Arch St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/29/1998 12:00:00 AM     Permit Number 41038 5992766.14260501 2091026.39407151 37.721144900106296 -122.46708685721 (37.7211449001063, -122.46708685721) 9 8 6 64 24
140959 39645 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 581 Arch St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/29/1998 12:00:00 AM     Permit Number 41039 5992714.48246081 2091068.51314927 37.7212575667576 -122.467268490802 (37.7212575667576, -122.467268490802) 9 8 6 64 24
140995 39678 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 512 Ramsell St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/29/1998 12:00:00 AM     Permit Number 41064 5993022.88525791 2090592.33519606 37.7199678962015 -122.466167852387 (37.7199678962015, -122.466167852387) 9 8 6 64 24
140996 39679 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 516 Ramsell St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/29/1998 12:00:00 AM     Permit Number 41065 5993023.20922319 2090620.12525576 37.7200442196585 -122.466168751019 (37.7200442196585, -122.466168751019) 9 8 6 64 24
141002 39684 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 176 Thrift St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/29/1998 12:00:00 AM     Permit Number 41069 5995263.47138395 2089658.04512996 37.7175315738757 -122.45835537864599 (37.7175315738757, -122.458355378646) 9 8 6 28861 24
141634 40268 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 21 Bartlett St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 05/13/1999 12:00:00 AM     Permit Number 774463 6006679.69418317 2103656.77350185 37.7566184133932 -122.419887443178 (37.7566184133932, -122.419887443178) 2 4 7 28859 19
141635 40269 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 21 Bartlett St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 05/13/1999 12:00:00 AM     Permit Number 774463 6006679.69418317 2103656.77350185 37.7566184133932 -122.419887443178 (37.7566184133932, -122.419887443178) 2 4 7 28859 19
141773 40400 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 145 Hazelwood Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/03/1999 12:00:00 AM     Permit Number 41506 5996449.60474111 2094505.49773071 37.7309096202542 -122.454605482537 (37.7309096202542, -122.454605482537) 9 7 4 28861 40
141774 40401 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 145 Hazelwood Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/03/1999 12:00:00 AM     Permit Number 41506 5996449.60474111 2094505.49773071 37.7309096202542 -122.454605482537 (37.7309096202542, -122.454605482537) 9 7 4 28861 40
141775 40402 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 509 Miramar Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/03/1999 12:00:00 AM     Permit Number 41507 5995330.55831017 2092709.7010618 37.72591454869679 -122.458344251401 (37.7259145486968, -122.458344251401) 9 7 4 28861 40
141776 40403 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 509 Miramar Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/03/1999 12:00:00 AM     Permit Number 41507 5995330.55831017 2092709.7010618 37.72591454869679 -122.458344251401 (37.7259145486968, -122.458344251401) 9 7 4 28861 40
141790 40416 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 111 Valdez Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/03/1999 12:00:00 AM     Permit Number 41517 5996295.25771979 2094268.97765556 37.7302513390624 -122.45512199740601 (37.7302513390624, -122.455121997406) 9 7 4 28861 40
141791 40417 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 111 Valdez Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/03/1999 12:00:00 AM     Permit Number 41517 5996295.25771979 2094268.97765556 37.7302513390624 -122.45512199740601 (37.7302513390624, -122.455121997406) 9 7 4 28861 40
141831 40453 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 361 Elsie St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/06/2012 12:00:00 AM     Permit Number 41538 6006450.75340608 2097077.86705956 37.738541329849504 -122.42021229953899 (37.7385413298495, -122.420212299539) 2 7 7 28859 2
141833 40455 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 383 Elsie St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/11/1999 12:00:00 AM     Permit Number 41540 6006383.45382408 2096953.23791682 37.7381953336537 -122.420436145768 (37.7381953336537, -122.420436145768) 2 7 7 28859 2
141862 40481 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 272 Lee Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/15/1999 12:00:00 AM     Permit Number 41559 5996557.87115799 2091625.74838926 37.7230087235273 -122.45402328788099 (37.7230087235273, -122.454023287881) 9 8 4 28861 24
141863 40482 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 134 Margaret Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/15/1999 12:00:00 AM     Permit Number 41560 5996780.79143793 2089419.62036157 37.7169639927415 -122.453093524364 (37.7169639927415, -122.453093524364) 9 8 6 28861 24
141932 40544 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 345 San Fernando Way 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/26/2000 12:00:00 AM     Permit Number 42654 5992118.57883529 2094673.32580486 37.731121073004 -122.46959062787501 (37.731121073004, -122.469590627875) 9 8 4 59 40
141933 40545 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 345 San Fernando Way 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/26/2000 12:00:00 AM     Permit Number 42654 5992118.57883529 2094673.32580486 37.731121073004 -122.46959062787501 (37.731121073004, -122.469590627875) 9 8 4 59 40
141936 40548 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 270 San Leandro Way 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/23/1999 12:00:00 AM     Permit Number 41593 5992351.45334565 2095075.76701195 37.7322395325949 -122.468814821303 (37.7322395325949, -122.468814821303) 9 8 4 59 40
141937 40549 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 270 San Leandro Way 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/23/1999 12:00:00 AM     Permit Number 41593 5992351.45334565 2095075.76701195 37.7322395325949 -122.468814821303 (37.7322395325949, -122.468814821303) 9 8 4 59 40
143356 41877 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 70 Belcher St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/20/2000 12:00:00 AM     Permit Number 42254 6003779.63680153 2107928.20709761 37.7681829382306 -122.43022160765899 (37.7681829382306, -122.430221607659) 7 9 5 28862 3
143471 41983 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 965 Darien Way 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/21/2000 12:00:00 AM     Permit Number 42324 5994668.75537429 2093899.33702485 37.7291429475058 -122.460718216521 (37.7291429475058, -122.460718216521) 9 8 4 59 40
143472 41984 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 965 Darien Way 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/21/2000 12:00:00 AM     Permit Number 42324 5994668.75537429 2093899.33702485 37.7291429475058 -122.460718216521 (37.7291429475058, -122.460718216521) 9 8 4 59 40
143477 41989 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 11 Keystone Way 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/21/2000 12:00:00 AM     Permit Number 42330 5994048.97742437 2092696.42288542 37.7258043598685 -122.462773593164 (37.7258043598685, -122.462773593164) 9 8 4 59 40
143483 41994 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 80 Manor Dr 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/21/2000 12:00:00 AM     Permit Number 42334 5993638.39101115 2093445.81341471 37.727838346667795 -122.464247330355 (37.7278383466678, -122.464247330355) 9 8 4 59 40
143484 41995 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 80 Manor Dr 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/21/2000 12:00:00 AM     Permit Number 42334 5993638.39101115 2093445.81341471 37.727838346667795 -122.464247330355 (37.7278383466678, -122.464247330355) 9 8 4 59 40
143485 41996 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 80 Manor Dr 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/21/2000 12:00:00 AM     Permit Number 42334 5993638.39101115 2093445.81341471 37.727838346667795 -122.464247330355 (37.7278383466678, -122.464247330355) 9 8 4 59 40
143486 41997 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 84 Manor Dr 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/21/2000 12:00:00 AM     Permit Number 42335 5993653.01173216 2093471.86469921 37.727910719829396 -122.464198677078 (37.7279107198294, -122.464198677078) 9 8 4 59 40
143487 41998 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 84 Manor Dr 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/21/2000 12:00:00 AM     Permit Number 42335 5993653.01173216 2093471.86469921 37.727910719829396 -122.464198677078 (37.7279107198294, -122.464198677078) 9 8 4 59 40
143518 42024 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 135 Pinehurst Way 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/21/2000 12:00:00 AM     Permit Number 42347 5993558.09176508 2093797.91990476 37.72880051608529 -122.464550480382 (37.7288005160853, -122.464550480382) 9 8 4 59 40
143603 42101 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 351 Flood Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/21/2000 12:00:00 AM     Permit Number 42407 5998428.27135954 2094065.90341054 37.7298158875882 -122.447733301331 (37.7298158875882, -122.447733301331) 9 7 4 28861 40
143813 42291 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 116 Detroit St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/23/2000 12:00:00 AM     Permit Number 42522 5999442.6223058 2093534.55961029 37.72841486368979 -122.44418842043999 (37.7284148636898, -122.44418842044) 9 7 4 63 40
143814 42292 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 116 Detroit St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/23/2000 12:00:00 AM     Permit Number 42522 5999442.6223058 2093534.55961029 37.72841486368979 -122.44418842043999 (37.7284148636898, -122.44418842044) 9 7 4 63 40
143825 42301 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 149 Edna St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/23/2000 12:00:00 AM     Permit Number 42528 5998727.57572945 2093347.91799135 37.7278615699416 -122.446646938075 (37.7278615699416, -122.446646938075) 9 7 4 28861 40
143826 42302 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 149 Edna St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/23/2000 12:00:00 AM     Permit Number 42528 5998727.57572945 2093347.91799135 37.7278615699416 -122.446646938075 (37.7278615699416, -122.446646938075) 9 7 4 28861 40
143827 42303 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 149 Edna St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/23/2000 12:00:00 AM     Permit Number 42528 5998727.57572945 2093347.91799135 37.7278615699416 -122.446646938075 (37.7278615699416, -122.446646938075) 9 7 4 28861 40
143828 42304 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 149 Edna St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/23/2000 12:00:00 AM     Permit Number 42528 5998727.57572945 2093347.91799135 37.7278615699416 -122.446646938075 (37.7278615699416, -122.446646938075) 9 7 4 28861 40
143829 42305 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 149 Edna St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/23/2000 12:00:00 AM     Permit Number 42528 5998727.57572945 2093347.91799135 37.7278615699416 -122.446646938075 (37.7278615699416, -122.446646938075) 9 7 4 28861 40
143904 42386 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 243 Gennessee St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/23/2000 12:00:00 AM     Permit Number 42552 5997421.03900624 2094234.76852517 37.730221931936796 -122.45122757410299 (37.7302219319368, -122.451227574103) 9 7 4 28861 40
143905 42387 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 598x Hearst Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/23/2000 12:00:00 AM     Permit Number 42553 5997475.75161149 2094410.34509601 37.7307071559588 -122.451051082577 (37.7307071559588, -122.451051082577) 9 7 4 59 40
143906 42388 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 598x Hearst Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/23/2000 12:00:00 AM     Permit Number 42553 5997475.75161149 2094410.34509601 37.7307071559588 -122.451051082577 (37.7307071559588, -122.451051082577) 9 7 4 59 40
143907 42389 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 598x Hearst Ave 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/23/2000 12:00:00 AM     Permit Number 42553 5997475.75161149 2094410.34509601 37.7307071559588 -122.451051082577 (37.7307071559588, -122.451051082577) 9 7 4 59 40
143909 42390 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 598x Hearst Ave 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/23/2000 12:00:00 AM     Permit Number 42553 5997475.75161149 2094410.34509601 37.7307071559588 -122.451051082577 (37.7307071559588, -122.451051082577) 9 7 4 59 40
143910 42391 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 300 Gennessee St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/23/2000 12:00:00 AM     Permit Number 42553 5997475.75161149 2094410.34509601 37.7307071559588 -122.451051082577 (37.7307071559588, -122.451051082577) 9 7 4 59 40
143911 42392 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 300 Gennessee St 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/23/2000 12:00:00 AM     Permit Number 42553 5997475.75161149 2094410.34509601 37.7307071559588 -122.451051082577 (37.7307071559588, -122.451051082577) 9 7 4 59 40
143912 42393 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 598x Hearst Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/23/2000 12:00:00 AM     Permit Number 42553 5997475.75161149 2094410.34509601 37.7307071559588 -122.451051082577 (37.7307071559588, -122.451051082577) 9 7 4 59 40
143923 42402 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 50 Hearst Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/23/2000 12:00:00 AM     Permit Number 42556 6000898.48623088 2094375.50054285 37.7308068438612 -122.439215689304 (37.7308068438612, -122.439215689304) 9 7 4 63 40
143924 42403 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 50 Hearst Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/23/2000 12:00:00 AM     Permit Number 42556 6000898.48623088 2094375.50054285 37.7308068438612 -122.439215689304 (37.7308068438612, -122.439215689304) 9 7 4 63 40
143973 42448 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 378 Mangels Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/23/2000 12:00:00 AM     Permit Number 42591 5998927.04125576 2095270.07473747 37.73315075299129 -122.44609558436001 (37.7331507529913, -122.44609558436) 9 7 4 59 40
143985 42459 Permitted Site 2 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 99 618 Mangels Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/23/2000 12:00:00 AM     Permit Number 42602 5997329.50843003 2095294.95804013 37.7331277180893 -122.451620450819 (37.7331277180893, -122.451620450819) 9 7 4 59 40

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