Street_Tree_List

Data source: data.sfgov.org

977 rows where qSpecies = 48 sorted by SiteOrder

View and edit SQL

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

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder ▼ qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
1836 251749 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 601 Prague St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6002875.0 2087693.0 37.7125704580966 -122.43190559156 (37.7125704580966, -122.43190559156)
1848 251743 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 143 Cordova St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6001773.0 2087479.0 37.7119203272299 -122.43569914014999 (37.7119203272299, -122.43569914015)
20472 89331 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 4658 18th St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/31/2008 12:00:00 AM   3x3 Permit Number 51984 6000201.0 2105201.0 37.760491360371596 -122.4424038966 (37.7604913603716, -122.4424038966)
34436 88394 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 139 25th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/10/2008 12:00:00 AM 1 3x3 Permit Number 51373 5988000.05712 2115038.19323 37.78679857243979 -122.485322676521 (37.7867985724398, -122.485322676521)
54143 88190 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1118 Harrison St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/08/2008 12:00:00 AM   3x3 Permit Number 51195 6010631.0 2110372.0 37.7752787109316 -122.406695562022 (37.7752787109316, -122.406695562022)
79007 107987 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 233 Laidley St   Sidewalk: Property side : Yard 9 Tree 1 Private 1   11/10/2014 12:00:00 AM 3   Permit Number 771182 6004231.95883 2097050.3446 37.7383404878499 -122.427881865747 (37.7383404878499, -122.427881865747)
85422 88095 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1795 40th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/30/2008 12:00:00 AM   3x3 Permit Number 51099 5983752.7 2102993.7 37.7534794912156 -122.49912702260201 (37.7534794912156, -122.499127022602)
87710 88139 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 523 Teresita Blvd   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/07/2008 12:00:00 AM   3x3 Permit Number 51168 5998937.5 2097522.9 37.7393370734625 -122.446221422912 (37.7393370734625, -122.446221422912)
89138 88206 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 187 Beaumont Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/08/2008 12:00:00 AM   3x3 Permit Number 51211 5996832.5 2111680.5 37.7780898241501 -122.45452201468201 (37.7780898241501, -122.454522014682)
92779 88094 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1474 40th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/30/2008 12:00:00 AM   3x3 Permit Number 51098 5983765.2 2105129.7 37.759345083267796 -122.499241618892 (37.7593450832678, -122.499241618892)
95419 117055 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 762 34th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/18/2016 12:00:00 AM 3   Permit Number 778404 5985439.6 2110687.7 37.7747038750392 -122.49386040463101 (37.7747038750392, -122.493860404631)
99545 88108 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1935 47th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/01/2008 12:00:00 AM   3x3 Permit Number 51112 5981615.2 2101901.1 37.7503538981052 -122.50643780728001 (37.7503538981052, -122.50643780728)
102266 88244 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 4330 17th St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/08/2008 12:00:00 AM   3x3 Permit Number 51231 6000585.0 2105809.0 37.7621826583789 -122.441119442302 (37.7621826583789, -122.441119442302)
106923 88527 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1501 06th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/21/2008 12:00:00 AM   3x3 Permit Number 51477 5994255.6 2105256.2 37.7603022580943 -122.462970154312 (37.7603022580943, -122.462970154312)
112698 88255 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 115 Belvedere St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/08/2008 12:00:00 AM   3x3 Permit Number 51240 5998220.0 2108137.0 37.7684397634087 -122.44946678758998 (37.7684397634087, -122.44946678759)
117474 88087 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1254 38th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/30/2008 12:00:00 AM   3x3 Permit Number 51087 5984334.6 2106629.9 37.7634975987144 -122.497383137852 (37.7634975987144, -122.497383137852)
118839 88270 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 288 States St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/08/2008 12:00:00 AM 5 3x3 Permit Number 51256 6000346.0 2106829.0 37.764969709442504 -122.44201926680701 (37.7649697094425, -122.442019266807)
120684 88438 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1248 Mason St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/30/2009 12:00:00 AM   3x3 Permit Number 52242 6009421.0 2117567.0 37.794966684082105 -122.41138965638599 (37.7949666840821, -122.411389656386)
129114 88495 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 27 Reddy St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/18/2008 12:00:00 AM   3x3 Permit Number 51437 6013659.0 2094063.0 37.7306666521666 -122.39507835000201 (37.7306666521666, -122.395078350002)
129402 88096 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1795 40th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/30/2008 12:00:00 AM   3x3 Permit Number 51099 5983752.7 2102993.7 37.7534794912156 -122.49912702260201 (37.7534794912156, -122.499127022602)
132114 96082 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 448 43rd Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/2011 12:00:00 AM 4 3x3 Permit Number 767705 5982547.81502 2112777.5539599997 37.7802723877651 -122.50401833246299 (37.7802723877651, -122.504018332463)
144304 88645 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 2500x Larkin St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/05/2008 12:00:00 AM   3x3 Permit Number 51618 6006882.7 2119972.1 37.8014277902223 -122.420343352043 (37.8014277902223, -122.420343352043)
141 832 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1396 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/28/2017 12:18:00 PM 3 3X3   5981551.7086 2105613.8347 37.7605442750604 -122.50693272862101 (37.7605442750604, -122.506932728621)
144 11598 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 4134 Judah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/28/2017 11:51:00 AM 3 3X3   5981663.7126 2105589.2786 37.760483446414796 -122.506543543521 (37.7604834464148, -122.506543543521)
146 97319 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1038 Taraval St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/28/2017 12:52:00 PM 3 3x3   5989945.5882 2099070.048 37.7430675136338 -122.477424174253 (37.7430675136338, -122.477424174253)
147 58021 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 4026 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/28/2017 12:07:00 PM 3   Permit Number 16988 5983218.6194 2106316.5419 37.7625717348083 -122.50121971656999 (37.7625717348083, -122.50121971657)
150 11606 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 4200x Judah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/28/2017 11:54:00 AM 3 3X3   5981492.2847 2105581.1189 37.76045094714279 -122.507135818078 (37.7604509471428, -122.507135818078)
152 24532 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1395 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/28/2017 12:21:00 PM 3 3X3   5981507.2257 2105680.0147 37.7607233666377 -122.50709148147499 (37.7607233666377, -122.507091481475)
156 54712 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 4508 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/28/2017 11:58:00 AM 3 3x3 Permit Number 10547 5981730.2931 2106265.9364 37.762345274891 -122.506363455406 (37.762345274891, -122.506363455406)
164 97323 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1011 Taraval St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/28/2017 12:25:00 PM 3 3x3   5990005.0659 2099005.494 37.7428937161431 -122.477213802134 (37.7428937161431, -122.477213802134)
165 11582 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 4000 Judah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/28/2017 11:49:00 AM 3 3X3   5982109.291 2105604.0369 37.760550193841404 -122.505003612665 (37.7605501938414, -122.505003612665)
179 182083 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1101 Taraval St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/28/2017 12:33:00 PM 3 Width 0ft   5989775.2775 2098997.3719 37.742858080169505 -122.47800774412599 (37.7428580801695, -122.478007744126)
1367 36152 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 51 Commonwealth Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/01/1998 12:00:00 AM 4   Permit Number 39237 5996489.9045 2114249.7041 37.7851245233187 -122.455892946486 (37.7851245233187, -122.455892946486)
1430 183687 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1341 42nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/05/2017 12:00:00 AM 3 Width 0ft Permit Number 33196 5983043.3769 2106010.2341 37.7617204082059 -122.50180314292801 (37.7617204082059, -122.501803142928)
2406 201829 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 284 Friedell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020846.41585 2093000.7945400001 37.7281471046068 -122.37015664263399 (37.7281471046068, -122.370156642634)
2410 201817 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Friedell St 1 : 4 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft   6021101.98762 2093338.62944 37.7290887577236 -122.36929644199101 (37.7290887577236, -122.369296441991)
2411 201831 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 350 Friedell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020768.36275 2092897.8842900002 37.7278602487283 -122.37041936696698 (37.7278602487283, -122.370419366967)
2423 201830 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 292 Friedell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020827.60649 2092975.44043 37.7280764547545 -122.370219916224 (37.7280764547545, -122.370219916224)
2435 201826 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 250 Friedell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020898.42083 2093071.04954 37.7283428654122 -122.369981710984 (37.7283428654122, -122.369981710984)
2444 201828 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 268 Friedell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020862.97624 2093021.3694799999 37.728204508308 -122.3701008136 (37.728204508308, -122.3701008136)
2446 201827 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 258 Friedell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020879.65439 2093047.83852 37.7282781025329 -122.370044984594 (37.7282781025329, -122.370044984594)
2460 201825 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 232 Friedell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020928.29141 2093111.1924700001 37.7284547293849 -122.36988121894899 (37.7284547293849, -122.369881218949)
2676 253162 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 323 Moscow St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6004481.0 2091226.0 37.7223622223708 -122.42660617515699 (37.7223622223708, -122.426606175157)
3788 118108 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 3585 Balboa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/25/2017 12:00:00 AM 3 Width 3ft   5984519.42575 2111051.46948 37.7756488017479 -122.497070281467 (37.7756488017479, -122.497070281467)
3950 162332 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 36 Lee Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 02:06:00 PM 3 Width 0ft   5996526.7373 2090117.21242 37.718864853708205 -122.45402201441001 (37.7188648537082, -122.45402201441)
3971 251681 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 4 Lee Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 02:36:00 PM 3 3x5   5996550.0 2089909.0 37.7182944850221 -122.453926576307 (37.7182944850221, -122.453926576307)
3974 162331 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 26 Lee Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 02:09:00 PM 3 Width 0ft   5996526.61739 2090076.5104099999 37.7187530886569 -122.454019490912 (37.7187530886569, -122.454019490912)
3982 159338 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 517 Ellington Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 11:04:00 AM 3 Width 0ft   5998112.9338 2087183.20699 37.7108995709325 -122.44832801714199 (37.7108995709325, -122.448328017142)
3992 159336 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 523 Ellington Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 10:36:00 AM 3 Width 0ft   5998080.57171 2087152.95418 37.7108146533454 -122.448437690352 (37.7108146533454, -122.448437690352)
4007 216655 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 161 Miramar Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 02:49:00 PM 3 Width 3ft   5995318.74701 2090961.5845400002 37.7211139601174 -122.45825861266 (37.7211139601174, -122.45825861266)
4077 159345 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 461 Ellington Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 11:39:00 AM 3 Width 0ft   5998268.07471 2087327.6085 37.7113049331395 -122.447802205131 (37.7113049331395, -122.447802205131)
4113 181027 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 95 Rolph St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/05/2017 04:23:00 PM 3 Width 4ft   6000546.58685 2088667.2481099998 37.7151132526545 -122.440023107188 (37.7151132526545, -122.440023107188)
4130 216848 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 258 Farallones St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/06/2017 02:39:00 PM 3 Width 3ft   5994378.76562 2088424.12647 37.7140926462446 -122.461323980613 (37.7140926462446, -122.461323980613)
4142 216723 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 51 Miramar Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/06/2017 08:05:00 AM 3 Width 2ft   5995305.86266 2090248.9874099998 37.7191565973781 -122.458251599737 (37.7191565973781, -122.458251599737)
4192 216845 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 194 Farallones St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/10/2017 07:48:00 AM 3 Width 3ft   5995118.95449 2088413.12295 37.714105005620205 -122.458764825742 (37.7141050056202, -122.458764825742)
4220 181020 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 183 Rolph St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/10/2017 12:41:00 PM 3 Width 4ft   6000952.49174 2088426.9301099998 37.714476492181895 -122.438602919392 (37.7144764921819, -122.438602919392)
4227 181017 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 197 Rolph St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/10/2017 11:28:00 AM 3 Width 4ft   6001019.31887 2088386.79799 37.7143700996689 -122.43836906510201 (37.7143700996689, -122.438369065102)
4245 181019 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 191 Rolph St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/10/2017 12:36:00 PM 3 Width 4ft   6000981.45407 2088409.26942 37.714429647391896 -122.438501549606 (37.7144296473919, -122.438501549606)
4257 181010 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 215 Rolph St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/10/2017 11:17:00 AM 3 Width 4ft   6001139.6561 2088316.9005900002 37.7141850209845 -122.437948129327 (37.7141850209845, -122.437948129327)
4258 19062 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 174 Sagamore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/10/2017 08:47:00 AM 3 3X3   5995225.08055 2087462.80286 37.7115017488702 -122.458329272374 (37.7115017488702, -122.458329272374)
4266 181021 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 179 Rolph St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/10/2017 12:49:00 PM 3 8x6   6000934.6994199995 2088437.13017 37.71450348711 -122.438665147076 (37.71450348711, -122.438665147076)
4282 251444 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 244 Farallones St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/10/2017 07:40:00 AM 3 3x3   5994545.0 2088436.0 37.7141348140673 -122.460750275072 (37.7141348140673, -122.460750275072)
4306 181011 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 207 Rolph St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/10/2017 11:21:00 AM 3 Width 4ft   6001121.315830001 2088326.0025400002 37.714208969932706 -122.438012171843 (37.7142089699327, -122.438012171843)
4375 176488 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 295 Munich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/11/2017 09:25:00 AM 3 Width 2ft   6004452.7164199995 2090718.28415 37.7209665468512 -122.4266678079 (37.7209665468512, -122.4266678079)
4432 172375 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 216 Naylor St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/11/2017 07:37:00 AM 3 Width 2ft   6002574.0 2086750.0 37.7099641176609 -122.432878614235 (37.7099641176609, -122.432878614235)
4697 60547 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 507 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/19/2017 09:50:00 AM 3   Permit Number 20157 5984999.38205 2112385.8100400004 37.779340631831495 -122.49550845523501 (37.7793406318315, -122.495508455235)
10352 27283 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 630 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/11/2008 12:00:00 AM 6 3X3   6005560.769069999 2093525.90712 37.7287382496569 -122.423037049614 (37.7287382496569, -122.423037049614)
10369 83563 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 422 Lisbon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/28/2012 12:00:00 AM 5 3x3 Permit Number 769753 6002333.8721199995 2090986.9240400002 37.721584152666104 -122.434011205875 (37.7215841526661, -122.434011205875)
10385 93406 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1408 Taraval St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/24/2015 11:15:00 AM 3 3x3   5988828.0589 2099030.2661 37.7428933746541 -122.48128533094 (37.7428933746541, -122.48128533094)
10468 27000 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1236 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/10/2007 12:00:00 AM 6 3X3   6008836.56983 2094066.26048 37.7304062528391 -122.411750521985 (37.7304062528391, -122.411750521985)
10532 27006 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1420 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/13/1999 12:00:00 AM 3 3X3   6009885.433069999 2094479.90043 37.73160080432 -122.408153598922 (37.73160080432, -122.408153598922)
10655 26983 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1395 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/30/2009 12:00:00 AM 3 3X3   6009622.935740001 2094432.5688200002 37.731456140283704 -122.409057769215 (37.7314561402837, -122.409057769215)
10726 26985 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1353 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/29/2009 12:00:00 AM 3 3X3   6009441.55287 2094364.79553 37.731259886623896 -122.409680064978 (37.7312598866239, -122.409680064978)
10740 27042 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 730 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/10/2007 12:00:00 AM 6 3X3   6006159.1890199995 2093550.7367900002 37.7288401770086 -122.420970032554 (37.7288401770086, -122.420970032554)
11019 27182 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 214 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/03/2015 07:50:00 AM 3 2X3   6002674.64617 2093876.5721099998 37.72953781082239 -122.433039593603 (37.7295378108224, -122.433039593603)
11046 116538 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1002x Naples St 1 Median : Yard 3 Tree 1 DPW 2     1 3x3   6001578.1015800005 2088233.43486 37.7139807660769 -122.436426724612 (37.7139807660769, -122.436426724612)
11119 27314 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 884 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/05/2007 12:00:00 AM 3 3X3   6007123.27309 2093533.58449 37.728847377904394 -122.41763590486799 (37.7288473779044, -122.417635904868)
11129 57147 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 578 London St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/28/2012 12:00:00 AM 6 4x4 Permit Number 14422 6001353.29798 2090440.6981099998 37.720028641190204 -122.4373616868 (37.7200286411902, -122.4373616868)
11161 27102 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 669 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/05/2009 12:00:00 AM 3 3X3   6005822.11431 2093583.57584 37.7289113394767 -122.422137656546 (37.7289113394767, -122.422137656546)
11177 93407 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1414 Taraval St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/24/2015 11:09:00 AM 3 3x3   5988810.4689 2099030.2661 37.74289235198079 -122.48134615155399 (37.7428923519808, -122.481346151554)
11210 27282 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 710 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/10/2007 12:00:00 AM 6 3X3   6006026.1077 2093547.18457 37.7288229208214 -122.421429852322 (37.7288229208214, -122.421429852322)
11394 27044 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 750 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1999 12:00:00 AM 3 3X3   6006334.59281 2093563.7909400002 37.7288859066417 -122.42036457476001 (37.7288859066417, -122.42036457476)
11460 11602 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 4150 Judah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/06/2011 12:00:00 AM 3 3X3   5981591.6344 2105586.8054 37.7604724115264 -122.506792641078 (37.7604724115264, -122.506792641078)
11504 25763 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1682 Geneva Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   08/20/2015 06:02:00 PM 3 2X3   6004184.86566 2087196.3858299998 37.711281031873 -122.42734293164801 (37.711281031873, -122.427342931648)
11601 27009 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1446 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2007 12:00:00 AM 3 3X3   6010020.23018 2094527.09535 37.731737938333104 -122.40769090313299 (37.7317379383331, -122.407690903133)
11687 83518 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 117X Peru Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/27/2012 12:00:00 AM 5 3x3 Permit Number 769748 6003951.4498 2093338.17621 37.7281318376981 -122.428587192249 (37.7281318376981, -122.428587192249)
11715 26976 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 504X Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/21/2007 12:00:00 AM 3 3x3   6004631.3919400005 2093482.01374 37.7285652398765 -122.42624684333201 (37.7285652398765, -122.426246843332)
11736 26988 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1339 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/29/2009 12:00:00 AM 6 3X3   6009367.01038 2094339.1416200001 37.731185268979395 -122.409935962601 (37.7311852689794, -122.409935962601)
11808 27083 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 773 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/21/2007 12:00:00 AM 3 2X3   6006444.73415 2093622.02758 37.729052017734794 -122.419987938702 (37.7290520177348, -122.419987938702)
11819 115757 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1718 Cayuga Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/24/2016 12:00:00 AM 3   Permit Number 772425 5998122.34061 2088716.2129099998 37.715109392747294 -122.44840583185899 (37.7151093927473, -122.448405831859)
11861 117431 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 730 Excelsior Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/14/2016 12:00:00 AM 3   Permit Number 776696 6004211.115780001 2091567.32576 37.7232841663055 -122.42756340763901 (37.7232841663055, -122.427563407639)
11936 109688 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 610 Russia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/27/2015 12:00:00 AM 3 3x3 Permit Number 774167 6002866.933730001 2090069.7229400002 37.719095959684 -122.432103090885 (37.719095959684, -122.432103090885)
12018 27177 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 241 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/23/2005 12:00:00 AM 3 2X3   6002847.37275 2093824.8510200002 37.729405592491496 -122.432438768257 (37.7294055924915, -122.432438768257)
12031 37717 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 3001 Taraval St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/27/2015 04:45:00 PM 3 3x3 Permit Number 774917 5983817.4661 2098794.1609 37.7419525119456 -122.498592859082 (37.7419525119456, -122.498592859082)
12093 27089 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 725 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/30/2009 12:00:00 AM 3 2X3   6006167.96193 2093597.45552 37.728968950933 -122.420943019604 (37.728968950933, -122.420943019604)
12102 27527 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1114 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/03/2015 07:52:00 AM 3 3X3   6008222.66754 2093785.3034 37.729600346979794 -122.41385300921101 (37.7296003469798, -122.413853009211)
12172 80104 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 425 Brazil Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/03/2005 12:00:00 AM 3 3x3 Permit Number 52309 6003144.80516 2091503.7027099999 37.7230491006299 -122.43124489934999 (37.7230491006299, -122.43124489935)
12241 27220 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 387 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/03/2009 12:00:00 AM 6 3X3   6003946.676519999 2093508.2167200001 37.728598460843294 -122.42861580957899 (37.7285984608433, -122.428615809579)
12272 27179 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 231 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/27/2009 12:00:00 AM 3 2X3   6002801.57598 2093850.9514400002 37.729474661304295 -122.432598955494 (37.7294746613043, -122.432598955494)
12306 27287 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1036 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2008 12:00:00 AM 6 3X3   6007731.14975 2093596.42391 37.729054108643 -122.415538874723 (37.729054108643, -122.415538874723)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 605.808ms · Data source: data.sfgov.org