Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize, PermitNotes
Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
188215 | 188215 | 183121 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2327 41st Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983581.7952 | 2099373.3538 | 37.7435289932417 | -122.49945051311 | (37.7435289932417, -122.49945051311) | |||
187445 | 187445 | 176900 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 167 Madison St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6005606.72127 | 2092829.9713400002 | 37.7268299557374 | -122.42282875044701 | (37.7268299557374, -122.422828750447) | |||
187121 | 187121 | 58124 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 527 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1978 12:00:00 AM | 1 | Permit Number 17106 | 5991241.869630001 | 2111793.32926 | 37.778077396785 | -122.473870058582 | (37.778077396785, -122.473870058582) | ||
186108 | 186108 | 176878 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 526 Lathrop Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6013154.94381 | 2086496.55313 | 37.709862662502104 | -122.396290845073 | (37.7098626625021, -122.396290845073) | |||
185807 | 185807 | 182658 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2242 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987004.6631 | 2102364.6195 | 37.751942436508706 | -122.487834969288 | (37.7519424365087, -122.487834969288) | |||
180870 | 180870 | 227099 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 75 Montcalm St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010635.77556 | 2100089.10311 | 37.7470444571367 | -122.40595450111401 | (37.7470444571367, -122.405954501114) | |||
180010 | 180010 | 118666 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 465 43rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5982506.22463 | 2112651.7557200002 | 37.779924536981504 | -122.50415288931299 | (37.7799245369815, -122.504152889313) | |||
179813 | 179813 | 137671 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 756 LYON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000049.6788 | 2111547.4906 | 37.7779086039439 | -122.443383113797 | (37.7779086039439, -122.443383113797) | |||
178920 | 178920 | 201812 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 6ft | 6021065.67541 | 2093224.76894 | 37.728774126326705 | -122.369414113788 | (37.7287741263267, -122.369414113788) | |||
178120 | 178120 | 181690 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1374 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982168.1662 | 2105754.9295 | 37.760967965591604 | -122.504811174863 | (37.7609679655916, -122.504811174863) | |||
177664 | 177664 | 118188 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 762 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5985415.78787 | 2110692.34221 | 37.7747152280145 | -122.49394311659901 | (37.7747152280145, -122.493943116599) | |||
177014 | 177014 | 95521 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1510 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767313 | 5985302.4962 | 2104889.3961 | 37.7587753414156 | -122.49390726731899 | (37.7587753414156, -122.493907267319) |
176471 | 176471 | 182700 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1651 Moraga St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5989102.9459 | 2103739.8915 | 37.7558407372502 | -122.48067956122401 | (37.7558407372502, -122.480679561224) | |||
175819 | 175819 | 117934 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 867 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5982916.92515 | 2109877.9656700003 | 37.7723326617078 | -122.502526759002 | (37.7723326617078, -122.502526759002) | |||
175623 | 175623 | 184549 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 3501 Moraga St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5983411.1343 | 2103548.3965 | 37.754982490057 | -122.50034921882099 | (37.754982490057, -122.500349218821) | |||
174137 | 174137 | 84659 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 187 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5996845.0781 | 2111686.6666 | 37.7781074773999 | -122.45447894833201 | (37.7781074773999, -122.454478948332) | |||
173458 | 173458 | 184640 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1650 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983160.9711 | 2103902.0944 | 37.7559389581009 | -122.501240500695 | (37.7559389581009, -122.501240500695) | |||
172938 | 172938 | 176884 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 96 Alpha St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6011062.55449 | 2088258.87965 | 37.7145850034576 | -122.40364648639601 | (37.7145850034576, -122.403646486396) | ||||
172906 | 172906 | 207014 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 651 Joost Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 1ft | 5997782.54111 | 2094977.3620200001 | 37.732281609092496 | -122.45003132048201 | (37.7322816090925, -122.450031320482) | |||
171120 | 171120 | 184598 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1795 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983770.321 | 2103008.0087 | 37.7535198125919 | -122.499067143504 | (37.7535198125919, -122.499067143504) | |||
171029 | 171029 | 191247 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1453 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 6ft | 6016461.47366 | 2096825.2224700002 | 37.7384066073881 | -122.385582111127 | (37.7384066073881, -122.385582111127) | |||
167364 | 167364 | 182307 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1509 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987118.7965 | 2104973.5941 | 37.7591126281614 | -122.487631931758 | (37.7591126281614, -122.487631931758) | |||
167111 | 167111 | 92440 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1352 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52830 | 5982162.933999999 | 2105885.2573 | 37.7613255007309 | -122.504838927947 | (37.7613255007309, -122.504838927947) |
166344 | 166344 | 118587 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 140 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5982334.052630001 | 2112627.33977 | 37.7798473711823 | -122.504746689196 | (37.7798473711823, -122.504746689196) | |||
164934 | 164934 | 227107 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 39 Alma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5998391.27095 | 2106242.70654 | 37.7632483086886 | -122.448737922716 | (37.7632483086886, -122.448737922716) | |||
164734 | 164734 | 120000 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 818 30th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5986676.70436 | 2110336.5469299997 | 37.7738120096448 | -122.489555240793 | (37.7738120096448, -122.489555240793) | |||
161979 | 161979 | 117687 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 50 Point Lobos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 8ft | 5982599.26265 | 2112595.13886 | 37.7797745547632 | -122.50382684040501 | (37.7797745547632, -122.503826840405) | |||
160731 | 160731 | 140699 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 224 ASHBURY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998816.4363 | 2109919.7991 | 37.773368976906205 | -122.447532121663 | (37.7733689769062, -122.447532121663) | |||
159962 | 159962 | 207028 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 227 Ramsell St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5992956.15905 | 2088729.24095 | 37.7148484391912 | -122.46626317241001 | (37.7148484391912, -122.46626317241) | |||
159581 | 159581 | 52456 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 757 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/26/2013 12:00:00 AM | 1 | Permit Number 770898 | 5992550.20906 | 2110320.92766 | 37.774110273254706 | -122.46923688790599 | (37.7741102732547, -122.469236887906) | |
158101 | 158101 | 119243 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 50 Sutro Heights Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5981398.37029 | 2111333.4256599997 | 37.7762395779827 | -122.507887519226 | (37.7762395779827, -122.507887519226) | |||
157408 | 157408 | 69788 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1526 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/27/2001 12:00:00 AM | 1 | 5982204.5216 | 2104686.309 | 37.758035976388896 | -122.50460626225299 | (37.7580359763889, -122.504606262253) | ||
157074 | 157074 | 201809 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 237 Friedell St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 6ft | 6020945.51773 | 2093059.3003900002 | 37.72831318869729 | -122.369818081152 | (37.7283131886973, -122.369818081152) | |||
157031 | 157031 | 206985 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1498 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5990877.17813 | 2105275.0931700002 | 37.760158953986604 | -122.474655794123 | (37.7601589539866, -122.474655794123) | |||
156249 | 156249 | 206984 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1498 17th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5990877.91026 | 2105249.91359 | 37.7600898599821 | -122.47465142432199 | (37.7600898599821, -122.474651424322) | |||
153240 | 153240 | 95898 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1700 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767603 | 5989073.1619 | 2103670.6386 | 37.755648856222 | -122.48077749293999 | (37.755648856222, -122.48077749294) |
153218 | 153218 | 182607 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1867 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986269.2088 | 2102542.1488 | 37.7523869566931 | -122.49039129916001 | (37.7523869566931, -122.49039129916) | |||
153201 | 153201 | 98850 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1795X 31st Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768753 | 5986486.2 | 2103095.0 | 37.7539176067687 | -122.489681571094 | (37.7539176067687, -122.489681571094) | |
152469 | 152469 | 113356 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 2 Point Lobos Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 3X3 | 5982735.90689 | 2112577.0088400003 | 37.7797328087219 | -122.503352793138 | (37.7797328087219, -122.503352793138) | |||
149848 | 149848 | 206999 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 404 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991570.38275 | 2099794.54343 | 37.7451509372588 | -122.471858917877 | (37.7451509372588, -122.471858917877) | |||
148929 | 148929 | 63095 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1314 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/04/2016 12:00:00 AM | 1 | Permit Number 775034 | 5982157.61974918 | 2106142.20642168 | 37.7620306969809 | -122.504876348182 | (37.7620306969809, -122.504876348182) | ||
148319 | 148319 | 207042 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 40 Vasquez Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995660.33467 | 2100048.89738 | 37.746085134133 | -122.45773506422701 | (37.746085134133, -122.457735064227) | |||
147441 | 147441 | 227568 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 287 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002743.271790001 | 2104198.2878099997 | 37.7578827294299 | -122.433539694925 | (37.7578827294299, -122.433539694925) | |||
146911 | 146911 | 79199 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 409 Laurel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/2015 12:00:00 AM | 1 | Permit Number 777130 | 5998120.56156 | 2115036.84682 | 37.7873792631851 | -122.450308169597 | (37.7873792631851, -122.450308169597) | |
145461 | 145461 | 111714 | Planning Code 138.1 required 4 | Lagunaria patersonii :: Primrose Tree 48 | 3038 CLEMENT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | 1 | 3x3 | Permit Number 777015 | 5986051.0 | 2113265.0 | 37.7818161572934 | -122.491935266217 | (37.7818161572934, -122.491935266217) | |
138540 | 138540 | 176888 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 13 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002306.40089 | 2092528.2983099998 | 37.7258148612434 | -122.43421630345301 | (37.7258148612434, -122.434216303453) | |||
135392 | 135392 | 181684 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1347 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986459.3313 | 2106064.8642 | 37.7620704697574 | -122.48999290967501 | (37.7620704697574, -122.489992909675) | |||
133488 | 133488 | 118589 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 150 Point Lobos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5982275.325019999 | 2112634.79146 | 37.779864376411 | -122.50495040283998 | (37.779864376411, -122.50495040284) | |||
132152 | 132152 | 117686 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 34 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 5982669.571880001 | 2112585.47797 | 37.7797521626965 | -122.503582898398 | (37.7797521626965, -122.503582898398) | |||
131058 | 131058 | 227103 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 138 Rivoli St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5998021.55452 | 2105968.74453 | 37.7624749295086 | -122.449996897152 | (37.7624749295086, -122.449996897152) | |||
130143 | 130143 | 182826 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1781 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986558.6884 | 2103101.4836 | 37.7539396409234 | -122.48943136928999 | (37.7539396409234, -122.48943136929) | |||
122015 | 122015 | 88207 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 187 Beaumont Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51211 | 5996848.1239 | 2111670.4224 | 37.7780630497691 | -122.454467238117 | (37.7780630497691, -122.454467238117) | |
117673 | 117673 | 140302 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 143 COLE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5997780.8586 | 2110053.3207 | 37.773676357183 | -122.45112394331899 | (37.773676357183, -122.451123943319) | |||
116120 | 116120 | 113418 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 598X BENTON AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6007207.0 | 2095355.0 | 37.7338532991757 | -122.417475487879 | (37.7338532991757, -122.417475487879) | |||
115830 | 115830 | 95897 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1700 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767603 | 5989075.8995 | 2103638.8826 | 37.7555618218669 | -122.48076570081301 | (37.7555618218669, -122.480765700813) |
104217 | 104217 | 191223 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1112 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6012178.19052 | 2103217.19746 | 37.7557196692435 | -122.400840661869 | (37.7557196692435, -122.400840661869) | |||
101502 | 101502 | 111713 | Planning Code 138.1 required 4 | Lagunaria patersonii :: Primrose Tree 48 | 3038 CLEMENT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | 1 | 3x3 | Permit Number 777015 | 5986051.0 | 2113265.0 | 37.7818161572934 | -122.491935266217 | (37.7818161572934, -122.491935266217) | |
82449 | 82449 | 112583 | Section 143 8 | Lagunaria patersonii :: Primrose Tree 48 | 3400x WAWONA ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 1 | 4x4 | 5982411.0 | 2096792.0 | 37.7363725426512 | -122.50330767262899 | (37.7363725426512, -122.503307672629) | |||
76646 | 76646 | 46375 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2214 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51267 | 5982984.1214 | 2100027.2965 | 37.745289455195 | -122.501565454542 | (37.745289455195, -122.501565454542) | |
76631 | 76631 | 207009 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 451 Hearst Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5998610.96321 | 2094365.8508 | 37.7306499124634 | -122.44712329519699 | (37.7306499124634, -122.447123295197) | |||
75318 | 75318 | 176901 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 167 Madison St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6005600.43917 | 2092849.05844 | 37.7268820102711 | -122.42285182346599 | (37.7268820102711, -122.422851823466) | |||
73895 | 73895 | 176887 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 13 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6002286.64114 | 2092541.4001799999 | 37.725849714484404 | -122.434285547657 | (37.7258497144844, -122.434285547657) | |||
71244 | 71244 | 227084 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1217 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010060.56336 | 2102014.9446799997 | 37.7523002058063 | -122.408079341009 | (37.7523002058063, -122.408079341009) | |||
70932 | 70932 | 119542 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 791 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5986618.95807 | 2110548.82595 | 37.7743914964818 | -122.48977060648899 | (37.7743914964818, -122.489770606489) | |||
70354 | 70354 | 207004 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 171 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992803.19794 | 2098037.0989599996 | 37.7403966964551 | -122.46746831791 | (37.7403966964551, -122.46746831791) | |||
68212 | 68212 | 119242 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 50 Sutro Heights Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5981417.66127 | 2111333.86508 | 37.7762419210818 | -122.507820820241 | (37.7762419210818, -122.507820820241) | |||
66926 | 66926 | 184599 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1795 40th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983770.6594 | 2102984.6576 | 37.7534557168171 | -122.499064248064 | (37.7534557168171, -122.499064248064) | |||
66467 | 66467 | 176899 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 167 Madison St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6005613.54422 | 2092807.28897 | 37.7267680598911 | -122.422803552358 | (37.7267680598911, -122.422803552358) | |||
65062 | 65062 | 201810 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 6ft | 6021035.70856 | 2093179.8039900002 | 37.7286490171175 | -122.369514606714 | (37.7286490171175, -122.369514606714) | |||
64913 | 64913 | 201811 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 6ft | 6021050.71889 | 2093203.62599 | 37.7287152512926 | -122.369464359799 | (37.7287152512926, -122.369464359799) | |||
63806 | 63806 | 181949 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2450 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986451.9754 | 2098568.253 | 37.7414863814969 | -122.489467090095 | (37.7414863814969, -122.489467090095) | |||
62998 | 62998 | 176882 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 371 Wilde Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010924.50069 | 2089093.90072 | 37.7168700890604 | -122.404182392406 | (37.7168700890604, -122.404182392406) | |||
59233 | 59233 | 108371 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 575 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 3x3 | 6001620.80772 | 2090281.19611 | 37.719605888781295 | -122.43642558878 | (37.7196058887813, -122.43642558878) | ||
58124 | 58124 | 206995 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1584 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993720.55073 | 2104714.02617 | 37.7587827556425 | -122.464781251568 | (37.7587827556425, -122.464781251568) | |||
57165 | 57165 | 176885 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 191 Rey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008580.05361 | 2087004.5673599998 | 37.7110019335603 | -122.412138452652 | (37.7110019335603, -122.412138452652) | |||
56930 | 56930 | 207038 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 270 Magellan Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5994641.46146 | 2100307.8933900003 | 37.7467376875983 | -122.461276941602 | (37.7467376875983, -122.461276941602) | |||
56558 | 56558 | 207005 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 171 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992787.45104 | 2098017.3287299997 | 37.7403415032629 | -122.467521326669 | (37.7403415032629, -122.467521326669) | |||
53500 | 53500 | 227128 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 248 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004363.9622599995 | 2096949.7405400001 | 37.7380717187222 | -122.427418297528 | (37.7380717187222, -122.427418297528) | |||
52877 | 52877 | 118595 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 101 Point Lobos Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5982415.15882 | 2112561.71552 | 37.7796719571588 | -122.504461248614 | (37.7796719571588, -122.504461248614) | |||
52735 | 52735 | 176874 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 526 Lathrop Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6012843.86934 | 2086597.3532 | 37.7101221250005 | -122.397373047849 | (37.7101221250005, -122.397373047849) | |||
52529 | 52529 | 176915 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 143 Somerset St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6009701.03874 | 2093769.75693 | 37.7296405745301 | -122.408741008189 | (37.7296405745301, -122.408741008189) | |||
50519 | 50519 | 201808 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 247 Friedell St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 6ft | 6020927.8472 | 2093035.08257 | 37.7282457215548 | -122.369877496672 | (37.7282457215548, -122.369877496672) | |||
50178 | 50178 | 206987 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1248 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5992091.43933 | 2106913.6178900003 | 37.7647281934706 | -122.47057562128799 | (37.7647281934706, -122.470575621288) | |||
48201 | 48201 | 119241 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 50 Sutro Heights Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5981435.03386 | 2111334.77238 | 37.776245435782 | -122.50776079209999 | (37.776245435782, -122.5077607921) | |||
47585 | 47585 | 176883 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 96 Alpha St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6011048.63475 | 2088252.8219299999 | 37.7145675926038 | -122.40369417294501 | (37.7145675926038, -122.403694172945) | ||||
47498 | 47498 | 119083 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 863 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5981985.30992 | 2109867.54201 | 37.7722492542332 | -122.505748473333 | (37.7722492542332, -122.505748473333) | |||
46553 | 46553 | 95899 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1700 23rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767603 | 5989072.0669 | 2103701.2996 | 37.7557329794721 | -122.480783524363 | (37.7557329794721, -122.480783524363) |
46405 | 46405 | 176898 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 167 Madison St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6005619.38027 | 2092788.13013 | 37.7267157831975 | -122.42278201629601 | (37.7267157831975, -122.422782016296) | |||
44865 | 44865 | 46434 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2St. Ankeny St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 1 | Permit Number 47151 | 6011096.25435 | 2089701.2859 | 37.7185474406786 | -122.40363143174 | (37.7185474406786, -122.40363143174) | |
43893 | 43893 | 117895 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 635 38th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5984097.32613 | 2111483.29523 | 37.7768097259285 | -122.498562310404 | (37.7768097259285, -122.498562310404) | |||
43685 | 43685 | 46431 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2St. Ankeny St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2002 12:00:00 AM | 1 | Permit Number 44652 | 6011089.42189 | 2089718.35805 | 37.7185939356546 | -122.40365624942899 | (37.7185939356546, -122.403656249429) | ||
43034 | 43034 | 140758 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 42 TERRA VISTA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000316.7782 | 2112875.0348 | 37.781568928755895 | -122.442554464995 | (37.7815689287559, -122.442554464995) | |||
42609 | 42609 | 227117 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 129 Rousseau St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6003535.84775 | 2095026.7825099998 | 37.7327448417949 | -122.430144356698 | (37.7327448417949, -122.430144356698) | |||
41920 | 41920 | 227112 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 82 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6007863.71848 | 2099963.32211 | 37.7465436642568 | -122.41553116305 | (37.7465436642568, -122.41553116305) | |||
41737 | 41737 | 183303 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1286 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982766.9656 | 2106385.9546 | 37.7627357893861 | -122.502786935917 | (37.7627357893861, -122.502786935917) | |||
41516 | 41516 | 46433 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2St. Ankeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 1 | Permit Number 47151 | 6011103.47209 | 2089684.5822599998 | 37.718501979072 | -122.403605308234 | (37.718501979072, -122.403605308234) | |
40793 | 40793 | 78252 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 541 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2015 12:00:00 AM | 1 | 3x3 | Permit Number 776648 | 6003018.571219999 | 2090471.0211200002 | 37.7202064317688 | -122.43160757344299 | (37.7202064317688, -122.431607573443) | |
38258 | 38258 | 113355 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 2 Point Lobos Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 3X3 | 5982766.03998 | 2112575.4615 | 37.779730331527404 | -122.503248436763 | (37.7797303315274, -122.503248436763) | |||
37433 | 37433 | 184723 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1635 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983115.9866 | 2103988.5253 | 37.7561736313112 | -122.501402462618 | (37.7561736313112, -122.501402462618) | |||
36351 | 36351 | 119164 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 883 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5981372.52859 | 2109725.62562 | 37.7718235084184 | -122.507857566702 | (37.7718235084184, -122.507857566702) |
JSON shape: default, array, newline-delimited
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");