508 rows where qSpecies_id = 25 sorted by rowid descending

View and edit SQL

rowid ▲ TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
149342 35091 Permitted Site 7 Geijera parviflora :: Australian Willow 25 920 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM 15 3x3 Permit Number 42238 5992055.93239281 2105259.4330846 37.7601841866451 -122.470577939927 (37.7601841866451, -122.470577939927) 1 8 4 56 12
149327 128871 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 2610 Clay St 21 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 5ft   6001562.05606 2116003.40074 37.7902295241198 -122.438470613846 (37.7902295241198, -122.438470613846) 13 6 1 29490 27
148769 225977 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 310 Liberty St 61 Sidewalk: Curb side : Yard Tree Private 2     14 Width 3ft   6003712.20285 2103924.72704 37.7571865237503 -122.430169210355 (37.7571865237503, -122.430169210355) 2 4 5 28862 3
147726 114483 Undocumented 4 Geijera parviflora :: Australian Willow 25 784 CLEMENTINA ST 1 Sidewalk: Curb side : Cutout Tree Private 2     2 3x2   6009096 2110140 37.7745556909018 -122.411989099957 (37.7745556909018, -122.411989099957) 8 2 9 28853 34
145759 59939 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1778 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/25/1981 12:00:00 AM 1   Permit Number 19412 5999341.88585809 2110158.12282899 37.7740533674999 -122.445731667127 (37.7740533674999, -122.445731667127) 15 5 11 29492 16
145603 176510 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 2 Brookdale Ave 7 Sidewalk: Property side : Yard Tree Private 2     8 Width 6ft   6006143.81597 2087479.56194 37.7121691699409 -122.420592382928 (37.7121691699409, -122.420592382928) 9 7 8 309 39
144609 176499 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 162 Brookdale Ave 1 Sidewalk: Property side : Yard Tree Private 2     4 Width 6ft   6005745.58119 2087451.77686 37.7120704261874 -122.421966828522 (37.7120704261874, -122.421966828522) 9 7 8 309 18
143918 32088 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 3972 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1995 12:00:00 AM 12   Permit Number 35461 6003219.31552 2104788.31954 37.7595298134806 -122.431935468059 (37.7595298134806, -122.431935468059) 2 4 5 28862 3
143314 176508 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 150 Brookdale Ave 4 Sidewalk: Property side : Yard Tree Private 2     50 Width 6ft   6005731.29388 2087351.07842 37.7117931238283 -122.422009060692 (37.7117931238283, -122.422009060692) 9 7 8 309 39
143306 225933 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1256 Treat Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6008673.75291 2101213.64343 37.7500222662216 -122.41281852357 (37.7500222662216, -122.41281852357) 2 4 7 28859 19
143129 225952 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 800 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6001178.25767 2102625.59939 37.7534755882504 -122.438839459988 (37.7534755882504, -122.438839459988) 2 4 5 28862 22
142404 29761 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 500 Francisco St 4 Sidewalk: Curb side : Cutout Tree DPW 1     6 3x3   6008886.8317032 2121139.4877644 37.8047458740943 -122.4134907456 (37.8047458740943, -122.4134907456) 3 1 10 308 23
142175 225966 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 183 Precita Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6007593.94414 2100298.17812 37.7474479361811 -122.416487731444 (37.7474479361811, -122.416487731444) 2 7 7 28859 2
142128 109686 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 190 Onondaga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/27/2015 12:00:00 AM 3 3x3 Permit Number 772797 6000260.82873 2091434.8524 37.7226961949641 -122.441209260793 (37.7226961949641, -122.441209260793) 9 7 6 28861 25
142003 10068 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 549 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x4   6005603.73706 2105778.33301 37.762383043055 -122.423759340124 (37.762383043055, -122.423759340124) 8 4 5 28859 19
141749 41187 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 380 Connecticut St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/11/2003 12:00:00 AM 8   Permit Number 46607 6013185.95339 2105307.79412 37.7615161505792 -122.39750208615 (37.7615161505792, -122.39750208615) 10 3 8 28856 29
141655 52023 Permitted Site 7 Geijera parviflora :: Australian Willow 25 20 Newman St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/15/2005 12:00:00 AM     Permit Number 48238 6006866.55802505 2096801.82623419 37.7378068034281 -122.418755072853 (37.7378068034281, -122.418755072853) 2 7 7 28859 2
141317 60696 Permitted Site 7 Geijera parviflora :: Australian Willow 25 2839 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/05/1983 12:00:00 AM     Permit Number 20342 6009224.45070504 2103317.03242809 37.7558285965659 -122.411062726793 (37.7558285965659, -122.411062726793) 2 4 7 28859 19
140391 69220 Permitted Site 7 Geijera parviflora :: Australian Willow 25 1244 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/31/1994 12:00:00 AM   3x3 Permit Number 33272 6008663.44143065 2101293.23911329 37.7502402393754 -122.412859808121 (37.7502402393754, -122.412859808121) 2 4 7 28859 19
139962 67087 Permitted Site 7 Geijera parviflora :: Australian Willow 25 2x FRANCONIA ST 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/23/1992 12:00:00 AM     Permit Number 30488 6009949 2099997 37.74675312806 -122.40832282803 (37.74675312806, -122.40832282803) 2 7 7 28859 2
139521 10000 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 136 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2     90 2X2   6005403.54778 2108183.22689 37.7689750062251 -122.424622801709 (37.7689750062251, -122.424622801709) 8 4 5 28853 19
139202 225909 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 99 Fair Oaks St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 5ft   6005410.68329 2103188.80406 37.7552619044394 -122.424242863321 (37.7552619044394, -122.424242863321) 2 4 5 28859 19
139062 142338 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 510 Central Ave 2 Sidewalk: Curb side : Yard Tree Private 2     15 Width 0ft   5999738.5075 2110257.1017 37.7743477755014 -122.444366803816 (37.7743477755014, -122.444366803816) 15 5 11 29492 16
138266 176511 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 127 Brookdale Ave 4 Sidewalk: Property side : Yard Tree Private 2     12 Width 6ft   6006104.31545 2087436.52069 37.7120487615086 -122.420725854912 (37.7120487615086, -122.420725854912) 9 7 8 309 39
138084 219015 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 178 Miramar Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   5995362.975 2091073.58019 37.7214240148917 -122.458113831693 (37.7214240148917, -122.458113831693) 9 8 6 28861 24
138074 98258 Undocumented 4 Geijera parviflora :: Australian Willow 25 2800X 16th St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6007899.1 2106885.5 37.7655523739417 -122.415898914261 (37.7655523739417, -122.415898914261) 8 4 7 28853 19
137812 192423 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 80 Carolina St 2 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 4ft   6012208.34529 2107668.53767 37.7679437428368 -122.401049131921 (37.7679437428368, -122.401049131921) 14 3 8 28856 20
137668 98257 Undocumented 4 Geijera parviflora :: Australian Willow 25 2800X 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6007899.1 2106885.5 37.7655523739417 -122.415898914261 (37.7655523739417, -122.415898914261) 8 4 7 28853 19
137615 31889 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 167 11th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/26/1995 12:00:00 AM 15   Permit Number 35321 6007897.98767 2109828.50999 37.7736331256972 -122.416111205987 (37.7736331256972, -122.416111205987) 8 2 9 28853 34
137342 32627 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 75 Boardman Pl 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1996 12:00:00 AM 15   Permit Number 37080 6011835.14299 2109991.00563 37.774299885758 -122.402503334756 (37.774299885758, -122.402503334756) 14 2 9 28853 34
136527 108571 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 223 Sweeny St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/24/2014 12:00:00 AM 3 3x3 Permit Number 772573 6009406.56 2094751.33642 37.7323192844032 -122.409828317318 (37.7323192844032, -122.409828317318) 10 3 7 309 28
136233 244047 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 400 Cole St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5997955.5586 2109119.1735 37.7711214297529 -122.450452276113 (37.7711214297529, -122.450452276113) 15 5 11 29492 9
136146 98260 Undocumented 4 Geijera parviflora :: Australian Willow 25 2800X 16th St 5 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6007899.1 2106885.5 37.7655523739417 -122.415898914261 (37.7655523739417, -122.415898914261) 8 4 7 28853 19
136070 225945 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 25 Hill St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6006157.91256 2103444.1528 37.7560051968042 -122.421676853797 (37.7560051968042, -122.421676853797) 2 4 5 28859 19
135416 219002 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1333 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   5992990.51198 2106402.84909 37.7633777040321 -122.467428846685 (37.7633777040321, -122.467428846685) 1 8 11 56 12
134411 66548 Permitted Site 7 Geijera parviflora :: Australian Willow 25 3444 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/10/1991 12:00:00 AM     Permit Number 29730 6005443.81991983 2103160.76453772 37.7551867854403 -122.424126272898 (37.7551867854403, -122.424126272898) 2 4 5 28859 19
133210 142723 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 600 FRANCISCO ST 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6008387.4711 2121064.7168 37.8045125206489 -122.415213542996 (37.8045125206489, -122.415213542996) 5 1 10 308 23
132865 225968 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 3599 24th St 3 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 3ft   6005865.3441 2101966.56287 37.7519315746039 -122.422583660903 (37.7519315746039, -122.422583660903) 2 4 5 28859 19
132781 49769 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 333 Schwerin St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/2003 12:00:00 AM 4   Permit Number 46559 6008658.89925 2086391.11579 37.7093219451162 -122.411822622426 (37.7093219451162, -122.411822622426) 9 7 8 309 39
132497 95583 Permitted Site 7 Geijera parviflora :: Australian Willow 25 320 Hill St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/2011 12:00:00 AM   3x3 Permit Number 767373 6004245 2103375 37.7557072655698 -122.428287412943 (37.7557072655698, -122.428287412943) 2 4 5 28862 22
132169 65670 Permitted Site 7 Geijera parviflora :: Australian Willow 25 954 Teresita Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/13/1990 12:00:00 AM     Permit Number 28590 5998557.99448518 2095716.03586207 37.7343541747365 -122.447403560759 (37.7343541747365, -122.447403560759) 9 7 4 59 40
131963 245455 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 2800 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6007994.6854 2106818.5473 37.7653739107422 -122.41556356407 (37.7653739107422, -122.41556356407) 8 4 7 28853 19
131459 10112 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 821 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 3x3   6005694.08607 2104163.28117 37.7579535897166 -122.423332040744 (37.7579535897166, -122.423332040744) 2 4 5 28859 19
131125 98179 Undocumented 4 Geijera parviflora :: Australian Willow 25 50-60 Camp St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005725 2106380 37.7640419231114 -122.423382710222 (37.7640419231114, -122.423382710222) 8 4 5 28859 19
131118 59938 Permitted Site 7 Geijera parviflora :: Australian Willow 25 1774 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/25/1981 12:00:00 AM     Permit Number 19411 5999360.65261909 2110160.72458075 37.7740615827199 -122.445666937047 (37.7740615827199, -122.445666937047) 15 5 11 29492 16
130161 122086 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 459 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5990589.94258 2112248.552 37.7792895311955 -122.476158542806 (37.7792895311955, -122.476158542806) 11 6 2 55 26
129759 239617 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 998 Alabama St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6009142.86586 2103412.72936 37.756086783293 -122.411351634886 (37.756086783293, -122.411351634886) 2 4 7 28859 19
129612 46907 Permitted Site 7 Geijera parviflora :: Australian Willow 25 1461 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/29/2002 12:00:00 AM     Permit Number 44964 5993949.00931755 2105566.46922701 37.7611365120681 -122.464053023285 (37.7611365120681, -122.464053023285) 1 5 11 56 12
129017 225900 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1398 Bryant St 3 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6009378.42208 2107868.1744 37.7683336277295 -122.410851658572 (37.7683336277295, -122.410851658572) 8 4 7 28853 19
128927 225953 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 245 Roanoke St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6003670.68661 2095891.30011 37.7351262474841 -122.429739824559 (37.7351262474841, -122.429739824559) 2 7 5 63 7
128761 115129 Private 9 Geijera parviflora :: Australian Willow 25 499X MAIN ST 7 Sidewalk: Curb side : Cutout Tree Private 2     6     6015842 2114626 37.7872494168956 -122.388966430338 (37.7872494168956, -122.388966430338) 6 2 9 28855 6
128657 192413 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 650 Rhode Island St 5 : Tree Private 2     8 Width 3ft   6011782.001 2105308.50285 37.7614398242054 -122.402357857724 (37.7614398242054, -122.402357857724) 10 3 8 28856 29
128154 176514 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 154 Brookdale Ave 4 Sidewalk: Property side : Yard Tree Private 2     4 Width 6ft   6006291.2518 2087400.97553 37.7119616963423 -122.420077226985 (37.7119616963423, -122.420077226985) 9 7 8 309 39
127888 67548 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1120 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/05/1992 12:00:00 AM 16   Permit Number 31094 6011900.0943 2103205.59495 37.7556722956615 -122.401801597389 (37.7556722956615, -122.401801597389) 10 3 8 28856 29
127339 225917 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 85 Liberty St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6005793.09116 2104012.03953 37.7575439026326 -122.422978889581 (37.7575439026326, -122.422978889581) 2 4 5 28859 19
126906 225940 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 183 Bartlett St 4 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6006723.95695 2102704.663 37.7540066307184 -122.419666814188 (37.7540066307184, -122.419666814188) 2 4 7 28859 19
126795 245457 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 2800 16th St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6007865.341 2106811.8898 37.7653483594859 -122.416010466111 (37.7653483594859, -122.416010466111) 8 4 7 28853 19
126766 22760 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1620 Turk St 2 Sidewalk: Curb side : Cutout Tree DPW 1     3 4X4   6002287.3238 2112301.156 37.7801053300032 -122.435696258637 (37.7801053300032, -122.435696258637) 15 5 11 29490 41
126710 46930 Permitted Site 7 Geijera parviflora :: Australian Willow 25 1 Pacheco St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/2016 12:00:00 AM 3   Permit Number 779184 5995168.47040897 2099126.50126016 37.7435241958304 -122.459369067857 (37.7435241958304, -122.459369067857) 1 8 4 59 40
126477 10165 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1019 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x4   6005763.39401 2102897.66691 37.7544824188306 -122.423002391551 (37.7544824188306, -122.423002391551) 2 4 5 28859 19
126060 10089 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 700 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     80 3X3   6005586.51976 2104851.24563 37.7598365074586 -122.423752966647 (37.7598365074586, -122.423752966647) 2 4 5 28859 19
125955 225897 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 2770 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6009476.04285 2103963.05006 37.7576165210915 -122.410238245413 (37.7576165210915, -122.410238245413) 2 4 7 28859 19
125841 26544 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 530 Francisco St 6 Sidewalk: Curb side : Cutout Tree DPW 1   06/19/1997 12:00:00 AM 3 4X4   6008751.4918274 2121120.9717011 37.8046874335197 -122.41395779393 (37.8046874335197, -122.41395779393) 3 1 10 308 23
125276 225942 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 2741 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6008447.49602 2106788.13781 37.7653158554543 -122.413995240611 (37.7653158554543, -122.413995240611) 8 4 7 28859 19
125083 34039 Permitted Site 7 Geijera parviflora :: Australian Willow 25 2741 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/1997 12:00:00 AM     Permit Number 37955 6008443.32721054 2106790.24036099 37.7653213944342 -122.414009808345 (37.7653213944342, -122.414009808345) 8 4 7 28859 19
124628 225974 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 478 Noe St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6002948.60968 2105430.29379 37.7612771701244 -122.43291756641 (37.7612771701244, -122.43291756641) 15 4 5 28862 3
124173 225898 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1398 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6009373.69267 2107922.66686 37.7684829862389 -122.410871866347 (37.7684829862389, -122.410871866347) 8 4 7 28853 19
124151 244202 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 546 Page St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6003923.0756 2109749.7244 37.7731925042221 -122.429855409854 (37.7731925042221, -122.429855409854) 7 9 11 29492 10
123075 219012 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 139 Miramar Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5995316.47386 2090822.54609 37.7207320630034 -122.458256412004 (37.7207320630034, -122.458256412004) 9 8 6 28861 24
123054 49771 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 333 Schwerin St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/2003 12:00:00 AM 1   Permit Number 46559 6008634.11039 2086335.40293 37.7091675783038 -122.411904362692 (37.7091675783038, -122.411904362692) 9 7 8 309 39
122480 38842 Permitted Site 7 Geijera parviflora :: Australian Willow 25 1273 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 40672 6001780.14804372 2110445.45784357 37.7749812288155 -122.437317892677 (37.7749812288155, -122.437317892677) 15 5 11 29492 10
121745 128876 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1237x Robert C Levy Tunl 5 Median : Yard Tree DPW 1     3     6007635.33447 2118142.36056 37.7964461660197 -122.417609134775 (37.7964461660197, -122.417609134775) 5 1 10 28858 32
121409 225926 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 448 Valley St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6002953.29528 2099219.15304 37.7442231148112 -122.43245771787 (37.7442231148112, -122.43245771787) 2 7 5 63 22
120732 81925 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 2316 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/04/2008 12:00:00 AM 6 3x3 Permit Number 50640 6007582.8644 2120346.37282 37.8024948784062 -122.417947010953 (37.8024948784062, -122.417947010953) 5 1 1 308 32
119801 32107 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 429 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1995 12:00:00 AM 10   Permit Number 35478 6002990.68319 2105750.27702 37.7621581531882 -122.432794911471 (37.7621581531882, -122.432794911471) 15 4 5 28862 3
119640 10695 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1250 Hayes St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6001856.34415 2110522.16346 37.7751961745675 -122.437059807317 (37.7751961745675, -122.437059807317) 15 5 11 29492 10
119488 59933 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 549 Central Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/25/1981 12:00:00 AM 9   Permit Number 19406 5999664.8686 2110448.6759 37.7748695877317 -122.444635305779 (37.7748695877317, -122.444635305779) 15 5 11 29492 16
119348 128867 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 2610 Clay St 16 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6001756.03579 2116033.5731 37.7903234016642 -122.437801621649 (37.7903234016642, -122.437801621649) 13 6 1 29490 27
118274 85304 Permitted Site 7 Geijera parviflora :: Australian Willow 25 417 Ashbury St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/31/2007 12:00:00 AM     Permit Number 49590 5998857 2109314 37.7717079252645 -122.447348195836 (37.7717079252645, -122.447348195836) 15 5 11 29492 9
118115 225963 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 200 Jarboe Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6007947.91694 2096980.61578 37.7383585458117 -122.415028930344 (37.7383585458117, -122.415028930344) 2 7 7 28859 2
117463 95134 Permitted Site 7 Geijera parviflora :: Australian Willow 25 450@ Wayland Somerset St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/06/2018 12:00:00 AM 3 3x3 Permit Number 781342 6010117.36612 2092259.39432 37.7255167458877 -122.407195288535 (37.7255167458877, -122.407195288535) 10 3 7 309 28
116552 65468 Permitted Site 7 Geijera parviflora :: Australian Willow 25 55 Granada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/08/1989 12:00:00 AM     Permit Number 28348 5995598.18541989 2090265.07086982 37.7192175521634 -122.457242320925 (37.7192175521634, -122.457242320925) 9 8 6 28861 24
116322 225918 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1619 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6009320.79374 2100001.018 37.7467289623867 -122.41049539576 (37.7467289623867, -122.41049539576) 2 7 7 28859 2
115177 225904 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 50 Camp St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6005635.69766 2106380.47503 37.7640381868445 -122.423691614897 (37.7640381868445, -122.423691614897) 8 4 5 28859 19
114891 219009 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 161 Miramar Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5995318.79946 2090948.50153 37.7210780403007 -122.458257484914 (37.7210780403007, -122.458257484914) 9 8 6 28861 24
113428 176518 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1501 Sunnydale Ave 1 Sidewalk: Property side : Yard Tree Private 2     5 Width 10ft   6007403.12553 2087360.36514 37.7119127723386 -122.416231391376 (37.7119127723386, -122.416231391376) 9 7 8 309 39
113210 29768 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 640 Francisco St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/01/1991 12:00:00 AM 6 6x6   6008286.5569 2121053.032 37.8044747652934 -122.415561939011 (37.8044747652934, -122.415561939011) 5 1 10 308 23
112936 142206 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1693 HAYES ST 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5999789.089 2110173.0386 37.7741198453954 -122.444185791724 (37.7741198453954, -122.444185791724) 15 5 11 29492 16
112771 51725 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1904 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/22/2005 12:00:00 AM 6   Permit Number 48537 6012320.61849 2104715.41974 37.7598414015724 -122.400453331067 (37.7598414015724, -122.400453331067) 10 3 8 28856 29
112761 69222 Permitted Site 7 Geijera parviflora :: Australian Willow 25 1250 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/15/2001 12:00:00 AM   3x3 Permit Number 33274 6008665.27491562 2101259.70225891 37.7501482575919 -122.412851097008 (37.7501482575919, -122.412851097008) 2 4 7 28859 19
111888 225939 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1037 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6009456.84269 2103117.56685 37.75529393828 -122.410244954342 (37.75529393828, -122.410244954342) 2 4 7 28859 19
111491 95562 Permitted Site 7 Geijera parviflora :: Australian Willow 25 467 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/2011 12:00:00 AM   3x3 Permit Number 767356 6003496 2099787 37.7458130504625 -122.430621674841 (37.7458130504625, -122.430621674841) 2 7 5 63 22
111282 244548 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1500 Page St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   5999285.3779 2109104.904 37.7711582700312 -122.445851374555 (37.7711582700312, -122.445851374555) 15 5 11 29492 9
110586 219014 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 154 Miramar Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5995361.04968 2090937.11704 37.721049208941 -122.45811061572 (37.721049208941, -122.45811061572) 9 8 6 28861 24
110175 192409 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 650 Rhode Island St 1 : Tree Private 2     4 Width 3ft   6011776.86645 2105375.28628 37.7616229099979 -122.40238031202 (37.7616229099979, -122.40238031202) 10 3 8 28856 29
109935 48959 Permitted Site 7 Geijera parviflora :: Australian Willow 25 1521 Florida St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/26/2002 12:00:00 AM     Permit Number 46145 6009607.60540748 2100518.70293664 37.7481664860313 -122.40954015648 (37.7481664860313, -122.40954015648) 2 7 7 28859 2
109731 45152 Permitted Site 7 Geijera parviflora :: Australian Willow 25 1619 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/22/2001 12:00:00 AM     Permit Number 44005 6009316.84366878 2099994.11121489 37.7467097764312 -122.410508567135 (37.7467097764312, -122.410508567135) 2 7 7 28859 2
109388 96194 Undocumented 4 Geijera parviflora :: Australian Willow 25 1640 Jerrold Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 4x50   6015077.4 2097255.4 37.7395111076977 -122.390397652393 (37.7395111076977, -122.390397652393) 10 3 8 58 1
109240 115128 Private 9 Geijera parviflora :: Australian Willow 25 499X MAIN ST 6 Sidewalk: Curb side : Cutout Tree Private 2     7     6015842 2114626 37.7872494168956 -122.388966430338 (37.7872494168956, -122.388966430338) 6 2 9 28855 6
109140 102653 Permitted Site 7 Geijera parviflora :: Australian Willow 25 203X Farallones St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994989.5 2088377.3 37.7139992025898 -122.459209674514 (37.7139992025898, -122.459209674514) 9 8 6 28861 24

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);