Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, qCaretaker, qCareAssistant, PlantDate, PlotSize, PermitNotes
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 187536 | 187536 | 209135 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Bosworth St | 21 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 6001010.142969999 | 2095737.8079 | 37.7345537777227 | -122.438927266197 | (37.7345537777227, -122.438927266197) | ||||
| 181686 | 181686 | 246870 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3090x Market St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 5999943.44665 | 2105326.58667 | 37.7608215070397 | -122.443303673043 | (37.7608215070397, -122.443303673043) | ||||
| 179926 | 179926 | 176358 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 300x Mansell St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | Width 0ft | 6010959.21222 | 2090503.85024 | 37.720743461908995 | -122.40416158569599 | (37.720743461909, -122.404161585696) | |||
| 176176 | 176176 | 209134 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Bosworth St | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6001014.7051099995 | 2095735.41705 | 37.7345474725699 | -122.438911322111 | (37.7345474725699, -122.438911322111) | ||||
| 167933 | 167933 | 209105 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 600x Faxon Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 31 | 5994942.183230001 | 2092612.57817 | 37.7256255467665 | -122.459679796903 | (37.7256255467665, -122.459679796903) | ||||
| 167812 | 167812 | 126605 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2900x Van Ness Ave | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | Width 8ft | 6005587.24482 | 2120569.72976 | 37.8029956442888 | -122.424868752794 | (37.8029956442888, -122.424868752794) | |||
| 165633 | 165633 | 223977 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2x Gough St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 37 | 6006660.75895 | 2109243.9943 | 37.7719585430967 | -122.42034948146002 | (37.7719585430967, -122.42034948146) | ||||
| 148876 | 148876 | 209172 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 600x Faxon Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 31 | 5994902.7257 | 2092594.45065 | 37.725573503888 | -122.45981488494199 | (37.725573503888, -122.459814884942) | ||||
| 146698 | 146698 | 223933 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 500x 27th St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 4ft | 6002792.14111 | 2100065.62398 | 37.7465381864861 | -122.43307541991999 | (37.7465381864861, -122.43307541992) | |||
| 146047 | 146047 | 10786 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1200X Hudson Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x4 | 6017715.991199099 | 2094753.0263542 | 37.7327861010711 | -122.381100521913 | (37.7327861010711, -122.381100521913) | |||
| 145604 | 145604 | 10747 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 145406 | 145406 | 21101 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2201X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5985004.6737667 | 2100227.1692458 | 37.745956718592794 | -122.494593556276 | (37.7459567185928, -122.494593556276) | |||
| 144907 | 144907 | 12078 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1241X La Salle Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017245.0743814 | 2094442.9323578998 | 37.7319086387255 | -122.382707045529 | (37.7319086387255, -122.382707045529) | |||
| 144777 | 144777 | 24280 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 300X Winding Way | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8 | 6001646.2933309 | 2086550.8578367 | 37.7093646550959 | -122.436070699117 | (37.7093646550959, -122.436070699117) | |||
| 144510 | 144510 | 10758 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 43 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 144450 | 144450 | 8595 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2355X Geary Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000490.27762 | 2113338.60243 | 37.7828516547291 | -122.44198752522699 | (37.7828516547291, -122.441987525227) | |||
| 144435 | 144435 | 11259 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1145X Ingalls St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3x4 | 6017856.860905 | 2093896.4273305 | 37.7304418229718 | -122.380553976439 | (37.7304418229718, -122.380553976439) | |||
| 144239 | 144239 | 11273 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1176X Ingalls St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/02/1992 12:00:00 AM | 18 | 3x3 | 6017716.362196 | 2093961.1645628002 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | ||
| 143708 | 143708 | 11250 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1145X Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x4 | 6017856.860905 | 2093896.4273305 | 37.7304418229718 | -122.380553976439 | (37.7304418229718, -122.380553976439) | |||
| 143311 | 143311 | 10754 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 17 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 8 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 143187 | 143187 | 10764 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 142989 | 142989 | 12075 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1241X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017245.0743814 | 2094442.9323578998 | 37.7319086387255 | -122.382707045529 | (37.7319086387255, -122.382707045529) | |||
| 142622 | 142622 | 101392 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 305X Hickory St | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6005503.9 | 2110451.5 | 37.775208804322 | -122.42443704976002 | (37.775208804322, -122.42443704976) | |||||
| 142398 | 142398 | 10808 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1139X Hudson Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6017594.95201 | 2094772.3990099998 | 37.7328326125475 | -122.381520335899 | (37.7328326125475, -122.381520335899) | |||
| 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) | ||
| 141300 | 141300 | 10755 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 44 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 141024 | 141024 | 11249 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1145X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/09/2003 12:00:00 AM | 8 | 3x4 | 6017856.860905 | 2093896.4273305 | 37.7304418229718 | -122.380553976439 | (37.7304418229718, -122.380553976439) | ||
| 140800 | 140800 | 47197 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2899X Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/2002 12:00:00 AM | 3 | 3x3 | 5986581.22601267 | 2112881.07204474 | 37.7807929786872 | -122.490072708464 | (37.7807929786872, -122.490072708464) | |
| 139368 | 139368 | 8587 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2355X Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6000490.27762 | 2113338.60243 | 37.7828516547291 | -122.44198752522699 | (37.7828516547291, -122.441987525227) | |||
| 139201 | 139201 | 10772 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 139037 | 139037 | 11285 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1176X Ingalls St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6017716.362196 | 2093961.1645628002 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | |||
| 138862 | 138862 | 47202 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2801X Clement St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/2002 12:00:00 AM | 12 | 3x3 | Permit Number 45157 | 5986698.68199 | 2113217.08014 | 37.7817224192006 | -122.489691093913 | (37.7817224192006, -122.489691093913) |
| 138783 | 138783 | 11294 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1199X Ingalls St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/02/1992 12:00:00 AM | 20 | 3X3 | 6017612.0195749 | 2093925.7037957 | 37.730508696225705 | -122.38140247160801 | (37.7305086962257, -122.381402471608) | ||
| 138686 | 138686 | 11245 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100X Ingalls St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/02/1998 12:00:00 AM | 12 | 3X4 | 6018021.124713 | 2094004.401623 | 37.7307473625426 | -122.37999358681499 | (37.7307473625426, -122.379993586815) | ||
| 138594 | 138594 | 11229 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1050X Ingalls St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X4 | 6018085.661882901 | 2094069.8743192002 | 37.7309306978843 | -122.379775016493 | (37.7309306978843, -122.379775016493) | |||
| 129075 | 129075 | 12082 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1261X La Salle Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6017141.6501925 | 2094501.7221284 | 37.732064349457005 | -122.383068698568 | (37.732064349457, -122.383068698568) | |||
| 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) | |||
| 128842 | 128842 | 11364 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1351X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/05/1992 12:00:00 AM | 45 | 3X3 | 6017270.42563 | 2093912.097264 | 37.730452470679005 | -122.38258247713001 | (37.730452470679, -122.38258247713) | ||
| 128637 | 128637 | 2140 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100X Bosworth St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 4 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | |||
| 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) | ||
| 127862 | 127862 | 101393 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 305X Hickory St | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6005503.9 | 2110451.5 | 37.775208804322 | -122.42443704976002 | (37.775208804322, -122.42443704976) | |||||
| 127830 | 127830 | 10751 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 127821 | 127821 | 11203 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1001X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X4 | 6018170.9910099 | 2094117.1281791 | 37.7310651541831 | -122.379483297777 | (37.7310651541831, -122.379483297777) | |||
| 126559 | 126559 | 98132 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 47 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 22 | 3x4 | 6017903.8 | 2094987.0 | 37.733438911814 | -122.38046746904399 | (37.733438911814, -122.380467469044) | |||
| 126260 | 126260 | 10819 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1139X Hudson Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6017712.13901 | 2094678.6490099998 | 37.7325816628845 | -122.38110867061701 | (37.7325816628845, -122.381108670617) | |||
| 126235 | 126235 | 11232 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X4 | 6018021.124713 | 2094004.401623 | 37.7307473625426 | -122.37999358681499 | (37.7307473625426, -122.379993586815) | |||
| 124813 | 124813 | 11267 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1176X Ingalls St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6017716.362196 | 2093961.1645628002 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | |||
| 124662 | 124662 | 99335 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 450 30th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 30 | 3.5x3.5 | 5986578.25407 | 2112899.8451 | 37.780844350584005 | -122.490084370963 | (37.780844350584, -122.490084370963) | ||
| 124473 | 124473 | 101397 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 305X Hickory St | 6 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6005503.9 | 2110451.5 | 37.775208804322 | -122.42443704976002 | (37.775208804322, -122.42443704976) | |||||
| 124384 | 124384 | 11246 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1145X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/09/2003 12:00:00 AM | 16 | 3x4 | 6017856.860905 | 2093896.4273305 | 37.7304418229718 | -122.380553976439 | (37.7304418229718, -122.380553976439) | ||
| 124289 | 124289 | 2008 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 500X Bosworth St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 12x100 | 6002728.1222807 | 2095276.2570246002 | 37.733384060718 | -122.432954679755 | (37.733384060718, -122.432954679755) | |||
| 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) | |||
| 123755 | 123755 | 11255 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1145X Ingalls St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/02/1992 12:00:00 AM | 80 | 3x4 | 6017856.860905 | 2093896.4273305 | 37.7304418229718 | -122.380553976439 | (37.7304418229718, -122.380553976439) | ||
| 123207 | 123207 | 10738 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 8 | 3x4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 123087 | 123087 | 12068 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1225X La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017323.1868972 | 2094393.2571117 | 37.7317765554235 | -122.38243353641701 | (37.7317765554235, -122.382433536417) | |||
| 122864 | 122864 | 12030 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1250X La Salle Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017218.4556902 | 2094518.6413490002 | 37.7321150500381 | -122.38280433953301 | (37.7321150500381, -122.382804339533) | |||
| 122783 | 122783 | 10768 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 23 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 14 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 121107 | 121107 | 2142 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100X Bosworth St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 4 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | |||
| 120914 | 120914 | 11299 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1199X Ingalls St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017612.0195749 | 2093925.7037957 | 37.730508696225705 | -122.38140247160801 | (37.7305086962257, -122.381402471608) | |||
| 120747 | 120747 | 11257 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1145X Ingalls St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3x4 | 6017856.860905 | 2093896.4273305 | 37.7304418229718 | -122.380553976439 | (37.7304418229718, -122.380553976439) | |||
| 120530 | 120530 | 101394 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 305X Hickory St | 3 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6005503.9 | 2110451.5 | 37.775208804322 | -122.42443704976002 | (37.775208804322, -122.42443704976) | |||||
| 120117 | 120117 | 10762 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 118265 | 118265 | 12069 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1225X La Salle Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017323.1868972 | 2094393.2571117 | 37.7317765554235 | -122.38243353641701 | (37.7317765554235, -122.382433536417) | |||
| 117900 | 117900 | 10742 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 116746 | 116746 | 2143 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100X Bosworth St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | |||
| 116742 | 116742 | 11283 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1176X Ingalls St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6017716.362196 | 2093961.1645628002 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | |||
| 116217 | 116217 | 101395 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 305X Hickory St | 4 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6005503.9 | 2110451.5 | 37.775208804322 | -122.42443704976002 | (37.775208804322, -122.42443704976) | |||||
| 115961 | 115961 | 11336 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1279 Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/04/1992 12:00:00 AM | 6 | 3X3 | 6017412.9471167 | 2093950.7223454 | 37.7305663998171 | -122.38209244081101 | (37.7305663998171, -122.382092440811) | ||
| 115821 | 115821 | 12014 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1230X La Salle Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/25/2011 12:00:00 AM | 6 | 3X3 | 6017323.1168478 | 2094452.6646717 | 37.7319396729967 | -122.382437910438 | (37.7319396729967, -122.382437910438) | ||
| 115776 | 115776 | 47200 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2801X Clement St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/2002 12:00:00 AM | 6 | 3x3 | Permit Number 45157 | 5986636.7904199995 | 2113215.6243 | 37.7817148081587 | -122.489905099586 | (37.7817148081587, -122.489905099586) |
| 115375 | 115375 | 10748 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 114504 | 114504 | 10774 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 39 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 6 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 113353 | 113353 | 10745 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 112808 | 112808 | 8594 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2355X Geary Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6000490.27762 | 2113338.60243 | 37.7828516547291 | -122.44198752522699 | (37.7828516547291, -122.441987525227) | |||
| 112688 | 112688 | 2150 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100X Bosworth St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/12/2006 12:00:00 AM | 24 | 6 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||
| 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) | |||
| 111525 | 111525 | 99343 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 450 30th Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 24 | 3x3 | 5986574.07493 | 2113086.2305799997 | 37.781355867791 | -122.490112542148 | (37.781355867791, -122.490112542148) | ||
| 110136 | 110136 | 27247 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 810X Mendell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6015977.80146 | 2096741.0789700001 | 37.7381487926265 | -122.38724856151501 | (37.7381487926265, -122.387248561515) | |||
| 109879 | 109879 | 14960 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 355 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016837.9157235 | 2097829.6220681 | 37.7411853074585 | -122.38435047916201 | (37.7411853074585, -122.384350479162) | |||
| 109373 | 109373 | 11264 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1176X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/02/1992 12:00:00 AM | 45 | 3X3 | 6017716.362196 | 2093961.1645628002 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | ||
| 108988 | 108988 | 10842 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1139X Hudson Ave | 49 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6018020.73301 | 2094608.3360099997 | 37.732405626582796 | -122.380036890979 | (37.7324056265828, -122.380036890979) | |||
| 108965 | 108965 | 10753 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 108963 | 108963 | 26713 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 340 Lake St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 2x2 | 5994414.30523 | 2114928.2579900003 | 37.7868683042504 | -122.46312306923099 | (37.7868683042504, -122.463123069231) | |||
| 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) | |||
| 107134 | 107134 | 12043 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1250X La Salle Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/1993 12:00:00 AM | 12 | 3X3 | 6017218.4556902 | 2094518.6413490002 | 37.7321150500381 | -122.38280433953301 | (37.7321150500381, -122.382804339533) | ||
| 106941 | 106941 | 10744 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 106239 | 106239 | 47203 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2801X Clement St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/2002 12:00:00 AM | 10 | 3x3 | Permit Number 45157 | 5986727.74959 | 2113216.7702900004 | 37.7817232655044 | -122.48959051227101 | (37.7817232655044, -122.489590512271) |
| 105607 | 105607 | 10746 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 105402 | 105402 | 10757 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 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) | ||
| 104800 | 104800 | 8590 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2355X Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X3 | 6000490.27762 | 2113338.60243 | 37.7828516547291 | -122.44198752522699 | (37.7828516547291, -122.441987525227) | |||
| 104681 | 104681 | 10805 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1139X Hudson Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/1990 12:00:00 AM | 12 | 3x4 | 6017572.81601 | 2094794.5340099998 | 37.732892168704204 | -122.381598405298 | (37.7328921687042, -122.381598405298) | ||
| 104315 | 104315 | 11345 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1300X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6017347.6886145 | 2093992.5867035 | 37.730677746775605 | -122.382320962891 | (37.7306777467756, -122.382320962891) | |||
| 103686 | 103686 | 10735 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100 Hudson Ave | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 3x4 | 6018138.790397401 | 2094650.7890521 | 37.7325287066123 | -122.379631682873 | (37.7325287066123, -122.379631682873) | |||
| 103589 | 103589 | 11241 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100X Ingalls St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X4 | 6018021.124713 | 2094004.401623 | 37.7307473625426 | -122.37999358681499 | (37.7307473625426, -122.379993586815) | |||
| 103065 | 103065 | 12025 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1250X La Salle Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017218.4556902 | 2094518.6413490002 | 37.7321150500381 | -122.38280433953301 | (37.7321150500381, -122.382804339533) | |||
| 102867 | 102867 | 10766 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 40 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 102487 | 102487 | 10778 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1200X Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x4 | 6017715.991199099 | 2094753.0263542 | 37.7327861010711 | -122.381100521913 | (37.7327861010711, -122.381100521913) | |||
| 102311 | 102311 | 23415 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1800X VAN NESS AVE | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006192.0 | 2116736.0 | 37.7925033310543 | -122.422503407712 | (37.7925033310543, -122.422503407712) | |||
| 99737 | 99737 | 10739 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) |
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");