1,121 rows where qSpecies_id = 6 sorted by YCoord

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)
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
10101 180653 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 245 Chicago Way 1 Sidewalk: Curb side : Yard Tree Private 2   10/11/2017 07:56:00 AM 3 Width 6ft   6002847.75966 2086772.69306 37.7100419513527 -122.431934068713 (37.7100419513527, -122.431934068713) 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
144424 116545 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1041x Naples St 1 Median : Yard Tree DPW 1     2 3x3   6001537.05763 2088100.5912 37.7136136745151 -122.436559085032 (37.7136136745151, -122.436559085032) 9 7 6 28861 5
116664 116546 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1041x Naples St 2 Median : Yard Tree DPW 1     3 3x3   6001545.43478 2088113.86518 37.7136505979649 -122.436531080144 (37.7136505979649, -122.436531080144) 9 7 6 28861 5
29210 176917 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1002x Naples St 9 Median : Yard Tree DPW 1     3     6001514.03799 2088123.65893 37.7136757052349 -122.436640299224 (37.7136757052349, -122.436640299224) 9 7 6 28861 5
95040 116547 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1041x Naples St 3 Median : Yard Tree DPW 1     4 3x3   6001554.67745 2088129.8106 37.7136949057732 -122.436500274771 (37.7136949057732, -122.436500274771) 9 7 6 28861 5
58866 116551 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1002x Naples St 7 Median : Yard Tree DPW 1     4 3x3   6001523.56178 2088140.13665 37.713721490625 -122.436608560332 (37.713721490625, -122.436608560332) 9 7 6 28861 5
139455 116549 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1041x Naples St 5 Median : Yard Tree DPW 1     4 3x3   6001562.82912 2088145.24079 37.7137377368707 -122.436473203396 (37.7137377368707, -122.436473203396) 9 7 6 28861 5
123255 116550 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1002x Naples St 6 Median : Yard Tree DPW 1     5 3x3   6001534.78323 2088160.34451 37.7137776146169 -122.436571220504 (37.7137776146169, -122.436571220504) 9 7 6 28861 5
69235 116543 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1041x Naples St 6 Median : Yard Tree DPW 1     5 3x3   6001574.84931 2088164.89401 37.7137923832878 -122.43643306305 (37.7137923832878, -122.43643306305) 9 7 6 28861 5
138388 116548 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1002x Naples St 4 Median : Yard Tree DPW 1     3 3x3   6001544.87474 2088178.15499 37.7138270917124 -122.436537614614 (37.7138270917124, -122.436537614614) 9 7 6 28861 5
7686 116544 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1041x Naples St 7 Median : Yard Tree DPW 1     5 3x3   6001586.02621 2088182.95127 37.7138425996209 -122.436395723209 (37.7138425996209, -122.436395723209) 9 7 6 28861 5
44017 116540 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1002x Naples St 3 Median : Yard Tree DPW 1     3 3x3   6001555.50616 2088195.95431 37.7138765688354 -122.436502141754 (37.7138765688354, -122.436502141754) 9 7 6 28861 5
17357 116552 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1041x Naples St 8 Median : Yard Tree DPW 1     3 3x3   6001598.03525 2088202.06693 37.7138957693564 -122.436355582838 (37.7138957693564, -122.436355582838) 9 7 6 28861 5
138570 116539 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1002x Naples St 2 Median : Yard Tree DPW 1     3 3x3   6001567.48738 2088213.72569 37.7139260459311 -122.436462001442 (37.7139260459311, -122.436462001442) 9 7 6 28861 5
155326 176918 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1041x Naples St 9 Median : Yard Tree DPW 1     4     6001604.80367 2088215.91202 37.7139341694897 -122.436333178956 (37.7139341694897, -122.436333178956) 9 7 6 28861 5
65853 116538 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1002x Naples St 1 Median : Yard Tree DPW 1     1 3x3   6001578.10158 2088233.43486 37.7139807660769 -122.436426724612 (37.7139807660769, -122.436426724612) 9 7 6 28861 5
151427 176883 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 96 Alpha St 4 Front Yard : Yard Tree Private 2     1     6011048.63475 2088252.82193 37.7145675926038 -122.403694172945 (37.7145675926038, -122.403694172945) 9 7 8 309 39
172292 176884 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 96 Alpha St 2 Front Yard : Yard Tree Private 2     1     6011062.55449 2088258.87965 37.7145850034576 -122.403646486396 (37.7145850034576, -122.403646486396) 9 7 8 309 39
192989 181010 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 215 Rolph St 1 Sidewalk: Curb side : Yard Tree Private 2   10/10/2017 11:17:00 AM 3 Width 4ft   6001139.6561 2088316.90059 37.7141850209845 -122.437948129327 (37.7141850209845, -122.437948129327) 9 7 6 28861 5
168066 181011 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 207 Rolph St 1 Sidewalk: Curb side : Yard Tree Private 2   10/10/2017 11:21:00 AM 3 Width 4ft   6001121.31583 2088326.00254 37.7142089699327 -122.438012171843 (37.7142089699327, -122.438012171843) 9 7 6 28861 5
194177 181017 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 197 Rolph St 1 Sidewalk: Curb side : Yard Tree Private 2   10/10/2017 11:28:00 AM 3 Width 4ft   6001019.31887 2088386.79799 37.7143700996689 -122.438369065102 (37.7143700996689, -122.438369065102) 9 7 6 28861 5
30385 181018 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 197 Rolph St 2 Sidewalk: Curb side : Yard Tree Private 2   10/10/2017 11:31:00 AM 3 Width 4ft   6001005.57228 2088396.04691 37.7143947132291 -122.43841724089 (37.7143947132291, -122.43841724089) 9 7 6 28861 5
109143 181019 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 191 Rolph St 1 Sidewalk: Curb side : Yard Tree Private 2   10/10/2017 12:36:00 PM 3 Width 4ft   6000981.45407 2088409.26942 37.7144296473919 -122.438501549606 (37.7144296473919, -122.438501549606) 9 7 6 28861 5
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
117385 181020 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 183 Rolph St 1 Sidewalk: Curb side : Yard Tree Private 2   10/10/2017 12:41:00 PM 3 Width 4ft   6000952.49174 2088426.93011 37.7144764921819 -122.438602919392 (37.7144764921819, -122.438602919392) 9 7 6 28861 5
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
133452 181027 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 95 Rolph St 1 Sidewalk: Curb side : Yard Tree Private 2   10/05/2017 04:23:00 PM 3 Width 4ft   6000546.58685 2088667.24811 37.7151132526545 -122.440023107188 (37.7151132526545, -122.440023107188) 9 7 6 28861 5
39381 181028 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 95 Rolph St 2 Sidewalk: Curb side : Yard Tree Private 2   10/05/2017 04:38:00 PM 3 Width 4ft   6000533.08885 2088674.46766 37.7151323074928 -122.440070279342 (37.7151323074928, -122.440070279342) 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
157522 207028 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 227 Ramsell St 1 : Tree Private 2     1 Width 3ft   5992956.15905 2088729.24095 37.7148484391912 -122.46626317241 (37.7148484391912, -122.46626317241) 9 8 6 64 24
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
56885 207029 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 835 Sargent St 1 : Tree Private 2     7 Width 3ft   5991723.94975 2089189.17612 37.7160401362134 -122.470555641023 (37.7160401362134, -122.470555641023) 9 8 6 64 24
185300 207030 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 835 Sargent St 2 : Tree Private 2     7 Width 3ft   5991738.49074 2089190.01168 37.7160432712657 -122.470505441771 (37.7160432712657, -122.470505441771) 9 8 6 64 24
115087 207027 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 43 Lakeview Ave 1 : Tree Private 2     7 Width 3ft   5997356.56263 2089224.02458 37.7164599136667 -122.451089274853 (37.7164599136667, -122.451089274853) 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

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