Data source: data.sfgov.org
This data as json, CSV (advanced)
qCareAssistant ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4669 | 4669 | 253646 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1200x La Salle Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 11/09/1992 12:00:00 AM | 3x3 | 6017461.0 | 2094327.0 | 37.731602238049504 | -122.381952476407 | (37.7316022380495, -122.381952476407) | ||
4684 | 4684 | 253645 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1200x La Salle Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 03/11/2006 12:00:00 AM | 3x3 | 6017461.0 | 2094327.0 | 37.731602238049504 | -122.381952476407 | (37.7316022380495, -122.381952476407) | ||
58085 | 58085 | 197219 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 351 Cargo Way | 20 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6017546.94281 | 2098457.41264 | 37.7429482736446 | -122.38194254943599 | (37.7429482736446, -122.381942549436) | |||
107488 | 107488 | 28709 | DPW Maintained 3 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 316 | 1200X Evans Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6017521.99801 | 2097204.46801 | 37.7395065622406 | -122.381941669129 | (37.7395065622406, -122.381941669129) | |||
9796 | 9796 | 11975 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2016 02:52:00 PM | 3 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
84775 | 84775 | 11984 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
86885 | 86885 | 11999 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1200X La Salle Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/09/1992 12:00:00 AM | 12 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
87797 | 87797 | 11991 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1200X La Salle Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/09/1992 12:00:00 AM | 12 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
94343 | 94343 | 11996 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
103682 | 103682 | 11982 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
105152 | 105152 | 11980 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 8 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
105266 | 105266 | 11994 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 3 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
105361 | 105361 | 11992 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1200X La Salle Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/26/2016 12:00:00 AM | 18 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
106875 | 106875 | 11990 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
107681 | 107681 | 26534 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1200X La Salle Ave | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | |||
110214 | 110214 | 11989 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 8 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
111656 | 111656 | 11998 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
111813 | 111813 | 11986 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
117263 | 117263 | 11997 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 3 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
117964 | 117964 | 26533 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
124093 | 124093 | 11979 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1200X La Salle Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | |||
126789 | 126789 | 11993 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/08/2011 12:00:00 AM | 3 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
128523 | 128523 | 11995 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1200X La Salle Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/09/1992 12:00:00 AM | 18 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
138513 | 138513 | 11988 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
141449 | 141449 | 11981 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 6 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | |||
142345 | 142345 | 11985 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1200X La Salle Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/05/1992 12:00:00 AM | 12 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
143082 | 143082 | 11983 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 3 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
73875 | 73875 | 198295 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 8ft | 6017570.97457 | 2099580.31165 | 37.746032853833206 | -122.38193754289101 | (37.7460328538332, -122.381937542891) | |||
114452 | 114452 | 1411 | DPW Maintained 3 | Ginkgo biloba 'Saratoga' :: Ginkgo: Saratoga 418 | 86 Ardath Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/05/2007 12:00:00 AM | 3 | 3X4 | 6017484.2138277 | 2095260.4301389 | 37.7341665349061 | -122.38193712421601 | (37.7341665349061, -122.381937124216) | ||
59339 | 59339 | 197337 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 501 Amador St | 8 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6017571.01278 | 2099537.71438 | 37.7459158925037 | -122.381934448315 | (37.7459158925037, -122.381934448315) | |||
22344 | 22344 | 3639 | Private 5 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 75 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017551.66161 | 2098562.89956 | 37.743238180001995 | -122.381933568796 | (37.743238180002, -122.381933568796) | ||
56428 | 56428 | 191899 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1195 La Salle Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6017467.029630001 | 2094329.35639 | 37.7316090412127 | -122.38193179442301 | (37.7316090412127, -122.381931794423) | |||
150878 | 150878 | 195909 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Ardath Ct | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6017488.13797 | 2095238.32055 | 37.7341060430571 | -122.38192201971 | (37.7341060430571, -122.38192201971) | |||
158224 | 158224 | 190433 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 32 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6017527.816819999 | 2097194.77168 | 37.739480259397205 | -122.381920875742 | (37.7394802593972, -122.381920875742) | |||
185872 | 185872 | 191875 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1194 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6017468.81534 | 2094257.7246 | 37.731412453025996 | -122.38192064014 | (37.731412453026, -122.38192064014) | |||
42493 | 42493 | 191967 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1322 Hudson Ave | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6017483.19802 | 2094966.73925 | 37.733360061719395 | -122.381920214743 | (37.7333600617194, -122.381920214743) | |||
178483 | 178483 | 199332 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1240 Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 6017464.05542 | 2093991.8993400002 | 37.7306822862551 | -122.381918613076 | (37.7306822862551, -122.381918613076) | |||
49666 | 49666 | 191898 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1195 La Salle Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017470.90731 | 2094331.1004299999 | 37.7316140441423 | -122.381918509648 | (37.7316140441423, -122.381918509648) | |||
16655 | 16655 | 6515 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 15 | 6017527.69247 | 2097139.8588 | 37.7393294727638 | -122.38191748711999 | (37.7393294727638, -122.38191748712) | |||
112033 | 112033 | 10798 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1139X Hudson Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x4 | 6017482.97201 | 2094892.1900099998 | 37.7331553517533 | -122.381915812499 | (37.7331553517533, -122.381915812499) | |||
77777 | 77777 | 10729 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 99 Ardath Ct | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017489.511071401 | 2095183.8764266002 | 37.73395662609639 | -122.38191348672399 | (37.7339566260964, -122.381913486724) | ||
89441 | 89441 | 28536 | Permitted Site 1 | Ginkgo biloba 'Saratoga' :: Ginkgo: Saratoga 418 | 99 Ardath Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017489.511071401 | 2095183.8764266002 | 37.73395662609639 | -122.38191348672399 | (37.7339566260964, -122.381913486724) | ||
89910 | 89910 | 10726 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Ardath Ct | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X4 | 6017489.511071401 | 2095183.8764266002 | 37.73395662609639 | -122.38191348672399 | (37.7339566260964, -122.381913486724) | |||
103223 | 103223 | 10725 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Ardath Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X4 | 6017489.511071401 | 2095183.8764266002 | 37.73395662609639 | -122.38191348672399 | (37.7339566260964, -122.381913486724) | |||
141664 | 141664 | 10724 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Ardath Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X4 | 6017489.511071401 | 2095183.8764266002 | 37.73395662609639 | -122.38191348672399 | (37.7339566260964, -122.381913486724) | |||
145219 | 145219 | 10727 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Ardath Ct | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2004 12:00:00 AM | 12 | 3X4 | 6017489.511071401 | 2095183.8764266002 | 37.73395662609639 | -122.38191348672399 | (37.7339566260964, -122.381913486724) | ||
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) | ||
9836 | 9836 | 6755 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1215 Fairfax Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/03/2017 06:41:00 AM | 3 | 3x3 | 6017521.099066501 | 2096743.3718321999 | 37.7382404347673 | -122.381912713319 | (37.7382404347673, -122.381912713319) | ||
19468 | 19468 | 6756 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1215 Fairfax Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | Permit Number 769095 | 6017521.099066501 | 2096743.3718321999 | 37.7382404347673 | -122.381912713319 | (37.7382404347673, -122.381912713319) | ||
82774 | 82774 | 6753 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1215 Fairfax Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6017521.099066501 | 2096743.3718321999 | 37.7382404347673 | -122.381912713319 | (37.7382404347673, -122.381912713319) | |||
1173 | 1173 | 190143 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1200 Fairfax Ave | 7 | : 4 | Tree 1 | DPW 2 | 03/18/2017 10:47:00 AM | 3 | Width 4ft | 6017523.521480001 | 2096815.65975 | 37.738439056714704 | -122.381909364434 | (37.7384390567147, -122.381909364434) | ||
185583 | 185583 | 191876 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1194 La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6017474.3783599995 | 2094263.6054599998 | 37.7314289079177 | -122.381901816439 | (37.7314289079177, -122.381901816439) | |||
148904 | 148904 | 192684 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Westbrook Ct | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017502.05989 | 2095577.15005 | 37.7350371705351 | -122.38189744661999 | (37.7350371705351, -122.38189744662) | |||
158343 | 158343 | 191594 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 351 Cargo Way | 21 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6017560.1826599995 | 2098446.61736 | 37.7429193631329 | -122.38189601849899 | (37.7429193631329, -122.381896018499) | |||
170411 | 170411 | 195908 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Ardath Ct | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017495.96555 | 2095243.39437 | 37.734120407024704 | -122.38189530983699 | (37.7341204070247, -122.381895309837) | |||
134280 | 134280 | 193980 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 600 Keith St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6017523.18435 | 2096506.10562 | 37.737589064277394 | -122.38188900468799 | (37.7375890642774, -122.381889004688) | |||
100268 | 100268 | 6474 | DPW Maintained 3 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 316 | 1200X Evans Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2004 12:00:00 AM | 3 | 3X3 | 6017537.50401 | 2097191.3470099997 | 37.7394713908932 | -122.38188714318599 | (37.7394713908932, -122.381887143186) | ||
47124 | 47124 | 193979 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 600 Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6017524.43136 | 2096521.3698 | 37.7376310455329 | -122.38188575454599 | (37.7376310455329, -122.381885754546) | |||
178364 | 178364 | 198224 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1195 La Salle Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017481.225819999 | 2094316.49879 | 37.7315745207288 | -122.381881820907 | (37.7315745207288, -122.381881820907) | |||
22327 | 22327 | 3638 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 74 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017567.18226 | 2098548.9302 | 37.7432006800566 | -122.381878930467 | (37.7432006800566, -122.381878930467) | |||
146955 | 146955 | 197338 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 501 Amador St | 9 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6017587.31479 | 2099538.4559 | 37.745918828809295 | -122.381878129198 | (37.7459188288093, -122.381878129198) | |||
161604 | 161604 | 191877 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1194 La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 6017481.20119 | 2094246.6317599998 | 37.7313826782496 | -122.38187704821199 | (37.7313826782496, -122.381877048212) | |||
181258 | 181258 | 190432 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 31 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6017540.84506 | 2097183.62792 | 37.739450380318395 | -122.38187505441499 | (37.7394503803184, -122.381875054415) | |||
59599 | 59599 | 191999 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1301 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 3ft | 6017476.30115 | 2093950.5505099997 | 37.7305694267286 | -122.381873402332 | (37.7305694267286, -122.381873402332) | |||
169425 | 169425 | 191897 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1195 La Salle Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6017484.19267 | 2094318.4432599999 | 37.731580023696395 | -122.38187169902099 | (37.7315800236964, -122.381871699021) | |||
18380 | 18380 | 4905 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 94 Ardath Ct | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X4 | 6017502.5740617 | 2095232.3549831002 | 37.73409045999 | -122.381871694314 | (37.73409045999, -122.381871694314) | |||
20846 | 20846 | 4906 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 94 Ardath Ct | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2004 12:00:00 AM | 3 | 3X4 | 6017502.5740617 | 2095232.3549831002 | 37.73409045999 | -122.381871694314 | (37.73409045999, -122.381871694314) | ||
81978 | 81978 | 4904 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 94 Ardath Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6017502.5740617 | 2095232.3549831002 | 37.73409045999 | -122.381871694314 | (37.73409045999, -122.381871694314) | |||
84659 | 84659 | 4908 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 94 Ardath Ct | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6017502.5740617 | 2095232.3549831002 | 37.73409045999 | -122.381871694314 | (37.73409045999, -122.381871694314) | |||
90277 | 90277 | 4907 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 94 Ardath Ct | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/03/1997 12:00:00 AM | 6 | 3X4 | 6017502.5740617 | 2095232.3549831002 | 37.73409045999 | -122.381871694314 | (37.73409045999, -122.381871694314) | ||
106518 | 106518 | 4910 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 94 Ardath Ct | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6017502.5740617 | 2095232.3549831002 | 37.73409045999 | -122.381871694314 | (37.73409045999, -122.381871694314) | |||
114057 | 114057 | 4903 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 94 Ardath Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X4 | 6017502.5740617 | 2095232.3549831002 | 37.73409045999 | -122.381871694314 | (37.73409045999, -122.381871694314) | |||
127049 | 127049 | 4909 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 94 Ardath Ct | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X4 | 6017502.5740617 | 2095232.3549831002 | 37.73409045999 | -122.381871694314 | (37.73409045999, -122.381871694314) | |||
128724 | 128724 | 4902 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 94 Ardath Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017502.5740617 | 2095232.3549831002 | 37.73409045999 | -122.381871694314 | (37.73409045999, -122.381871694314) | ||
14131 | 14131 | 85613 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1190 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017458.1534 | 2093022.4369 | 37.728020006278 | -122.38187161186 | (37.728020006278, -122.38187161186) | ||
183821 | 183821 | 189579 | Undocumented 2 | Corymbia maculata :: Spotted Gum 165 | 1 Whitfield Ct | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6017480.3384 | 2094118.23435 | 37.7310300765608 | -122.381871103661 | (37.7310300765608, -122.381871103661) | |||
47972 | 47972 | 191928 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1335 Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6017495.9605 | 2094884.0455599998 | 37.7331337059592 | -122.38187034104601 | (37.7331337059592, -122.381870341046) | |||
175272 | 175272 | 189578 | Undocumented 2 | Corymbia maculata :: Spotted Gum 165 | 1 Whitfield Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6017480.95894 | 2094099.62822 | 37.7309790220515 | -122.381867664661 | (37.7309790220515, -122.381867664661) | |||
57758 | 57758 | 198294 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 6017591.2197 | 2099581.33021 | 37.7460367685821 | -122.381867608025 | (37.7460367685821, -122.381867608025) | |||
31224 | 31224 | 60350 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1101 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1982 12:00:00 AM | 4 | Permit Number 19928 | 6017464.7861 | 2093286.0419 | 37.72874418038629 | -122.381867009636 | (37.7287441803863, -122.381867009636) | |
25389 | 25389 | 191966 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1322 Hudson Ave | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6017499.193519999 | 2094948.2745700001 | 37.7333102446675 | -122.381863629414 | (37.7333102446675, -122.381863629414) | |||
77931 | 77931 | 10799 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1139X Hudson Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3x4 | 6017498.59701 | 2094875.2630099999 | 37.733109736403705 | -122.381860615174 | (37.7331097364037, -122.381860615174) | |||
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) | |||
187784 | 187784 | 198223 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1195 La Salle Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017491.0802 | 2094306.0971900001 | 37.7315465041574 | -122.38184702883301 | (37.7315465041574, -122.381847028833) | |||
162951 | 162951 | 199331 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1240 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 6017484.78419 | 2093989.84089 | 37.73067777884471 | -122.38184680667801 | (37.7306777788447, -122.381846806678) | |||
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) | |||
152333 | 152333 | 188671 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200 Fairfax Ave | 6 | : 4 | Tree 1 | Private 1 | 25 | Width 4ft | 6017541.51277 | 2096801.60961 | 37.7384014713541 | -122.381846181672 | (37.7384014713541, -122.381846181672) | |||
4937 | 4937 | 203013 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 351 Cargo Way | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/07/1996 12:00:00 AM | 2 | Width 3ft | 6017575.06427 | 2098435.51559 | 37.742889701702794 | -122.381843789478 | (37.7428897017028, -122.381843789478) | ||
76897 | 76897 | 191929 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1335 Hudson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6017503.98969 | 2094875.4696099998 | 37.7331106014773 | -122.38184198541599 | (37.7331106014773, -122.381841985416) | |||
188153 | 188153 | 192706 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 599 Keith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017533.8610000005 | 2096311.71691 | 37.7370559012175 | -122.381838573416 | (37.7370559012175, -122.381838573416) | |||
79802 | 79802 | 28708 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X Evans Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017551.81801 | 2097178.22601 | 37.7394361536971 | -122.38183673875 | (37.7394361536971, -122.38183673875) | |||
66333 | 66333 | 191896 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1195 La Salle Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 6017494.95789 | 2094307.84123 | 37.731551507078 | -122.38183374402901 | (37.731551507078, -122.381833744029) | |||
32341 | 32341 | 198203 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1194 La Salle Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017493.49527 | 2094230.9747400002 | 37.7313403660485 | -122.38183345624901 | (37.7313403660485, -122.381833456249) | |||
74434 | 74434 | 198222 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1195 La Salle Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017496.04751 | 2094298.34465 | 37.7315254915072 | -122.38182931668301 | (37.7315254915072, -122.381829316683) | |||
22332 | 22332 | 3637 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 73 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017581.37685 | 2098535.7297 | 37.7431652179942 | -122.381828930869 | (37.7431652179942, -122.381828930869) | |||
128914 | 128914 | 10800 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1139X Hudson Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6017507.71201 | 2094860.9400099998 | 37.7330709116139 | -122.38182810599501 | (37.7330709116139, -122.381828105995) | |||
31582 | 31582 | 194547 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 590 Keith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6017544.15385 | 2096613.95658 | 37.737886359456205 | -122.381824001685 | (37.7378863594562, -122.381824001685) | |||
184366 | 184366 | 188061 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1241 Evans Ave | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6017553.88932 | 2097055.79305 | 37.739100091683895 | -122.381821063598 | (37.7391000916839, -122.381821063598) | |||
1127 | 1127 | 188687 | DPW Maintained 3 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 1300 Evans Ave | 30 | : 4 | Tree 1 | DPW 2 | 03/18/2017 12:53:00 PM | 3 | Width 4ft | 6017556.40659 | 2097171.27575 | 37.7394173230594 | -122.381820390005 | (37.7394173230594, -122.381820390005) | ||
187525 | 187525 | 189580 | Undocumented 2 | Corymbia maculata :: Spotted Gum 165 | 1 Whitfield Ct | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 4ft | 6017495.382230001 | 2094096.8145700002 | 37.7309720927908 | -122.381817604795 | (37.7309720927908, -122.381817604795) |
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");