Data source: data.sfgov.org
This data as json, CSV (advanced)
qSiteInfo ✖
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20442 | 20442 | 19325 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 212 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X4 | 5993418.3820400005 | 2089852.67557 | 37.717959779598 | -122.464747082736 | (37.717959779598, -122.464747082736) | |||
| 20535 | 20535 | 10072 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 573 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005609.84736 | 2105668.09746 | 37.7620807071743 | -122.423730368485 | (37.7620807071743, -122.423730368485) | |||
| 20844 | 20844 | 59583 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 4071 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/07/1981 12:00:00 AM | Permit Number 18981 | 6002727.56027236 | 2101791.13153415 | 37.7512723603586 | -122.433422018052 | (37.7512723603586, -122.433422018052) | ||
| 20855 | 20855 | 17135 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2033 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5997261.7134 | 2109120.9259 | 37.771086505654104 | -122.45285242516701 | (37.7710865056541, -122.452852425167) | |||
| 21367 | 21367 | 10196 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1200X Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6005751.90575 | 2101904.66457 | 37.7517552157318 | -122.422971548421 | (37.7517552157318, -122.422971548421) | |||
| 21508 | 21508 | 16954 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 660 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003830.0479 | 2110098.0565 | 37.7741436701635 | -122.430202060124 | (37.7741436701635, -122.430202060124) | |||
| 21740 | 21740 | 26336 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2564 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5997739.3987300005 | 2089429.54745 | 37.7170461430363 | -122.449780813452 | (37.7170461430363, -122.449780813452) | |||
| 21805 | 21805 | 10058 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 451 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x5 | 6005573.3175800005 | 2106314.3851 | 37.763853198087 | -122.4239026696 | (37.763853198087, -122.4239026696) | |||
| 21820 | 21820 | 10021 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 274 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | 3x4 | 6005443.44254 | 2107417.66285 | 37.7668752034469 | -122.424430347706 | (37.7668752034469, -122.424430347706) | |||
| 22091 | 22091 | 10162 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1013 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2x2 | 6005758.27618 | 2103002.2349099996 | 37.7547692495131 | -122.42302752222099 | (37.7547692495131, -122.423027522221) | |||
| 22133 | 22133 | 10187 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1135 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005790.8424 | 2102360.27695 | 37.7530084192058 | -122.422869277503 | (37.7530084192058, -122.422869277503) | |||
| 22177 | 22177 | 10214 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1335 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X3 | 6005859.10485 | 2101158.22325 | 37.7497117078336 | -122.422547803155 | (37.7497117078336, -122.422547803155) | |||
| 22383 | 22383 | 1653 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 200 Austin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6006219.57926 | 2115439.98405 | 37.788946349830105 | -122.42231585899401 | (37.7889463498301, -122.422315858994) | |||
| 23037 | 23037 | 25706 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 582 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6012130.73474 | 2110269.98363 | 37.7750823930813 | -122.401500433298 | (37.7750823930813, -122.401500433298) | |||
| 23120 | 23120 | 12201 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1485 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 3X3 | 6016149.0568 | 2095651.2946 | 37.7351659473192 | -122.38658047187599 | (37.7351659473192, -122.386580471876) | |||
| 23202 | 23202 | 77640 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 13 | 0 | 6006980.92428 | 2093193.1114700001 | 37.7279045016753 | -122.418103887786 | (37.7279045016753, -122.418103887786) | |
| 23365 | 23365 | 5074 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 5593 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/04/1992 12:00:00 AM | 3 | 6001579.88731 | 2097086.51396 | 37.73828941133 | -122.43705400175699 | (37.73828941133, -122.437054001757) | |||
| 23653 | 23653 | 227371 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1156 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008041.47882 | 2101204.6216 | 37.749961984661205 | -122.415004329382 | (37.7499619846612, -122.415004329382) | |||
| 23737 | 23737 | 129604 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1675 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6004955.93946 | 2118458.8169 | 37.7971639410302 | -122.426902971605 | (37.7971639410302, -122.426902971605) | |||
| 24017 | 24017 | 65613 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 743 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/1990 12:00:00 AM | 18 | Permit Number 28520 | 6001843.34769 | 2089618.0611400001 | 37.71779771097221 | -122.43560893330299 | (37.7177977109722, -122.435608933303) | |
| 24070 | 24070 | 60036 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 147 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | 12 | Permit Number 19525 | 6014255.98068 | 2112398.36524 | 37.781044802010705 | -122.394297734267 | (37.7810448020107, -122.394297734267) | |
| 24084 | 24084 | 217648 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 377 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5992011.4385 | 2096784.9217 | 37.7369127922508 | -122.470114728443 | (37.7369127922508, -122.470114728443) | |||
| 24146 | 24146 | 42768 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 837 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | 5 | Permit Number 42744 | 6003836.146000001 | 2110735.9706 | 37.7758955707266 | -122.430226485287 | (37.7758955707266, -122.430226485287) | ||
| 24191 | 24191 | 227330 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 221 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 8ft | 5998955.44589 | 2106862.7801900003 | 37.764983120694296 | -122.44683125657801 | (37.7649831206943, -122.446831256578) | |||
| 24341 | 24341 | 227284 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 312 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000612.642030001 | 2101912.76536 | 37.751486122399996 | -122.44074434639799 | (37.7514861224, -122.440744346398) | |||
| 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) | |||
| 24752 | 24752 | 227245 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 102 Red Rock Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6000206.60136 | 2100087.0389900003 | 37.746449985492504 | -122.442017446473 | (37.7464499854925, -122.442017446473) | |||
| 24839 | 24839 | 129593 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1730 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6005825.1894 | 2117248.62262 | 37.7938901641474 | -122.42380905195101 | (37.7938901641474, -122.423809051951) | |||
| 25071 | 25071 | 129632 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1224 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6007668.525219999 | 2118543.16915 | 37.7975485540748 | -122.417522708125 | (37.7975485540748, -122.417522708125) | |||
| 25475 | 25475 | 129560 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3400 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000343.81245 | 2119969.12315 | 37.8010489798926 | -122.442970544376 | (37.8010489798926, -122.442970544376) | |||
| 25515 | 25515 | 143042 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 443 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6010246.7521 | 2120590.0026 | 37.8033133880365 | -122.408745792286 | (37.8033133880365, -122.408745792286) | |||
| 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) | |||
| 25726 | 25726 | 226745 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 45 Mullen Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009514.45698 | 2099883.6053299997 | 37.7464174282201 | -122.409817438224 | (37.7464174282201, -122.409817438224) | |||
| 25947 | 25947 | 62018 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1611 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/10/1985 12:00:00 AM | 7 | Permit Number 22090 | 5999587.6363 | 2114469.4142 | 37.785905091635605 | -122.44519160183201 | (37.7859050916356, -122.445191601832) | ||
| 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) | |||
| 26110 | 26110 | 64561 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1542 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | 10 | Permit Number 25452 | 6000444.413 | 2110313.5657 | 37.774543061584794 | -122.441929006028 | (37.7745430615848, -122.441929006028) | |
| 26325 | 26325 | 227397 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 53 Milton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003755.199990001 | 2095371.2273400002 | 37.7337030307607 | -122.429410555763 | (37.7337030307607, -122.429410555763) | |||
| 26516 | 26516 | 64472 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1970 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/1988 12:00:00 AM | 5 | Permit Number 25343 | 5999749.3718 | 2111255.5704 | 37.777089935824996 | -122.44440099324899 | (37.777089935825, -122.444400993249) | ||
| 26544 | 26544 | 101281 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2049 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 5989322.9543 | 2106470.5284 | 37.763351115778796 | -122.48011854571301 | (37.7633511157788, -122.480118545713) | |||
| 26619 | 26619 | 246399 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 612 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5998518.6054 | 2108535.307 | 37.7695504903102 | -122.44846263084601 | (37.7695504903102, -122.448462630846) | |||
| 26705 | 26705 | 59243 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 844 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/1980 12:00:00 AM | 13 | Permit Number 18574 | 5992945.970290001 | 2110731.04138 | 37.7752591962743 | -122.467897727976 | (37.7752591962743, -122.467897727976) | ||
| 26750 | 26750 | 226747 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004809.8918 | 2108865.505 | 37.7708148320814 | -122.426724814115 | (37.7708148320814, -122.426724814115) | |||
| 26759 | 26759 | 227390 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3014 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6009188.67033 | 2104531.54133 | 37.759161356731504 | -122.411272258916 | (37.7591613567315, -122.411272258916) | |||
| 26846 | 26846 | 60031 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 136 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | 16 | Permit Number 19519 | 6014189.65421 | 2112531.72054 | 37.7814072782548 | -122.394536533027 | (37.7814072782548, -122.394536533027) | |
| 26870 | 26870 | 137561 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1349 STEINER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6002733.3139 | 2112973.925 | 37.7819779069783 | -122.4342014876 | (37.7819779069783, -122.4342014876) | |||
| 26884 | 26884 | 54531 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 855 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1972 12:00:00 AM | 12 | Permit Number 10326 | 5984466.31691 | 2110015.99536 | 37.7728025745037 | -122.497177542996 | (37.7728025745037, -122.497177542996) | ||
| 26969 | 26969 | 67564 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1015 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/15/2014 12:00:00 AM | 15 | Permit Number 31116 | 6011653.24401 | 2103633.28884 | 37.756832869857995 | -122.402685364734 | (37.756832869858, -122.402685364734) | |
| 27045 | 27045 | 72016 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 112 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | 10 | 6014238.82874 | 2112579.70736 | 37.7815417727734 | -122.394369772655 | (37.7815417727734, -122.394369772655) | ||
| 27190 | 27190 | 60024 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 181 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | 14 | Permit Number 19511 | 6014126.74175 | 2112333.046 | 37.7808582655241 | -122.394740263669 | (37.7808582655241, -122.394740263669) | |
| 27199 | 27199 | 207909 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 222 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992450.69932 | 2097715.88503 | 37.7394943670795 | -122.46866374176099 | (37.7394943670795, -122.468663741761) | |||
| 27794 | 27794 | 129568 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 245 Locust St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5997566.17923 | 2115533.25123 | 37.7887105152246 | -122.452262040258 | (37.7887105152246, -122.452262040258) | |||
| 27834 | 27834 | 122959 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 156 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5993068.55118 | 2114432.33175 | 37.7854290124604 | -122.467742945555 | (37.7854290124604, -122.467742945555) | |||
| 27898 | 27898 | 207887 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1324 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995205.506709999 | 2106558.40833 | 37.7639324562531 | -122.45977922053899 | (37.7639324562531, -122.459779220539) | |||
| 28091 | 28091 | 217638 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 329 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5992227.5338 | 2097006.9607 | 37.737534945647795 | -122.46938375516001 | (37.7375349456478, -122.46938375516) | |||
| 28221 | 28221 | 227218 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1167 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008083.814259999 | 2101130.59105 | 37.7497610923125 | -122.41485269201799 | (37.7497610923125, -122.414852692018) | |||
| 28227 | 28227 | 129629 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2705 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006528.35996 | 2120536.34413 | 37.8029570876493 | -122.42160962679199 | (37.8029570876493, -122.421609626792) | |||
| 28272 | 28272 | 123183 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 701 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5993156.76924 | 2110656.1074599996 | 37.7750656182934 | -122.467163083043 | (37.7750656182934, -122.467163083043) | |||
| 28407 | 28407 | 9343 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 209 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2X2 | 6000760.262283401 | 2098514.0876657 | 37.742162570261 | -122.439990187576 | (37.742162570261, -122.439990187576) | |||
| 28583 | 28583 | 226733 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 116 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005438.05515 | 2104031.47118 | 37.7575772171191 | -122.424208130602 | (37.7575772171191, -122.424208130602) | |||
| 28719 | 28719 | 65929 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 35 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | 8 | Permit Number 28948 | 5995849.4697199995 | 2114245.46982 | 37.7850761197315 | -122.45810832997 | (37.7850761197315, -122.45810832997) | |
| 28722 | 28722 | 227417 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 234 Eureka St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001420.423169999 | 2104418.6773099997 | 37.7584127214746 | -122.438130438088 | (37.7584127214746, -122.438130438088) | |||
| 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) | |||
| 29104 | 29104 | 207851 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 266 Sadowa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994330.673359999 | 2087784.2357400001 | 37.712332889716 | -122.46144384316099 | (37.712332889716, -122.461443843161) | |||
| 29111 | 29111 | 207888 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1322 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5995205.814230001 | 2106573.0911 | 37.763972789025296 | -122.459779220536 | (37.7639727890253, -122.459779220536) | |||
| 29117 | 29117 | 227498 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3068 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6002861.4489400005 | 2095908.97167 | 37.7351289121778 | -122.43253891044901 | (37.7351289121778, -122.432538910449) | |||
| 29173 | 29173 | 227316 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4336 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6000997.33925 | 2102323.34435 | 37.752635374121596 | -122.43944344826001 | (37.7526353741216, -122.43944344826) | |||
| 29444 | 29444 | 227467 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 43 Uranus Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5999304.1130800005 | 2105493.67356 | 37.761243807982396 | -122.445526851088 | (37.7612438079824, -122.445526851088) | |||
| 29511 | 29511 | 129570 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1895 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003964.93284 | 2118665.52225 | 37.797675416929394 | -122.43034685523001 | (37.7976754169294, -122.43034685523) | |||
| 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) | |||
| 29782 | 29782 | 207811 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 454 Lansdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5996252.9911400005 | 2096374.29594 | 37.736029609286796 | -122.455420217376 | (37.7360296092868, -122.455420217376) | |||
| 30055 | 30055 | 245885 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 224 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6001296.3519 | 2109554.1199 | 37.7725063234405 | -122.43892755355301 | (37.7725063234405, -122.438927553553) | |||
| 30079 | 30079 | 65628 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1330 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1990 12:00:00 AM | 12 | Permit Number 28536 | 5999777.227000001 | 2113475.6396 | 37.783187264222796 | -122.44446422560301 | (37.7831872642228, -122.444464225603) | |
| 30415 | 30415 | 141897 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 959 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6004798.1051 | 2112091.5685 | 37.7796721484645 | -122.426995390821 | (37.7796721484645, -122.426995390821) | |||
| 30501 | 30501 | 227200 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 85 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008254.46686 | 2099579.16062 | 37.745510798281295 | -122.414152818899 | (37.7455107982813, -122.414152818899) | |||
| 30710 | 30710 | 143048 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 471 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6010123.4556 | 2120570.2538 | 37.803252256148504 | -122.409171071628 | (37.8032522561485, -122.409171071628) | |||
| 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) | ||||
| 31506 | 31506 | 227363 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 744 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009063.4142 | 2104741.5079099997 | 37.759730851518896 | -122.41172029216601 | (37.7597308515189, -122.411720292166) | |||
| 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) | |||
| 31685 | 31685 | 247273 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 512 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998949.6445 | 2108941.8512 | 37.7706913928445 | -122.447000948717 | (37.7706913928445, -122.447000948717) | |||
| 31722 | 31722 | 207884 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1361 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5995160.66528 | 2106393.8819 | 37.7634781304238 | -122.459922393521 | (37.7634781304238, -122.459922393521) | |||
| 31748 | 31748 | 227437 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 332 Eureka St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6001454.7523 | 2103830.24347 | 37.7567989771016 | -122.43796956466001 | (37.7567989771016, -122.43796956466) | |||
| 31753 | 31753 | 227294 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4271 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 6002167.60726 | 2100591.89934 | 37.7479477685938 | -122.435272624637 | (37.7479477685938, -122.435272624637) | |||
| 31827 | 31827 | 201238 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 832 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6012024.4623 | 2112592.9398 | 37.7814547646501 | -122.40203139526399 | (37.7814547646501, -122.402031395264) | |||
| 31990 | 31990 | 59227 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 801 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/1980 12:00:00 AM | 8 | Permit Number 18548 | 5993132.18227 | 2110683.6114 | 37.7751397174352 | -122.467250134298 | (37.7751397174352, -122.467250134298) | ||
| 32183 | 32183 | 36981 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 251 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 7 | Permit Number 39606 | 5993043.99125 | 2113791.1250299998 | 37.783667016157295 | -122.46778126318199 | (37.7836670161573, -122.467781263182) | |
| 32186 | 32186 | 73447 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1045 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1994 12:00:00 AM | 5 | 6007557.7828 | 2115066.68598 | 37.787996759296796 | -122.417659373585 | (37.7879967592968, -122.417659373585) | ||
| 32208 | 32208 | 207938 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 168 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5994463.39444 | 2096391.8205099998 | 37.735974878342205 | -122.461608798622 | (37.7359748783422, -122.461608798622) | |||
| 32293 | 32293 | 207815 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 225 Gennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5997426.46465 | 2094243.22962 | 37.7302454747445 | -122.451209426987 | (37.7302454747445, -122.451209426987) | |||
| 32388 | 32388 | 129645 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 745 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6008221.44348 | 2120654.50156 | 37.803376840820704 | -122.415759034171 | (37.8033768408207, -122.415759034171) | |||
| 32446 | 32446 | 227232 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3591 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006358.3896 | 2104332.17795 | 37.7584548106588 | -122.421046586437 | (37.7584548106588, -122.421046586437) | |||
| 32505 | 32505 | 177101 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 130 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6000792.03134 | 2091751.28395 | 37.7235952885821 | -122.439395684376 | (37.7235952885821, -122.439395684376) | |||
| 32562 | 32562 | 183926 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1595 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5988583.1369 | 2101004.688 | 37.7483003735732 | -122.482276819356 | (37.7483003735732, -122.482276819356) | |||
| 32632 | 32632 | 226749 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 188 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6004787.62152 | 2108995.1973200003 | 37.7711696766722 | -122.42681108517799 | (37.7711696766722, -122.426811085178) | |||
| 33153 | 33153 | 227463 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 238 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 5999836.92244 | 2105557.8617 | 37.76145045600771 | -122.443688706966 | (37.7614504560077, -122.443688706966) | |||
| 33362 | 33362 | 55257 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 810 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/1972 12:00:00 AM | 5 | Permit Number 11179 | 5988221.44369 | 2110421.88962 | 37.7741363990758 | -122.48421806494801 | (37.7741363990758, -122.484218064948) | ||
| 33651 | 33651 | 227430 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 310 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001107.72695 | 2104564.11712 | 37.7587942750543 | -122.439222302274 | (37.7587942750543, -122.439222302274) | |||
| 33791 | 33791 | 227214 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 775 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6009111.88491 | 2104588.76957 | 37.7593141857234 | -122.411541863967 | (37.7593141857234, -122.411541863967) | |||
| 33941 | 33941 | 40560 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 458 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1999 12:00:00 AM | 7 | Permit Number 41604 | 5990324.44539 | 2112242.31069 | 37.779256995112 | -122.47707654197399 | (37.779256995112, -122.477076541974) | |
| 33985 | 33985 | 227246 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 104 Red Rock Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6000168.90266 | 2100069.23534 | 37.7463989525502 | -122.442146526165 | (37.7463989525502, -122.442146526165) |
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");