Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 262 | 262 | 141360 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1499X Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6000919.0 | 2110350.0 | 37.77467013322371 | -122.44028993459101 | (37.7746701332237, -122.440289934591) | |||
| 323 | 323 | 27392 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2240 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6007139.14869 | 2120046.64789 | 37.801646927424706 | -122.419461214785 | (37.8016469274247, -122.419461214785) | |||
| 1858 | 1858 | 12328 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1025 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004756.1585 | 2112422.6893 | 37.780578952523996 | -122.427164094387 | (37.780578952524, -122.427164094387) | |||
| 2010 | 2010 | 142062 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1100 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/02/2014 12:00:00 AM | 10 | Width 0ft | Permit Number 771276 | 6004214.4178 | 2112228.4 | 37.780014831771 | -122.429024376887 | (37.780014831771, -122.429024376887) | |
| 2240 | 2240 | 122755 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 693 Vermont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 14 | 6011274.22678 | 2105356.76628 | 37.7615439863765 | -122.40411744427601 | (37.7615439863765, -122.404117444276) | |||
| 2249 | 2249 | 191500 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1196 La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | Width 3ft | 6016876.9140800005 | 2094649.78681 | 37.732456273623704 | -122.38399426453998 | (37.7324562736237, -122.38399426454) | |||
| 2918 | 2918 | 140306 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2084 HAYES ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5997911.1716 | 2109955.9635 | 37.773416499401705 | -122.450666152059 | (37.7734164994017, -122.450666152059) | |||
| 3258 | 3258 | 253374 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 99x Ogden Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007537.0 | 2096150.0 | 37.7360547576169 | -122.416390866966 | (37.7360547576169, -122.416390866966) | ||||
| 3852 | 3852 | 244053 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 401 Cole St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5997903.1431 | 2109164.16 | 37.7712419510675 | -122.450636826227 | (37.7712419510675, -122.450636826227) | |||
| 4593 | 4593 | 129647 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2210 Stockton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009820.66032 | 2121686.06094 | 37.80629901694589 | -122.41029773825899 | (37.8062990169459, -122.410297738259) | |||
| 6106 | 6106 | 7959 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1800 Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005709.66614 | 2116337.52814 | 37.791382005314 | -122.424143948706 | (37.791382005314, -122.424143948706) | |||
| 7129 | 7129 | 20204 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1315 Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6002765.7195 | 2112737.651 | 37.7813309972121 | -122.434072484072 | (37.7813309972121, -122.434072484072) | |||
| 7677 | 7677 | 11437 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2100X Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005576.77796 | 2117294.0070599997 | 37.7940007519905 | -122.42467181025499 | (37.7940007519905, -122.424671810255) | |||
| 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) | ||||
| 11530 | 11530 | 77642 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 12 | 4x4 | 6006942.1040900005 | 2093179.9332599998 | 37.7278661320969 | -122.418237156514 | (37.7278661320969, -122.418237156514) | |
| 13198 | 13198 | 25303 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 286 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x9 | 5999775.2112 | 2091625.73202 | 37.7231926324273 | -122.4429016302 | (37.7231926324273, -122.4429016302) | |||
| 14433 | 14433 | 17144 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1030 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/30/1997 12:00:00 AM | 3 | 3X3 | 6017899.57967 | 2093362.5240900002 | 37.728978186084 | -122.38036919809099 | (37.728978186084, -122.380369198091) | ||
| 16260 | 16260 | 25705 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 564 06th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 2X2 | 6012100.37031 | 2110300.97089 | 37.7751657827012 | -122.40160764957399 | (37.7751657827012, -122.401607649574) | |||
| 21469 | 21469 | 15341 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1735 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6006768.902000001 | 2108274.3401 | 37.769302196475294 | -122.419906586242 | (37.7693021964753, -122.419906586242) | |||
| 24097 | 24097 | 177096 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 0 Serrano Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 32 | 5989524.60255 | 2090740.4518099998 | 37.720172132521206 | -122.47827090148199 | (37.7201721325212, -122.478270901482) | ||||
| 24247 | 24247 | 227356 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 701 Ogden Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6007559.31004 | 2096165.80664 | 37.7360994137559 | -122.41631485115101 | (37.7360994137559, -122.416314851151) | |||
| 24746 | 24746 | 207954 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 20 Sotelo Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994065.04944 | 2100893.3637099997 | 37.7483120506561 | -122.46331257952801 | (37.7483120506561, -122.463312579528) | |||
| 26130 | 26130 | 207916 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Pacheco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5994697.354069999 | 2099701.1071099997 | 37.7450748213407 | -122.46103969864201 | (37.7450748213407, -122.461039698642) | |||
| 26336 | 26336 | 129613 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 711 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6009198.53973 | 2115384.83404 | 37.7889625079688 | -122.412005118241 | (37.7889625079688, -122.412005118241) | |||
| 28015 | 28015 | 227442 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4200 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002319.53063 | 2104152.62296 | 37.7577332935784 | -122.435001901726 | (37.7577332935784, -122.435001901726) | |||
| 28037 | 28037 | 226729 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3659 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6005899.1239599995 | 2104305.56232 | 37.758355830368096 | -122.422633042687 | (37.7583558303681, -122.422633042687) | |||
| 28195 | 28195 | 191490 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 190 09th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008642.47534 | 2110374.13795 | 37.775173122971296 | -122.41357449906299 | (37.7751731229713, -122.413574499063) | |||
| 29762 | 29762 | 191469 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Jack London Aly | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6014280.37989 | 2112692.06341 | 37.7818525865622 | -122.39423389317699 | (37.7818525865622, -122.394233893177) | |||
| 30046 | 30046 | 227374 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 395 Bartlett St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006788.4113 | 2101535.34281 | 37.7507995754546 | -122.419360968246 | (37.7507995754546, -122.419360968246) | |||
| 30331 | 30331 | 177074 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 250 Blanken Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6012293.95082 | 2087148.96015 | 37.711606095404704 | -122.399312384552 | (37.7116060954047, -122.399312384552) | |||
| 32273 | 32273 | 227514 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1175 Stevenson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6006464.67083 | 2109591.57876 | 37.7729018752621 | -122.42105245002399 | (37.7729018752621, -122.421052450024) | |||
| 32506 | 32506 | 227216 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 775 Alabama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6009109.62388 | 2104630.73399 | 37.7594292836568 | -122.41155264863 | (37.7594292836568, -122.41155264863) | |||
| 32666 | 32666 | 245945 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 97 Downey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998847.6292 | 2107686.9313 | 37.7672398720062 | -122.44726348656 | (37.7672398720062, -122.44726348656) | |||
| 32769 | 32769 | 226755 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 209 Day St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004144.01902 | 2098653.98264 | 37.7427387360976 | -122.428300179912 | (37.7427387360976, -122.428300179912) | |||
| 33447 | 33447 | 208010 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 126 Edna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5998766.05843 | 2093398.5760400002 | 37.728002863243205 | -122.446517546066 | (37.7280028632432, -122.446517546066) | |||
| 33606 | 33606 | 207898 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450 Wawona St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991548.15864 | 2097071.69595 | 37.7376734080929 | -122.471737369979 | (37.7376734080929, -122.471737369979) | |||
| 33838 | 33838 | 129561 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3299 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6000845.88514 | 2119539.08728 | 37.7998968278242 | -122.44120229016501 | (37.7998968278242, -122.441202290165) | |||
| 33915 | 33915 | 98646 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 8 | 5x5 | 6002771.23879 | 2119243.65965 | 37.799195144410795 | -122.43451871576099 | (37.7991951444108, -122.434518715761) | ||
| 34291 | 34291 | 207820 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 298 Staples Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5998217.897469999 | 2093812.4595700002 | 37.729107964547794 | -122.44844233986099 | (37.7291079645478, -122.448442339861) | |||
| 34352 | 34352 | 227426 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4681 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000732.63696 | 2104644.90008 | 37.7589947339321 | -122.440525327306 | (37.7589947339321, -122.440525327306) | |||
| 35298 | 35298 | 207929 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 101 San Ramon Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995760.63845 | 2092696.4312900002 | 37.7259028185378 | -122.45685654350599 | (37.7259028185378, -122.456856543506) | |||
| 36975 | 36975 | 177081 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 299 Blanken Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6012270.95689 | 2087199.0340099998 | 37.711742306725995 | -122.39939537131 | (37.711742306726, -122.39939537131) | |||
| 39043 | 39043 | 191474 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 135 South Park | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6014326.7569699995 | 2112466.04784 | 37.781234576959896 | -122.39405762156 | (37.7812345769599, -122.39405762156) | |||
| 39732 | 39732 | 140575 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1221 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003289.1195 | 2111701.1038 | 37.7785145879996 | -122.43218773018499 | (37.7785145879996, -122.432187730185) | |||
| 40608 | 40608 | 129578 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2434 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6000794.176109999 | 2116746.49388 | 37.7922261557494 | -122.441180751388 | (37.7922261557494, -122.441180751388) | |||
| 42209 | 42209 | 191438 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2209 25th St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6012142.94506 | 2101858.42279 | 37.7519868046503 | -122.400867092959 | (37.7519868046503, -122.400867092959) | ||||
| 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) | ||||
| 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) | |||
| 46122 | 46122 | 191503 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 15 Baldwin Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6017915.59707 | 2093553.456 | 37.7295033317063 | -122.380327088241 | (37.7295033317063, -122.380327088241) | |||
| 47937 | 47937 | 37498 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 645 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | 10 | Permit Number 39964 | 6010355.28098 | 2115804.39021 | 37.790179340162794 | -122.40803252947201 | (37.7901793401628, -122.408032529472) | |
| 49183 | 49183 | 227263 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 743 Duncan St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6001723.660019999 | 2099680.3247 | 37.7454195791479 | -122.436742528759 | (37.7454195791479, -122.436742528759) | |||
| 49205 | 49205 | 129595 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1730 Jackson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6005777.14779 | 2117244.21265 | 37.793875343329795 | -122.42397496697599 | (37.7938753433298, -122.423974966976) | |||
| 49343 | 49343 | 227489 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 363 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6004002.39724 | 2109025.74245 | 37.7712091182481 | -122.42952938408199 | (37.7712091182481, -122.429529384082) | |||
| 49898 | 49898 | 129598 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2111 Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6005541.322269999 | 2117252.79941 | 37.7938856036766 | -122.42479155769101 | (37.7938856036766, -122.424791557691) | |||
| 51847 | 51847 | 191496 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1198 La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6016644.61171 | 2094800.97865 | 37.732858570949205 | -122.38480792526899 | (37.7328585709492, -122.384807925269) | |||
| 52188 | 52188 | 36155 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 70 Commonwealth Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1998 12:00:00 AM | 6 | Permit Number 39238 | 5996549.1283 | 2114145.8086 | 37.784842652821496 | -122.45568053932399 | (37.7848426528215, -122.455680539324) | |
| 53062 | 53062 | 201240 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 832 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6011987.3715 | 2112559.9702 | 37.781362167572205 | -122.402157393633 | (37.7813621675722, -122.402157393633) | |||
| 53485 | 53485 | 227366 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 176 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008045.71887 | 2101127.40788 | 37.749750211412604 | -122.41498420258002 | (37.7497502114126, -122.41498420258) | |||
| 53642 | 53642 | 177061 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 550 Geneva Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 5999007.9061199995 | 2090532.0864 | 37.720145957757104 | -122.44547544316002 | (37.7201459577571, -122.44547544316) | |||
| 53838 | 53838 | 207378 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1221 Funston Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 4ft | 5992032.39492 | 2107035.89745 | 37.7650605262515 | -122.470788746219 | (37.7650605262515, -122.470788746219) | |||
| 54644 | 54644 | 227344 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3915 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008419.04093 | 2096682.95648 | 37.7375677017941 | -122.413378963976 | (37.7375677017941, -122.413378963976) | |||
| 54907 | 54907 | 207912 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 125 Montalvo Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993750.78708 | 2099620.0090799998 | 37.744797631402996 | -122.46430684749501 | (37.744797631403, -122.464306847495) | |||
| 55331 | 55331 | 177080 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 411 Blanken Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6012673.3507900005 | 2087069.8441 | 37.7114099964555 | -122.397995521673 | (37.7114099964555, -122.397995521673) | |||
| 56259 | 56259 | 207934 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Merced Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5995381.25357 | 2100216.22441 | 37.7465285358768 | -122.45871219562599 | (37.7465285358768, -122.458712195626) | |||
| 57403 | 57403 | 207920 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1475 Monterey Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993561.46186 | 2095084.6811400002 | 37.73233383991511 | -122.46463222850599 | (37.7323338399151, -122.464632228506) | |||
| 58173 | 58173 | 124075 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 701 Funston Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 3ft | 5991933.35964 | 2110333.59039 | 37.774109377871106 | -122.47137158054599 | (37.7741093778711, -122.471371580546) | |||
| 58191 | 58191 | 207377 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1201 Funston Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5992030.8504800005 | 2107135.40247 | 37.7653336512411 | -122.47080133672199 | (37.7653336512411, -122.470801336722) | ||||
| 58696 | 58696 | 207965 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 735 Foerster St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5998007.7209 | 2095786.05635 | 37.7345149737803 | -122.44931106965299 | (37.7345149737803, -122.449311069653) | |||
| 59305 | 59305 | 177114 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 34 Vienna St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 3ft | 6005072.9536 | 2093334.35555 | 37.7281847520053 | -122.42470983899099 | (37.7281847520053, -122.424709838991) | |||
| 59557 | 59557 | 142177 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1490 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6000750.4323 | 2110355.4784 | 37.7746755766034 | -122.44087343567 | (37.7746755766034, -122.44087343567) | |||
| 60067 | 60067 | 207405 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2692 16th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991464.745630001 | 2097109.88885 | 37.737773449589795 | -122.47202854890499 | (37.7377734495898, -122.472028548905) | |||
| 60162 | 60162 | 244025 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1849 Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 5997747.9602 | 2108846.3652 | 37.7703604843866 | -122.451150685898 | (37.7703604843866, -122.451150685898) | |||
| 60721 | 60721 | 245070 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 6 Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6000404.9733 | 2108969.9375 | 37.7708515497475 | -122.441968974427 | (37.7708515497475, -122.441968974427) | |||
| 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) | |||
| 60928 | 60928 | 207951 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2101 09th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993609.19049 | 2101330.01407 | 37.7494847081672 | -122.4649206222 | (37.7494847081672, -122.4649206222) | |||
| 61290 | 61290 | 227360 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 790 Alabama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009074.13968 | 2104572.98929 | 37.7592687393775 | -122.41167129082301 | (37.7592687393775, -122.411671290823) | |||
| 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) | ||||
| 63493 | 63493 | 227262 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1334 Douglass St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6001352.76553 | 2099787.74958 | 37.745693456895204 | -122.43803271325001 | (37.7456934568952, -122.43803271325) | |||
| 64260 | 64260 | 226666 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 201 Buchanan St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6004707.88321 | 2109244.5049400004 | 37.771849706222504 | -122.42710466345899 | (37.7718497062225, -122.427104663459) | |||
| 65316 | 65316 | 191478 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 33 South Park | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6014500.76851 | 2112629.04154 | 37.781691790478796 | -122.39346703317499 | (37.7816917904788, -122.393467033175) | |||
| 67542 | 67542 | 200695 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1603 Newcomb Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6015131.4073 | 2095732.6408 | 37.735332917815704 | -122.39010456562599 | (37.7353329178157, -122.390104565626) | |||
| 67836 | 67836 | 207948 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2300 09th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5992690.99199 | 2100498.58562 | 37.7471488342554 | -122.468035281115 | (37.7471488342554, -122.468035281115) | |||
| 68485 | 68485 | 120482 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2201 Lake St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 1ft | 5988588.087169999 | 2114640.4078900004 | 37.7857406059941 | -122.483259085533 | (37.7857406059941, -122.483259085533) | |||
| 69900 | 69900 | 141422 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 550 IVY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004543.5906 | 2111042.8919 | 37.7767783457628 | -122.42780112527001 | (37.7767783457628, -122.42780112527) | |||
| 70640 | 70640 | 191448 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1375 Fairfax Ave | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6016804.06254 | 2097268.13995 | 37.7396417192015 | -122.384428434726 | (37.7396417192015, -122.384428434726) | |||
| 71249 | 71249 | 227183 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 833 Ashbury St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5999115.77081 | 2107425.5617299997 | 37.7665375350105 | -122.446317222982 | (37.7665375350105, -122.446317222982) | |||
| 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) | |||
| 74148 | 74148 | 227250 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 140 Park St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6005794.59689 | 2096357.13637 | 37.7365253704536 | -122.422429779736 | (37.7365253704536, -122.422429779736) | |||
| 76192 | 76192 | 191481 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 526 05th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6012554.15249 | 2111142.6647900003 | 37.777502192597495 | -122.40009702957799 | (37.7775021925975, -122.400097029578) | |||
| 78963 | 78963 | 12206 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1365X La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016707.244956 | 2094751.5031778 | 37.7327261850679 | -122.38458793904199 | (37.7327261850679, -122.384587939042) | |||
| 79769 | 79769 | 113436 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 198x HIGHLAND AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 4x4 | 6006173.0 | 2096415.0 | 37.73670559026029 | -122.421125584355 | (37.7367055902603, -122.421125584355) | ||||
| 80636 | 80636 | 33769 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 37819 | 6009092.65010174 | 2104478.80438725 | 37.759011167375796 | -122.41160061802 | (37.7590111673758, -122.41160061802) | ||||
| 80698 | 80698 | 12309 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 949 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004806.2528800005 | 2112097.03189 | 37.7796876103034 | -122.426967593325 | (37.7796876103034, -122.426967593325) | |||
| 80877 | 80877 | 25291 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 136 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000743.1124599995 | 2091772.81119 | 37.7236516133979 | -122.439566330441 | (37.7236516133979, -122.439566330441) | |||
| 82008 | 82008 | 105875 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2X 27th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006029.156359999 | 2100240.43464 | 37.7472012619439 | -122.421894571047 | (37.7472012619439, -122.421894571047) | ||||
| 82162 | 82162 | 20277 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2291 Stockton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X2 | 6009755.789969999 | 2121736.88906 | 37.8064349417299 | -122.410525825802 | (37.8064349417299, -122.410525825802) | |||
| 82533 | 82533 | 42985 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2X Yale St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/16/2000 12:00:00 AM | 12 | 9x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.41922408324301 | (37.7290063985797, -122.419224083243) |
| 82832 | 82832 | 6003 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1680 Eddy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52927 | 6002410.467190799 | 2112668.0181364 | 37.7811196348904 | -122.43529649933501 | (37.7811196348904, -122.435296499335) | |
| 84373 | 84373 | 12120 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1325X La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016848.207852599 | 2094661.9057693002 | 37.732487962838604 | -122.38409435335 | (37.7324879628386, -122.38409435335) |
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");