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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 118724 | 118724 | 194 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 419X Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X3 | 6005567.0759942 | 2106542.8569591 | 37.7644801752938 | -122.423940505082 | (37.7644801752938, -122.423940505082) | |||
| 83389 | 83389 | 422 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 685X Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005653.198434 | 2104994.6037312 | 37.7602338989595 | -122.423532549649 | (37.7602338989595, -122.423532549649) | |||
| 11402 | 11402 | 1130 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2554 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 5998598.100380001 | 2088668.31183 | 37.7150050570134 | -122.446757963627 | (37.7150050570134, -122.446757963627) | |||
| 11054 | 11054 | 1139 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2627 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 1X1 | 5998352.02606 | 2088442.52333 | 37.7143710331717 | -122.447592253902 | (37.7143710331717, -122.447592253902) | |||
| 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) | |||
| 22502 | 22502 | 1654 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 200 Austin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1992 12:00:00 AM | 3 | 3X3 | 6006190.88992 | 2115436.6109700003 | 37.788935469840105 | -122.42241488063699 | (37.7889354698401, -122.422414880637) | ||
| 16400 | 16400 | 1687 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 15 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017775.00772 | 2093610.25153 | 37.729651522897 | -122.38081707126301 | (37.729651522897, -122.380817071263) | ||
| 123069 | 123069 | 1691 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 23 Baldwin Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017695.7876646 | 2093605.1145141998 | 37.7296330451049 | -122.381090589205 | (37.7296330451049, -122.381090589205) | |||
| 85072 | 85072 | 1696 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 34 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017739.602575701 | 2093657.002741 | 37.72977793847971 | -122.380942720777 | (37.7297779384797, -122.380942720777) | |||
| 141287 | 141287 | 1702 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 47 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017785.2431167 | 2093593.9655411 | 37.7296073696477 | -122.380780554369 | (37.7296073696477, -122.380780554369) | |||
| 18155 | 18155 | 1705 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 70 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017900.557664401 | 2093604.0676713001 | 37.729641471652 | -122.380382597634 | (37.729641471652, -122.380382597634) | |||
| 124120 | 124120 | 2170 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2299X FRANKLIN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005396.0 | 2117789.0 | 37.7953496659997 | -122.42533256183701 | (37.7953496659997, -122.425332561837) | |||
| 8692 | 8692 | 2693 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2107 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1991 12:00:00 AM | 6 | 3X3 | 6003334.0194 | 2114827.0332 | 37.7871001510547 | -122.432255708662 | (37.7871001510547, -122.432255708662) | ||
| 121009 | 121009 | 2694 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2111 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003424.2987912 | 2114891.8357248 | 37.787283200782 | -122.431947991092 | (37.787283200782, -122.431947991092) | |||
| 19050 | 19050 | 4227 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3984 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2003 12:00:00 AM | 5 | 3X3 | 6004005.18822 | 2100441.9925599997 | 37.7476403416378 | -122.428907662964 | (37.7476403416378, -122.428907662964) | ||
| 142461 | 142461 | 4606 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 300 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6010770.745019999 | 2118660.6682599997 | 37.7980452429337 | -122.40679643371 | (37.7980452429337, -122.40679643371) | |||
| 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) | |||
| 99318 | 99318 | 5483 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 700X Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 04/28/2008 12:00:00 AM | 6 | 6 | 6004966.5668947 | 2104283.6095193 | 37.7582428963987 | -122.425856676166 | (37.7582428963987, -122.425856676166) | ||
| 20212 | 20212 | 5507 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 800 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 2x2 | 6004984.13536 | 2103653.10654 | 37.756512676133 | -122.42575103988999 | (37.756512676133, -122.42575103989) | |||
| 82134 | 82134 | 6001 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1680 Eddy St | 1 | 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) | |
| 140445 | 140445 | 6002 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1680 Eddy St | 2 | 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) | |
| 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) | |
| 7964 | 7964 | 6057 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1905 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6001269.0972 | 2112453.6996 | 37.780466287428105 | -122.43922969539301 | (37.7804662874281, -122.439229695393) | |||
| 6879 | 6879 | 6058 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1905 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6001281.6188 | 2112455.0533 | 37.780470716869395 | -122.439186474434 | (37.7804707168694, -122.439186474434) | |||
| 104152 | 104152 | 6715 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1200X Fairfax Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | |||
| 23320 | 23320 | 6751 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1215 Fairfax Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/1992 12:00:00 AM | 7 | 6017537.38126 | 2096718.5380000002 | 37.738173145164104 | -122.38185469014499 | (37.7381731451641, -122.381854690145) | |||
| 15662 | 15662 | 6752 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1215 Fairfax Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3x3 | 6017539.76894 | 2096719.1679599998 | 37.738175006759 | -122.381846478456 | (37.738175006759, -122.381846478456) | |||
| 9486 | 9486 | 6754 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1215 Fairfax Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1992 12:00:00 AM | 8 | 3x3 | 6017521.099066501 | 2096743.3718321999 | 37.7382404347673 | -122.381912713319 | (37.7382404347673, -122.381912713319) | ||
| 15398 | 15398 | 6762 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1275 Fairfax Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/2009 12:00:00 AM | 3 | 3x3 | 6017299.98506 | 2096895.81009 | 37.7386467866108 | -122.38268782838999 | (37.7386467866108, -122.38268782839) | ||
| 78861 | 78861 | 6767 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1275 Fairfax Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/1992 12:00:00 AM | 12 | 3x3 | 6017284.4858800005 | 2096909.9197200001 | 37.738684672549205 | -122.38274239930401 | (37.7386846725492, -122.382742399304) | ||
| 102821 | 102821 | 7209 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1225X McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003292.04755 | 2111699.2584599997 | 37.7785096871687 | -122.43217746913601 | (37.7785096871687, -122.432177469136) | |||
| 138769 | 138769 | 7210 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1225X McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003292.04755 | 2111699.2584599997 | 37.7785096871687 | -122.43217746913601 | (37.7785096871687, -122.432177469136) | |||
| 108812 | 108812 | 7212 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1225X McAllister St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003292.04755 | 2111699.2584599997 | 37.7785096871687 | -122.43217746913601 | (37.7785096871687, -122.432177469136) | |||
| 7479 | 7479 | 7952 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1740 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005743.00192 | 2116111.2494799998 | 37.7907625828685 | -122.424012509171 | (37.7907625828685, -122.424012509171) | |||
| 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) | |||
| 7730 | 7730 | 7960 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1800 Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005701.62625 | 2116374.60015 | 37.7914833418188 | -122.42417440425 | (37.7914833418188, -122.42417440425) | |||
| 83706 | 83706 | 7963 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1840 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005718.277369999 | 2116441.98594 | 37.7916693064652 | -122.424121585933 | (37.7916693064652, -122.424121585933) | |||
| 7670 | 7670 | 7966 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1901 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005614.52229 | 2116667.02972 | 37.7922813615542 | -122.424496592638 | (37.7922813615542, -122.424496592638) | |||
| 6348 | 6348 | 7967 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1901 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005619.52925 | 2116640.16995 | 37.7922078941213 | -122.424477357045 | (37.7922078941213, -122.424477357045) | |||
| 6808 | 6808 | 7969 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1920 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005664.22303 | 2116673.38884 | 37.7923016286726 | -122.42432507933998 | (37.7923016286726, -122.42432507934) | |||
| 6170 | 6170 | 7970 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1930 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 6005659.59563 | 2116718.6943 | 37.792425764795205 | -122.42434431405701 | (37.7924257647952, -122.424344314057) | |||
| 6757 | 6757 | 7971 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1950 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 6005647.3062 | 2116796.9112400003 | 37.7926398349056 | -122.42439240168999 | (37.7926398349056, -122.42439240169) | |||
| 2283 | 2283 | 7972 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1950 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005640.29534 | 2116816.4309400003 | 37.7926930351995 | -122.424418048575 | (37.7926930351995, -122.424418048575) | |||
| 2886 | 2886 | 7974 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1955 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005597.935869999 | 2116784.08675 | 37.7926018340689 | -122.424562312409 | (37.7926018340689, -122.424562312409) | |||
| 2021 | 2021 | 7975 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2003 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005570.14471 | 2116971.5183099997 | 37.793114904479296 | -122.42467181028 | (37.7931149044793, -122.42467181028) | |||
| 6722 | 6722 | 7978 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2020 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6005621.04444 | 2116972.96262 | 37.793121744726896 | -122.424495796768 | (37.7931217447269, -122.424495796768) | |||
| 96817 | 96817 | 7985 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2111 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005519.50842 | 2117258.74677 | 37.7939007015449 | -122.42486745909201 | (37.7939007015449, -122.424867459092) | |||
| 4694 | 4694 | 7986 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2111 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005534.41759 | 2117282.00669 | 37.7939654095207 | -122.424817527421 | (37.7939654095207, -122.424817527421) | |||
| 94799 | 94799 | 7993 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2250 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005514.59005 | 2117689.16769 | 37.7950822509185 | -122.42491511428301 | (37.7950822509185, -122.424915114283) | |||
| 115817 | 115817 | 7994 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2250 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6005514.59005 | 2117689.16769 | 37.7950822509185 | -122.42491511428301 | (37.7950822509185, -122.424915114283) | |||
| 88966 | 88966 | 8120 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 850X Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6003699.00422 | 2111459.33104 | 37.777873970946295 | -122.43075252591801 | (37.7778739709463, -122.430752525918) | |||
| 107948 | 107948 | 8121 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 850X Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6003699.00422 | 2111459.33104 | 37.777873970946295 | -122.43075252591801 | (37.7778739709463, -122.430752525918) | |||
| 98684 | 98684 | 9317 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 99X Gold Mine Dr | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 2X2 | 6001391.6487444 | 2098856.3848919 | 37.743138360608704 | -122.437831565564 | (37.7431383606087, -122.437831565564) | ||
| 94044 | 94044 | 9319 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 99X Gold Mine Dr | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 2x2 | 6001391.6487444 | 2098856.3848919 | 37.743138360608704 | -122.437831565564 | (37.7431383606087, -122.437831565564) | |||
| 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) | |||
| 86417 | 86417 | 9946 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2145X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6007159.165551 | 2119559.7591564 | 37.8003111812757 | -122.41935738709299 | (37.8003111812757, -122.419357387093) | |||
| 82679 | 82679 | 9998 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 122 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2X2 | 6005390.2576582 | 2108319.0051408 | 37.7693470701553 | -122.424678431625 | (37.7693470701553, -122.424678431625) | |||
| 20132 | 20132 | 10004 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 150 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3X3 | 6005403.33839 | 2108127.1988 | 37.768821154693896 | -122.424619539876 | (37.7688211546939, -122.424619539876) | |||
| 19433 | 19433 | 10011 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 198 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 2X3 | 6005417.15338 | 2107897.14895 | 37.76819027309789 | -122.424555388522 | (37.7681902730979, -122.424555388522) | |||
| 19969 | 19969 | 10013 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 215 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x2 | 6005495.275 | 2107715.11687 | 37.7676948680391 | -122.42427222529899 | (37.7676948680391, -122.424272225299) | |||
| 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) | |||
| 19488 | 19488 | 10031 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 310 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 2x3 | 6005459.49344 | 2107143.4221799998 | 37.7661231103266 | -122.42435532265301 | (37.7661231103266, -122.424355322653) | |||
| 18862 | 18862 | 10055 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 432 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X2 | 6005503.26278 | 2106415.24362 | 37.7641261764966 | -122.424152141508 | (37.7641261764966, -122.424152141508) | |||
| 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) | |||
| 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) | |||
| 17678 | 17678 | 10075 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 595 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6005616.34075 | 2105560.18901 | 37.7617847825636 | -122.423700237591 | (37.7617847825636, -122.423700237591) | |||
| 18782 | 18782 | 10078 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 615 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6005625.0168 | 2105365.53505 | 37.761250798395295 | -122.42365639023599 | (37.7612507983953, -122.423656390236) | |||
| 18810 | 18810 | 10105 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 779 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2016 12:00:00 AM | 18 | 4x4 | 6005674.55908 | 2104459.44386 | 37.7587656810971 | -122.42342062756201 | (37.7587656810971, -122.423420627562) | ||
| 106702 | 106702 | 10129 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 892 Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6005646.9391641 | 2103763.6492254 | 37.7568536327232 | -122.42346668441999 | (37.7568536327232, -122.42346668442) | |||
| 17896 | 17896 | 10143 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 920 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005657.84848 | 2103570.5399700003 | 37.7563240154596 | -122.423415228047 | (37.7563240154596, -122.423415228047) | |||
| 286 | 286 | 10157 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 995 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005745.7610599995 | 2103227.37374 | 37.755386722241504 | -122.42308680461201 | (37.7553867222415, -122.423086804612) | |||
| 20274 | 20274 | 10158 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1001 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6005753.82676 | 2103093.98635 | 37.7550209265961 | -122.423049430612 | (37.7550209265961, -122.423049430612) | |||
| 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) | |||
| 99786 | 99786 | 10163 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1013 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2x2 | 6005764.7450429 | 2102960.7456767 | 37.7546556947331 | -122.423002202394 | (37.7546556947331, -122.423002202394) | |||
| 115192 | 115192 | 10179 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1090X Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | 3X3 | 6005708.480965099 | 2102624.2723741 | 37.7537286419918 | -122.42317286327801 | (37.7537286419918, -122.423172863278) | |||
| 98083 | 98083 | 10181 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1097X Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005777.346268901 | 2102574.3880576002 | 37.753595557271 | -122.422931166019 | (37.753595557271, -122.422931166019) | |||
| 123764 | 123764 | 10183 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1113 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X2 | 6005790.6047359 | 2102492.1542693 | 37.7533705104285 | -122.422879471267 | (37.7533705104285, -122.422879471267) | |||
| 19071 | 19071 | 10185 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1125 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005788.9112599995 | 2102417.59249 | 37.7531656854677 | -122.422880028901 | (37.7531656854677, -122.422880028901) | |||
| 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) | |||
| 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) | |||
| 20101 | 20101 | 10202 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1243 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005829.09689 | 2101725.42508 | 37.7512674207747 | -122.42269187452601 | (37.7512674207747, -122.422691874526) | |||
| 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) | |||
| 18162 | 18162 | 10221 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1370 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 65 | 3X3 | 6005802.11698 | 2100976.8322900003 | 37.7492104347131 | -122.42273198069599 | (37.7492104347131, -122.422731980696) | |||
| 17247 | 17247 | 10229 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1417 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005889.94053 | 2100616.0721299998 | 37.748224824522296 | -122.422402655257 | (37.7482248245223, -122.422402655257) | |||
| 17605 | 17605 | 10230 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1426 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 2x3 | 6005817.36142 | 2100645.21865 | 37.7483007596771 | -122.42265570290199 | (37.7483007596771, -122.422655702902) | |||
| 86193 | 86193 | 10706 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 969X Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2006 12:00:00 AM | 3 | 3X3 | 6005743.4978976 | 2103345.7544707 | 37.7557116405021 | -122.42310304530899 | (37.7557116405021, -122.423103045309) | ||
| 5980 | 5980 | 11435 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2100X Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6005584.47186 | 2117242.36199 | 37.7938593821703 | -122.42464151300501 | (37.7938593821703, -122.424641513005) | |||
| 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) | |||
| 117586 | 117586 | 11438 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2100X FRANKLIN ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005630.0 | 2117242.0 | 37.79386095938629 | -122.424483955414 | (37.7938609593863, -122.424483955414) | |||
| 47442 | 47442 | 11955 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1469 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6015772.6789286 | 2096311.6012512 | 37.7369581722856 | -122.387927819023 | (37.7369581722856, -122.387927819023) | |||
| 105819 | 105819 | 12118 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1325X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016848.207852599 | 2094661.9057693002 | 37.732487962838604 | -122.38409435335 | (37.7324879628386, -122.38409435335) | |||
| 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) | |||
| 129338 | 129338 | 12165 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1439X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.38587626093799 | (37.7340798748876, -122.385876260938) | |||
| 117602 | 117602 | 12166 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1439X La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.38587626093799 | (37.7340798748876, -122.385876260938) | |||
| 14202 | 14202 | 12169 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1425X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/16/1992 12:00:00 AM | 3 | 3X3 | 6016491.2755 | 2094964.9733 | 37.7333003856228 | -122.38534947643299 | (37.7333003856228, -122.385349476433) | ||
| 93142 | 93142 | 12170 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1421X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/1993 12:00:00 AM | 9 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.38587626093799 | (37.7340798748876, -122.385876260938) | ||
| 124246 | 124246 | 12171 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1421X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/1993 12:00:00 AM | 9 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.38587626093799 | (37.7340798748876, -122.385876260938) | ||
| 109337 | 109337 | 12172 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1419X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.38587626093799 | (37.7340798748876, -122.385876260938) | |||
| 15744 | 15744 | 12173 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1411X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1992 12:00:00 AM | 9 | 3X3 | 6016408.3895 | 2095102.4888 | 37.733673389774204 | -122.385645619675 | (37.7336733897742, -122.385645619675) | ||
| 16766 | 16766 | 12174 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1415X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 6016429.1110000005 | 2095062.9295 | 37.7335659143966 | -122.385571222674 | (37.7335659143966, -122.385571222674) |
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");