968 rows where qSiteInfo = "Sidewalk: Curb side : Cutout" and qSpecies_id = 6 sorted by YCoord

View and edit SQL

qSiteInfo

  • Sidewalk: Curb side : Cutout · 968
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)
1967 259348 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450x Burrows St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 04/27/2019 12:00:00 AM 3                        
3117 260221 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2201x 22nd Ave 13 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/20/2018 12:00:00 AM 3                        
3183 260224 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2201x 22nd Ave 20 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/20/2018 12:00:00 AM 3                        
5614 259341 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 102 Bacon St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 04/27/2019 12:00:00 AM 3                        
5784 260220 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2201x 22nd Ave 12 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/20/2018 12:00:00 AM 3                        
8715 260222 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2201x 22nd Ave 15 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/20/2018 12:00:00 AM 3                        
11368 259340 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 102 Bacon St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 04/27/2019 12:00:00 AM 3                        
12542 262149 Private 9 Lagunaria patersonii :: Primrose Tree 6 4600 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/11/2020 12:00:00 AM 3                        
15370 50774 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6   1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47304                    
16718 262177 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 620 Rutland St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 09/07/2019 12:00:00 AM 3                        
17639 260223 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2201x 22nd Ave 19 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/20/2018 12:00:00 AM 3                        
17693 259347 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450x Burrows St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 04/27/2019 12:00:00 AM 3                        
18773 255529 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1555 O'Farrell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/12/2018 12:00:00 AM 3 3x3 Permit Number 782018                    
19156 259400 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1649 Newcomb Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/13/2018 12:00:00 AM 3                        
19327 262176 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 620 Rutland St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 09/07/2019 12:00:00 AM 3                        
57255 176878 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 526 Lathrop Ave 17 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6013154.94381 2086496.55313 37.7098626625021 -122.396290845073 (37.7098626625021, -122.396290845073) 10 3 8 309 1
169305 176877 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 526 Lathrop Ave 14 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6013098.43993 2086515.08302 37.7099103976217 -122.396487432357 (37.7099103976217, -122.396487432357) 10 3 8 309 1
127629 176876 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 526 Lathrop Ave 11 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6013031.56753 2086536.06642 37.7099642921874 -122.396720027609 (37.7099642921874, -122.396720027609) 10 3 8 309 1
79736 251742 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 300 Naylor St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002771 2086560 37.7094535905361 -122.432184185389 (37.7094535905361, -122.432184185389) 9 7 6 28861 5
101851 176875 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 526 Lathrop Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6012929.76757 2086570.3757 37.7100528322548 -122.397074274178 (37.7100528322548, -122.397074274178) 10 3 8 309 1
56826 176874 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 526 Lathrop Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6012843.86934 2086597.3532 37.7101221250005 -122.397373047849 (37.7101221250005, -122.397373047849) 10 3 8 309 1
192015 108829 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 545 Lathrop Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   01/06/2015 12:00:00 AM 3   Permit Number 773819 6012931.90275 2086607.74701 37.7101555653976 -122.397069513169 (37.7101555653976, -122.397069513169) 10 3 8 309 1
37255 108775 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 500X Lathrop Ave 14 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654) 10 3 8 309 1
54619 108768 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 500X Lathrop Ave 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654) 10 3 8 309 1
108222 108764 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 500X Lathrop Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654) 10 3 8 309 1
117917 108778 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 500X Lathrop Ave 17 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654) 10 3 8 309 1
134524 108772 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 500X Lathrop Ave 11 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654) 10 3 8 309 1
100552 172375 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 216 Naylor St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/11/2017 07:37:00 AM 3 Width 2ft   6002574 2086750 37.7099641176609 -122.432878614235 (37.7099641176609, -122.432878614235) 9 7 6 28861 5
174505 108825 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 146-150X Gillette Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773819 6013072.89275 2086799.91674 37.7106910734067 -122.39659568235 (37.7106910734067, -122.39659568235) 10 3 8 309 1
15168 259102 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 619 Visitacion Ave   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3     6010517.89431 2086850.21293 37.7106866494876 -122.405429914879 (37.7106866494876, -122.405429914879) 9 7 8 309 39
9408 259103 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 625 Visitacion Ave   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3     6010501.76504 2086856.29359 37.7107024439005 -122.405486089504 (37.7107024439005, -122.405486089504) 9 7 8 309 39
51610 176885 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 191 Rey St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6008580.05361 2087004.56736 37.7110019335603 -122.412138452652 (37.7110019335603, -122.412138452652) 9 7 8 309 39
132775 180842 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 87 Laura St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/10/2017 03:54:00 PM 3 Width 2ft   5997291.8877 2087045.22216 37.710473721248 -122.451155786013 (37.710473721248, -122.451155786013) 9 7 6 28861 25
84873 69398 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1174 Munich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/09/1994 12:00:00 AM 6   Permit Number 33502 6001210.49529 2087131.44104 37.7109340401325 -122.43761843606 (37.7109340401325, -122.43761843606) 9 7 6 28861 5
639 261347 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 3300x Alemany Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1   01/13/2020 12:00:00 AM 3 3X3 Permit Number 780859 5994476 2087151 37.7106025369579 -122.460895688785 (37.7106025369579, -122.460895688785) 9 8 6 28861 24
13199 261348 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 3300x Alemany Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1   01/13/2020 12:00:00 AM 3 3X3 Permit Number 784323 5994476 2087151 37.7106025369579 -122.460895688785 (37.7106025369579, -122.460895688785) 9 8 6 28861 24
15290 25338 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 3300X Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/13/2020 12:00:00 AM 3 3X3 Permit Number 780859 5994476 2087151 37.7106025369579 -122.460895688785 (37.7106025369579, -122.460895688785) 9 8 6 28861 24
16027 261349 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 3300x Alemany Blvd 4 Sidewalk: Curb side : Cutout Tree DPW 1   01/13/2020 12:00:00 AM 3 3X3 Permit Number 784323 5994476 2087151 37.7106025369579 -122.460895688785 (37.7106025369579, -122.460895688785) 9 8 6 28861 24
122783 159336 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 523 Ellington Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2017 10:36:00 AM 3 Width 0ft   5998080.57171 2087152.95418 37.7108146533454 -122.448437690352 (37.7108146533454, -122.448437690352) 9 7 6 28861 25
28544 159338 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 517 Ellington Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2017 11:04:00 AM 3 Width 0ft   5998112.9338 2087183.20699 37.7108995709325 -122.448328017142 (37.7108995709325, -122.448328017142) 9 7 6 28861 25
57846 159339 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 517 Ellington Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2017 11:12:00 AM 3 Width 0ft   5998126.45786 2087195.02696 37.7109327990681 -122.44828212563 (37.7109327990681, -122.44828212563) 9 7 6 28861 25
82967 25763 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1682 Geneva Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   08/20/2015 06:02:00 PM 3 2X3   6004184.86566 2087196.38583 37.711281031873 -122.427342931648 (37.711281031873, -122.427342931648) 9 7 6 28861 5
141967 159345 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 461 Ellington Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2017 11:39:00 AM 3 Width 0ft   5998268.07471 2087327.6085 37.7113049331395 -122.447802205131 (37.7113049331395, -122.447802205131) 9 7 6 28861 25
154340 176919 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 140 Seville St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 5ft   6001505.61042 2087336.29034 37.7115132862848 -122.436613103724 (37.7115132862848, -122.436613103724) 9 7 6 28861 5
81002 159346 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 461 Ellington Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2017 11:49:00 AM 3 Width 0ft   5998276.6806 2087336.80621 37.7113306798385 -122.44777312285 (37.7113306798385, -122.44777312285) 9 7 6 28861 25
139614 159347 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 461 Ellington Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2017 11:27:00 AM 3 Width 0ft   5998288.37354 2087349.92963 37.7113673820764 -122.44773365339 (37.7113673820764, -122.44773365339) 9 7 6 28861 25
171958 159348 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 461 Ellington Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2017 11:44:00 AM 3 Width 0ft   5998312.68186 2087372.36678 37.7114303786888 -122.447651252104 (37.7114303786888, -122.447651252104) 9 7 6 28861 25
14258 261352 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 297 Sagamore St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/13/2020 12:00:00 AM 3 3x3 Permit Number 780859 5994172 2087374 37.7111973453091 -122.461962532307 (37.7111973453091, -122.461962532307) 9 8 6 28861 24
19087 261350 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 299 Sagamore St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/13/2020 12:00:00 AM 3 3x3 Permit Number 784323 5994169 2087374 37.7111971725927 -122.461972900974 (37.7111971725927, -122.461972900974) 9 8 6 28861 24
19183 261351 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 299 Sagamore St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/13/2020 12:00:00 AM 3 3x3 Permit Number 784323 5994169 2087374 37.7111971725927 -122.461972900974 (37.7111971725927, -122.461972900974) 9 8 6 28861 24
1481 172310 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 63 Seville St 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/23/2020 12:00:00 AM 3 Width 3ft   6001999.53893 2087418.49495 37.7117670587831 -122.434911834617 (37.7117670587831, -122.434911834617) 9 7 6 28861 5
134756 19062 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 174 Sagamore St 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/10/2017 08:47:00 AM 3 3X3   5995225.08055 2087462.80286 37.7115017488702 -122.458329272374 (37.7115017488702, -122.458329272374) 9 8 6 28861 24
173908 251743 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 143 Cordova St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001773 2087479 37.7119203272299 -122.43569914015 (37.7119203272299, -122.43569914015) 9 7 6 28861 5
121056 251749 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 601 Prague St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002875 2087693 37.7125704580966 -122.43190559156 (37.7125704580966, -122.43190559156) 9 7 6 28861 5
161307 176916 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 380 Rolph St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6001888.93185 2087835.89796 37.7129068748214 -122.435323960636 (37.7129068748214, -122.435323960636) 9 7 6 28861 5
103230 49761 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 366@ REY Leland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/2003 12:00:00 AM 4   Permit Number 46555 6008949.54261 2087928.88077 37.713560633393 -122.41092664676 (37.713560633393, -122.41092664676) 9 7 8 309 39
88773 216845 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 194 Farallones St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/10/2017 07:48:00 AM 3 Width 3ft   5995118.95449 2088413.12295 37.7141050056202 -122.458764825742 (37.7141050056202, -122.458764825742) 9 8 6 28861 24
99461 216848 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 258 Farallones St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/06/2017 02:39:00 PM 3 Width 3ft   5994378.76562 2088424.12647 37.7140926462446 -122.461323980613 (37.7140926462446, -122.461323980613) 9 8 6 28861 24
52445 251444 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 244 Farallones St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/10/2017 07:40:00 AM 3 3x3   5994545 2088436 37.7141348140673 -122.460750275072 (37.7141348140673, -122.460750275072) 9 8 6 28861 24
57710 181021 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 179 Rolph St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/10/2017 12:49:00 PM 3 8x6   6000934.69942 2088437.13017 37.71450348711 -122.438665147076 (37.71450348711, -122.438665147076) 9 7 6 28861 5
132066 207026 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 229 Lobos St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5994724.72263 2088692.24537 37.7148487422402 -122.460147642199 (37.7148487422402, -122.460147642199) 9 8 6 28861 24
139943 115757 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1718 Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 772425 5998122.34061 2088716.21291 37.7151093927473 -122.448405831859 (37.7151093927473, -122.448405831859) 9 7 6 28861 25
25 49783 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 130 Wilde Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/01/2020 12:00:00 AM 3   Permit Number 46568 6011944.29976 2088937.30454 37.7164970376796 -122.400646428989 (37.7164970376796, -122.400646428989) 10 7 8 309 39
76984 176882 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 371 Wilde Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/07/2018 12:00:00 AM 3 3x3 Permit Number 781358 6010924.50069 2089093.90072 37.7168700890604 -122.404182392406 (37.7168700890604, -122.404182392406) 9 7 8 309 39
72790 40470 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 43 Lakeview Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   06/15/1999 12:00:00 AM     Permit Number 41555 5997449.10168169 2089159.83978526 37.7162889747674 -122.450764790718 (37.7162889747674, -122.450764790718) 9 8 6 28861 24
8 264824 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1x Harkness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2020 12:00:00 AM 3     6012032 2089425 37.7178410421308 -122.400377527521 (37.7178410421308, -122.400377527521) 10 7 8 309 39
16248 264659 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 971 Hollister Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   09/10/2020 12:00:00 AM   3x3   6014920.44131 2089617.70445 37.7185308216427 -122.390406839913 (37.7185308216427, -122.390406839913) 10 3 8 58 1
67542 95712 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 642 Athens St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2011 12:00:00 AM 5 3x3 Permit Number 767468 6003074.18539 2089625.7401 37.7178886288451 -122.431355025819 (37.7178886288451, -122.431355025819) 9 7 6 28861 5
132281 254353 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 2 Ankeny St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/05/2018 12:00:00 AM 3 3x3 Permit Number 777225 6011131.69741 2089639.6721 37.7183802415409 -122.403504586485 (37.7183802415409, -122.403504586485) 10 7 8 309 28
49657 46433 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 2St. Ankeny St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/05/2018 12:00:00 AM 3 3x3 Permit Number 777225 6011103.47209 2089684.58226 37.718501979072 -122.403605308234 (37.718501979072, -122.403605308234) 10 7 8 309 28
95475 46434 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 2St. Ankeny St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/30/2003 12:00:00 AM 1   Permit Number 47151 6011096.25435 2089701.2859 37.7185474406786 -122.40363143174 (37.7185474406786, -122.40363143174) 10 7 8 309 28
82669 46431 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2St. Ankeny St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/15/2002 12:00:00 AM 1   Permit Number 44652 6011089.42189 2089718.35805 37.7185939356546 -122.403656249429 (37.7185939356546, -122.403656249429) 10 7 8 309 28
61823 109689 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 836 Russia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/27/2015 12:00:00 AM 3 3x3 Permit Number 774161 6003406.50306 2089728.73547 37.7181902596385 -122.430213694415 (37.7181902596385, -122.430213694415) 9 7 6 28861 5
179045 19350 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 618 Shields St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/27/2018 12:00:00 AM 3 3X3 Permit Number 781612 5992350.09465 2089866.75515 37.7179367902328 -122.468440675709 (37.7179367902328, -122.468440675709) 9 8 6 64 24
12222 31158 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 600 Head St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/13/2020 12:00:00 AM 3   Permit Number 785248 5993522.80361 2089878.90243 37.7180378119737 -122.464388049089 (37.7180378119737, -122.464388049089) 9 8 6 64 24
174741 38921 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 749 Lakeview Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/1998 12:00:00 AM     Permit Number 40731 5994544.80644489 2089901.89590816 37.7181598049858 -122.460857119734 (37.7181598049858, -122.460857119734) 9 8 6 28861 24
72730 251681 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 4 Lee Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 02:36:00 PM 3 3x5   5996550 2089909 37.7182944850221 -122.453926576307 (37.7182944850221, -122.453926576307) 9 8 6 28861 24
194470 254768 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 415 Victoria St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/28/2018 12:00:00 AM 3 3x3 Permit Number 781626 5993212 2089957 37.7182343284954 -122.4654680237 (37.7182343284954, -122.4654680237) 9 8 6 64 24
111662 252898 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 501x Mount Vernon Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997879 2089997 37.7186122227881 -122.449339142229 (37.7186122227881, -122.449339142229) 9 8 6 28861 24
68598 109688 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 610 Russia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/27/2015 12:00:00 AM 3 3x3 Permit Number 774167 6002866.93373 2090069.72294 37.719095959684 -122.432103090885 (37.719095959684, -122.432103090885) 9 7 6 28861 5
28327 162331 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 26 Lee Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 02:09:00 PM 3 Width 0ft   5996526.61739 2090076.51041 37.7187530886569 -122.454019490912 (37.7187530886569, -122.454019490912) 9 8 6 28861 24
189393 162332 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 36 Lee Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 02:06:00 PM 3 Width 0ft   5996526.7373 2090117.21242 37.7188648537082 -122.45402201441 (37.7188648537082, -122.45402201441) 9 8 6 28861 24
141360 176880 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 3333 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6012013.01229 2090122.10429 37.7197540907522 -122.400492099948 (37.7197540907522, -122.400492099948) 10 7 8 309 28
102650 120680 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 522 Moscow St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/23/2016 12:00:00 AM 3 3x3   6003717 2090174 37.7194304401491 -122.42917217064 (37.7194304401491, -122.42917217064) 9 7 6 28861 5
30581 252889 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 301x Howth St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2019 08:45:00 AM 3 3x3   5997131 2090234 37.7192201544045 -122.451941749186 (37.7192201544045, -122.451941749186) 9 8 6 28861 24
161792 216723 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 51 Miramar Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/06/2017 08:05:00 AM 3 Width 2ft   5995305.86266 2090248.98741 37.7191565973781 -122.458251599737 (37.7191565973781, -122.458251599737) 9 8 6 28861 24
23429 176881 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 3303 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6011991.79808 2090250.44255 37.7201052985 -122.400574440964 (37.7201052985, -122.400574440964) 10 7 8 309 28
163710 108371 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 575 Paris St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1 3x3   6001620.80772 2090281.19611 37.7196058887813 -122.43642558878 (37.7196058887813, -122.43642558878) 9 7 6 28861 5
27595 63507 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 574 Paris St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/08/1987 12:00:00 AM 4   Permit Number 24113 6001588.8915 2090307.92108 37.7196774559426 -122.436537823274 (37.7196774559426, -122.436537823274) 9 7 6 28861 5
41454 253116 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 26 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 12:00:00 PM 3 Width 0ft   5999996.87806 2090379.50245 37.7197834059472 -122.442045963044 (37.7197834059472, -122.442045963044) 9 7 6 28861 25
96295 253108 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 18 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:41:00 AM 3 Width 0ft   5999996.87806 2090379.50245 37.7197834059472 -122.442045963044 (37.7197834059472, -122.442045963044) 9 7 6 28861 25
156762 253110 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 20 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:46:00 AM 3 Width 0ft   5999996.87806 2090379.50245 37.7197834059472 -122.442045963044 (37.7197834059472, -122.442045963044) 9 7 6 28861 25
172760 253118 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 28 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 01:35:00 PM 3 Width 0ft   5999996.87806 2090379.50245 37.7197834059472 -122.442045963044 (37.7197834059472, -122.442045963044) 9 7 6 28861 25
173524 253112 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 22 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:51:00 AM 3 Width 0ft   5999996.87806 2090379.50245 37.7197834059472 -122.442045963044 (37.7197834059472, -122.442045963044) 9 7 6 28861 25
182173 253114 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 24 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:55:00 AM 3 Width 0ft   5999996.87806 2090379.50245 37.7197834059472 -122.442045963044 (37.7197834059472, -122.442045963044) 9 7 6 28861 25
143452 160073 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 16 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:36:00 AM 3 Width 0ft   6000082.99934 2090399.7386 37.7198438772755 -122.441749724582 (37.7198438772755, -122.441749724582) 9 7 6 28861 25
161401 37831 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 18 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003870.23097 2090403.35388 37.7200688687581 -122.428658848427 (37.7200688687581, -122.428658848427) 9 7 6 28861 5
186495 57147 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 578 London St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/2012 12:00:00 AM 6 4x4 Permit Number 14422 6001353.29798 2090440.69811 37.7200286411902 -122.4373616868 (37.7200286411902, -122.4373616868) 9 7 6 28861 5
194372 37826 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 14 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003896.37457 2090444.78719 37.7201841150858 -122.428571430748 (37.7201841150858, -122.428571430748) 9 7 6 28861 5
165323 160071 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 14 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:31:00 AM 3 Width 0ft   6000209.4859 2090450.10808 37.7199893866688 -122.44131611827 (37.7199893866688, -122.44131611827) 9 7 6 28861 25

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)
);