Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▲ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 165387 | 165387 | 191435 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1310 Indiana St | 1 | : Yard 23 | Tree 1 | Private 1 | 1 | 6014946.60084 | 2102566.4575099996 | 37.75408690420971 | -122.39122105282699 | (37.7540869042097, -122.391221052827) | ||||
| 10000 | 10000 | 173780 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 99X Cleveland St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x6 | 6010549.0 | 2110746.0 | 37.7763010397716 | -122.40700558704799 | (37.7763010397716, -122.407005587048) | ||||
| 31792 | 31792 | 247877 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 388 Mayflower St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6009910.50595 | 2098381.82666 | 37.7423160592417 | -122.408342032063 | (37.7423160592417, -122.408342032063) | ||||
| 35045 | 35045 | 247843 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 151 Chapman St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | 6009097.48489 | 2098216.36998 | 37.7418161899782 | -122.411141537049 | (37.7418161899782, -122.411141537049) | ||||
| 47461 | 47461 | 247844 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 151 Chapman St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6009115.842759999 | 2098211.0441099997 | 37.7418025958075 | -122.41107768521002 | (37.7418025958075, -122.41107768521) | ||||
| 49010 | 49010 | 227460 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 198 Corbin Pl | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | Width 3ft | 6000080.81195 | 2105721.26672 | 37.7619130330842 | -122.442856931222 | (37.7619130330842, -122.442856931222) | |||
| 53472 | 53472 | 207987 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 714 Detroit St | 19 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 5999466.174219999 | 2095456.6543299998 | 37.7336938298041 | -122.444245066271 | (37.7336938298041, -122.444245066271) | ||||
| 54173 | 54173 | 248064 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 18 Rutledge St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6010656.53215 | 2099389.02438 | 37.7451233541731 | -122.40583342000099 | (37.7451233541731, -122.405833420001) | ||||
| 56715 | 56715 | 207986 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 714 Detroit St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5999466.52885 | 2095410.65053 | 37.733567534417794 | -122.444240535497 | (37.7335675344178, -122.444240535497) | ||||
| 68436 | 68436 | 227459 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 198 Corbin Pl | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 3ft | 6000082.87905 | 2105698.79506 | 37.761851449312 | -122.442848168232 | (37.761851449312, -122.442848168232) | |||
| 75256 | 75256 | 227503 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 31 Poppy Ln | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 3ft | 6002189.282000001 | 2096805.2578 | 37.7375517667019 | -122.43492690907499 | (37.7375517667019, -122.434926909075) | |||
| 147117 | 147117 | 129641 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 943 Green St | 12 | Side Yard : Yard 17 | Tree 1 | Private 1 | 41 | 6008676.12705 | 2118976.42517 | 37.7987948111981 | -122.41406679246201 | (37.7987948111981, -122.414066792462) | ||||
| 147949 | 147949 | 247848 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 149 Chapman St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 37 | 6009193.51112 | 2098205.9216299998 | 37.7417928858333 | -122.410808770816 | (37.7417928858333, -122.410808770816) | ||||
| 151939 | 151939 | 247878 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 388 Mayflower St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6009913.73125 | 2098387.19098 | 37.7423309691095 | -122.408331258187 | (37.7423309691095, -122.408331258187) | ||||
| 166825 | 166825 | 248057 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 17 Rutledge St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6010678.5248 | 2099352.93022 | 37.7450254773569 | -122.405754830944 | (37.7450254773569, -122.405754830944) | ||||
| 71556 | 71556 | 227504 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 16 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 2ft | 6002174.41423 | 2096447.2518799999 | 37.7365679209746 | -122.434952717804 | (37.7365679209746, -122.434952717804) | |||
| 187310 | 187310 | 227505 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 11 Ohlone Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002170.3179 | 2096422.89629 | 37.7365008135581 | -122.434965139225 | (37.7365008135581, -122.434965139225) | |||
| 52138 | 52138 | 177088 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 300x Winding Way | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 6001504.621119999 | 2086478.58914 | 37.7091581713864 | -122.436555171203 | (37.7091581713864, -122.436555171203) | |||
| 26027 | 26027 | 227311 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 405 Beacon St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6002323.66405 | 2098293.59277 | 37.7416460184529 | -122.434568676724 | (37.7416460184529, -122.434568676724) | |||
| 29149 | 29149 | 226660 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2 Dolores St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6004732.5122 | 2108095.82328 | 37.7686970968169 | -122.426937645858 | (37.7686970968169, -122.426937645858) | |||
| 34184 | 34184 | 129681 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 464 California St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6012011.03614 | 2116789.35281 | 37.7929763782966 | -122.402372995143 | (37.7929763782966, -122.402372995143) | |||
| 34507 | 34507 | 129677 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 464 California St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6012069.97592 | 2116796.7218299997 | 37.792999901879604 | -122.402169577472 | (37.7929999018796, -122.402169577472) | |||
| 37277 | 37277 | 177144 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 224 Naylor St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6002612.15992 | 2086733.11082 | 37.709919907953704 | -122.43274552071001 | (37.7099199079537, -122.43274552071) | |||
| 37884 | 37884 | 226699 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 38 Ramona Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 4ft | 6005184.56747 | 2107580.1746400003 | 37.767306799804004 | -122.42533732116001 | (37.767306799804, -122.42533732116) | |||
| 37891 | 37891 | 227521 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1500 Cole St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 4ft | 5998355.105169999 | 2105264.42447 | 37.7605601235622 | -122.448792539459 | (37.7605601235622, -122.448792539459) | |||
| 47017 | 47017 | 129614 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1050 Van Ness Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6006528.24106 | 2114177.52587 | 37.7854973571526 | -122.42115824896999 | (37.7854973571526, -122.42115824897) | |||
| 49510 | 49510 | 129642 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1161 Greenwich St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 5ft | 6007337.31848 | 2119837.29751 | 37.8010832638317 | -122.418760599735 | (37.8010832638317, -122.418760599735) | |||
| 49847 | 49847 | 129680 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 464 California St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6012023.6782599995 | 2116790.52383 | 37.792980299349395 | -122.40232933485001 | (37.7929802993494, -122.40232933485) | |||
| 51625 | 51625 | 129675 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 464 California St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6012092.09526 | 2116799.4138599997 | 37.79300852816029 | -122.402093232241 | (37.7930085281603, -122.402093232241) | |||
| 59724 | 59724 | 227210 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 35 Powhattan Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 6007580.30046 | 2098202.33291 | 37.7416924459422 | -122.416386483043 | (37.7416924459422, -122.416386483043) | |||
| 60893 | 60893 | 129592 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1700 Jackson St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6005880.07877 | 2117261.61148 | 37.79392892673889 | -122.42362005315 | (37.7939289267389, -122.42362005315) | |||
| 61599 | 61599 | 227266 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 748 Duncan St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | 6001689.1464 | 2099734.32113 | 37.7455658790712 | -122.436865735875 | (37.7455658790712, -122.436865735875) | ||||
| 66370 | 66370 | 226659 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2 Dolores St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6004732.43221 | 2108111.34467 | 37.768739710290205 | -122.42693902812799 | (37.7687397102902, -122.426939028128) | |||
| 66714 | 66714 | 227264 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 748 Duncan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | 6001689.2287 | 2099738.29729 | 37.7455768013454 | -122.436865735887 | (37.7455768013454, -122.436865735887) | ||||
| 72192 | 72192 | 129625 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 54 Glover St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 2ft | 6008038.60532 | 2118409.42437 | 37.7972021406145 | -122.416232651327 | (37.7972021406145, -122.416232651327) | |||
| 72591 | 72591 | 177042 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 123 Seneca Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 0ft | 6000059.76293 | 2090063.89794 | 37.7189204111404 | -122.441805953806 | (37.7189204111404, -122.441805953806) | |||
| 74224 | 74224 | 227312 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 405 Beacon St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 6002324.80027 | 2098291.20811 | 37.7416395352327 | -122.43456457759301 | (37.7416395352327, -122.434564577593) | |||
| 130904 | 130904 | 129591 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1700 Jackson St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6005908.12306 | 2117266.84801 | 37.7939448878875 | -122.42352338950899 | (37.7939448878875, -122.423523389509) | |||
| 134338 | 134338 | 129590 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1870 Sacramento St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 5ft | 6005845.5146 | 2116275.22301 | 37.7912186002945 | -122.423669483476 | (37.7912186002945, -122.423669483476) | |||
| 135533 | 135533 | 129679 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 464 California St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6012036.63622 | 2116793.11614 | 37.792988140540004 | -122.40228468169799 | (37.79298814054, -122.402284681698) | |||
| 136993 | 136993 | 129589 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1870 Sacramento St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 5ft | 6005852.90495 | 2116274.14842 | 37.7912160669044 | -122.423643836609 | (37.7912160669044, -122.423643836609) | |||
| 146811 | 146811 | 129676 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 464 California St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6012082.98226 | 2116799.13729 | 37.7930072601221 | -122.402124744455 | (37.7930072601221, -122.402124744455) | |||
| 152082 | 152082 | 227211 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 225 Montcalm St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 23 | Width 3ft | 6009836.16533 | 2099585.28248 | 37.7456163229324 | -122.408683960589 | (37.7456163229324, -122.408683960589) | |||
| 155845 | 155845 | 129674 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 464 California St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6012104.09602 | 2116801.48556 | 37.793014886365796 | -122.402051854416 | (37.7930148863658, -122.402051854416) | |||
| 157783 | 157783 | 227304 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2211 Castro St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | 6002725.4323 | 2099066.84867 | 37.7437919986955 | -122.433234737486 | (37.7437919986955, -122.433234737486) | ||||
| 158841 | 158841 | 177143 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 224 Naylor St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6002598.76646 | 2086748.83961 | 37.7099623361716 | -122.432792933869 | (37.7099623361716, -122.432792933869) | |||
| 159072 | 159072 | 227265 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 748 Duncan St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | 6001689.18438 | 2099736.15615 | 37.7455709197615 | -122.436865735887 | (37.7455709197615, -122.436865735887) | ||||
| 165909 | 165909 | 227209 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 35 Powhattan Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6007561.8732 | 2098204.30964 | 37.741696837339504 | -122.416450338512 | (37.7416968373395, -122.416450338512) | |||
| 166303 | 166303 | 227396 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 5 28th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6005864.943030001 | 2099629.40283 | 37.7455142453913 | -122.422418999536 | (37.7455142453913, -122.422418999536) | |||
| 167437 | 167437 | 226661 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2 Dolores St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6004732.99983 | 2108080.69145 | 37.7686555760307 | -122.42693488134199 | (37.7686555760307, -122.426934881342) | |||
| 180427 | 180427 | 247286 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 644 Stanyan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 0ft | 5997022.454 | 2108829.1148 | 37.7702715542748 | -122.453658952423 | (37.7702715542748, -122.453658952423) | |||
| 181593 | 181593 | 143365 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1735 UNION ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 0ft | 6004681.3503 | 2118768.1568 | 37.7979977794826 | -122.427875172085 | (37.7979977794826, -122.427875172085) | |||
| 183200 | 183200 | 227303 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2211 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | 6002724.72616 | 2099043.5598 | 37.7437280128274 | -122.43323551541701 | (37.7437280128274, -122.433235515417) | ||||
| 183307 | 183307 | 129678 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 464 California St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6012048.39516 | 2116793.1627 | 37.7929889247624 | -122.402243998167 | (37.7929889247624, -122.402243998167) | |||
| 184110 | 184110 | 227208 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 35 Powhattan Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 22 | Width 3ft | 6007523.932469999 | 2098207.4852299998 | 37.741703423083294 | -122.416581750143 | (37.7417034230833, -122.416581750143) | |||
| 3801 | 3801 | 177109 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 6 | Width 5ft | 5998958.08532 | 2091518.52367 | 37.72285164275971 | -122.445718558684 | (37.7228516427597, -122.445718558684) | |||
| 3805 | 3805 | 177105 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 4 | Width 5ft | 5998924.5969 | 2091518.7811599998 | 37.7228504376811 | -122.445834339179 | (37.7228504376811, -122.445834339179) | |||
| 3806 | 3806 | 177110 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 6 | Width 5ft | 5998978.57855 | 2091518.5364400002 | 37.722852847868 | -122.445647719081 | (37.722852847868, -122.445647719081) | |||
| 3808 | 3808 | 177108 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 5 | Width 5ft | 5998950.80755 | 2091518.23612 | 37.7228504376851 | -122.44574369563999 | (37.7228504376851, -122.44574369564) | |||
| 3826 | 3826 | 177104 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 4 | Width 5ft | 5998921.0818300005 | 2091519.29315 | 37.722851642780796 | -122.44584652679501 | (37.7228516427808, -122.445846526795) | |||
| 3827 | 3827 | 177106 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 7 | Width 5ft | 5998933.177730001 | 2091518.16383 | 37.7228492325857 | -122.44580463279199 | (37.7228492325857, -122.445804632792) | |||
| 23612 | 23612 | 177049 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2134 San Jose Ave | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5998733.2334 | 2090880.1248400002 | 37.721085906663106 | -122.44644991615299 | (37.7210859066631, -122.446449916153) | |||
| 23905 | 23905 | 207996 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 395 Joost Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 5999475.26279 | 2094946.5125 | 37.732293618635396 | -122.44417699929 | (37.7322936186354, -122.44417699929) | |||
| 24079 | 24079 | 207947 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2300 09th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5992701.4282599995 | 2100499.03593 | 37.74715067337829 | -122.467999226394 | (37.7471506733783, -122.467999226394) | |||
| 24194 | 24194 | 122139 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5991116.38675 | 2114975.72508 | 37.7868081061645 | -122.474536454895 | (37.7868081061645, -122.474536454895) | ||||
| 24370 | 24370 | 207978 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 155 Burnside Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 6001108.30575 | 2095400.37488 | 37.733632849462104 | -122.43856371615101 | (37.7336328494621, -122.438563716151) | |||
| 24921 | 24921 | 185624 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2100 Sunset Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985032.5384 | 2100289.574 | 37.74612969593421 | -122.49450180509399 | (37.7461296959342, -122.494501805094) | |||
| 25706 | 25706 | 207376 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1200 14th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 7ft | 5991774.71222 | 2107128.83955 | 37.7653008152139 | -122.471686772321 | (37.7653008152139, -122.471686772321) | |||
| 26392 | 26392 | 207957 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 70 Woodside Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5995759.15859 | 2100245.2253900003 | 37.7466298786655 | -122.45740754733102 | (37.7466298786655, -122.457407547331) | |||
| 26709 | 26709 | 177070 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 195 Allison St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6000082.94652 | 2087742.95013 | 37.712548932973206 | -122.44155935339501 | (37.7125489329732, -122.441559353395) | |||
| 27197 | 27197 | 207942 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2300 09th Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5992674.85425 | 2100498.92504 | 37.7471488342516 | -122.468091108325 | (37.7471488342516, -122.468091108325) | |||
| 28430 | 28430 | 207999 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 395 Joost Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5999487.38528 | 2094945.2711599998 | 37.732290901786605 | -122.444135000045 | (37.7322909017866, -122.444135000045) | |||
| 29050 | 29050 | 207850 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 277 Thrift St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 4ft | 5994296.2066 | 2089616.42482 | 37.7173616620944 | -122.461695729788 | (37.7173616620944, -122.461695729788) | |||
| 29728 | 29728 | 207935 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 145 Ridgewood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5996775.70026 | 2094622.40699 | 37.73124932318171 | -122.453486560779 | (37.7312493231817, -122.453486560779) | |||
| 30774 | 30774 | 227328 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 61 Elk St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 2ft | 6000814.1059 | 2096414.9830099999 | 37.7364019870456 | -122.43965356137801 | (37.7364019870456, -122.439653561378) | |||
| 31307 | 31307 | 208013 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 58 Marston Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5998954.84466 | 2093225.77807 | 37.7275391817664 | -122.44585248661001 | (37.7275391817664, -122.44585248661) | ||||
| 31560 | 31560 | 207988 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 843 Detroit St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 5999421.70434 | 2095638.9238900002 | 37.7341917619256 | -122.44441190581101 | (37.7341917619256, -122.444411905811) | |||
| 32112 | 32112 | 191454 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 110 Main St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 3ft | 6014422.1933 | 2115994.29604 | 37.790927639935205 | -122.39397451700701 | (37.7909276399352, -122.393974517007) | |||
| 34135 | 34135 | 208002 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 395 Joost Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5999487.2394900005 | 2094938.2542299998 | 37.7322716266247 | -122.44413500004299 | (37.7322716266247, -122.444135000043) | |||
| 34744 | 34744 | 177051 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 765 Delano Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5998951.86154 | 2090168.3011 | 37.7191438872553 | -122.44564302283199 | (37.7191438872553, -122.445643022832) | |||
| 34798 | 34798 | 122131 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 5991115.120209999 | 2115013.7594 | 37.786912464412104 | -122.47454361357 | (37.7869124644121, -122.47454361357) | ||||
| 35118 | 35118 | 249626 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2450 Golden Gate Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 7ft | 5997629.20154 | 2111320.8976 | 37.7771481106256 | -122.45174000362199 | (37.7771481106256, -122.451740003622) | |||
| 35972 | 35972 | 207841 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 314 Faxon Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5994779.70633 | 2090681.1537400002 | 37.72031297444521 | -122.460101600536 | (37.7203129744452, -122.460101600536) | |||
| 36259 | 36259 | 208014 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 58 Marston Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5998954.765869999 | 2093228.45695 | 37.7275465328469 | -122.44585295156901 | (37.7275465328469, -122.445852951569) | ||||
| 37843 | 37843 | 249627 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2450 Golden Gate Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | Width 7ft | 5997621.56946 | 2111320.25827 | 37.777145918089 | -122.45176635913602 | (37.777145918089, -122.451766359136) | |||
| 38703 | 38703 | 191455 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 110 Main St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6014431.23151 | 2115982.96922 | 37.7908970414242 | -122.393942451705 | (37.7908970414242, -122.393942451705) | |||
| 38750 | 38750 | 208004 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 551 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5998446.15319 | 2094958.3543599998 | 37.7322673692323 | -122.447735703852 | (37.7322673692323, -122.447735703852) | |||
| 38825 | 38825 | 186910 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2700 Sunset Blvd | 59 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985181.9251 | 2096700.884 | 37.7362848611965 | -122.49372085206998 | (37.7362848611965, -122.49372085207) | |||
| 40353 | 40353 | 207983 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 620 Detroit St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5999460.54725 | 2095077.27531 | 37.7326518231051 | -122.44423726735799 | (37.7326518231051, -122.444237267358) | |||
| 41490 | 41490 | 227279 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4530 25th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | Width 4ft | 6000798.050340001 | 2101148.90098 | 37.749399291454 | -122.44004841589701 | (37.749399291454, -122.440048415897) | |||
| 41868 | 41868 | 227288 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 689 29th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6002143.45873 | 2098830.19502 | 37.7431091713442 | -122.43523013797501 | (37.7431091713442, -122.435230137975) | ||||
| 42545 | 42545 | 227299 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4233 Cesar Chavez St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6002389.0649 | 2100323.63751 | 37.7472237585745 | -122.43448765677499 | (37.7472237585745, -122.434487656775) | ||||
| 42940 | 42940 | 227287 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 689 29th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6002120.490069999 | 2098829.19814 | 37.74310512978921 | -122.435309486038 | (37.7431051297892, -122.435309486038) | ||||
| 43925 | 43925 | 177069 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 195 Allison St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6000083.89105 | 2087741.94761 | 37.7125462340909 | -122.44155601691901 | (37.7125462340909, -122.441556016919) | |||
| 44811 | 44811 | 177047 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2134 San Jose Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5998747.58389 | 2090903.38197 | 37.721150585016 | -122.446401983167 | (37.721150585016, -122.446401983167) | |||
| 44820 | 44820 | 122132 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 5991115.98152 | 2115010.99351 | 37.7869049199545 | -122.47454043173401 | (37.7869049199545, -122.474540431734) | ||||
| 45149 | 45149 | 177118 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 224 Avalon Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 6003359.98068 | 2092814.5992700001 | 37.726660722214 | -122.430594576183 | (37.726660722214, -122.430594576183) | |||
| 45456 | 45456 | 207958 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 70 Woodside Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5995753.89015 | 2100245.5855099997 | 37.7466305648554 | -122.457425790981 | (37.7466305648554, -122.457425790981) | |||
| 46018 | 46018 | 207936 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 145 Ridgewood Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5996773.84945 | 2094603.0079700002 | 37.731195952027996 | -122.453491559201 | (37.731195952028, -122.453491559201) | |||
| 46096 | 46096 | 122133 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 5991114.065719999 | 2115007.37065 | 37.7868948615896 | -122.474546795399 | (37.7868948615896, -122.474546795399) |
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");