Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 119378 | 119378 | 42217 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 661 Howard St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42483 | 6012771.23281155 | 2114106.53972764 | 37.785652410342 | -122.399554213705 | (37.785652410342, -122.399554213705) | ||
| 119632 | 119632 | 45473 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1301 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | Permit Number 44252 | 5993960.36650023 | 2094413.72258595 | 37.730514541433 | -122.463204465727 | (37.730514541433, -122.463204465727) | ||
| 120010 | 120010 | 35825 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 618 Edinburg St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1998 12:00:00 AM | Permit Number 39058 | 6002465.48488427 | 2090189.48175621 | 37.7194020221485 | -122.433499297304 | (37.7194020221485, -122.433499297304) | ||
| 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) | |||||
| 121735 | 121735 | 46612 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 394 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | Permit Number 44735. Tree 1 on 25th St | 6005464.68638444 | 2101420.18882448 | 37.750408745884 | -122.423930345056 | (37.750408745884, -122.423930345056) | ||
| 123804 | 123804 | 105974 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1336 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 771235 | 6006462.9 | 2119771.0 | 37.8008519560253 | -122.421781757787 | (37.8008519560253, -122.421781757787) | ||||
| 123872 | 123872 | 38685 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1785 Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/1998 12:00:00 AM | Permit Number 40599 | 5999225.65056076 | 2110784.42467282 | 37.7757663950795 | -122.446178803683 | (37.7757663950795, -122.446178803683) | |||
| 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) | |||||
| 125434 | 125434 | 46586 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 498 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/05/2002 12:00:00 AM | Permit Number 44715 | 6005498.22104123 | 2100816.59479858 | 37.74875330870471 | -122.423771466824 | (37.7487533087047, -122.423771466824) | ||
| 126339 | 126339 | 41716 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 543 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2001 12:00:00 AM | Permit Number 44133 | 6008753.21337376 | 2096281.65864333 | 37.736484582007606 | -122.412195213265 | (37.7364845820076, -122.412195213265) | ||
| 127455 | 127455 | 42182 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 715 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42466 | 6012416.63723338 | 2111137.79713862 | 37.77748115885579 | -122.400572401541 | (37.7774811588558, -122.400572401541) | ||
| 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) | |||||
| 138666 | 138666 | 42670 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1575 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42698 | 6006081.025120299 | 2117910.0746573997 | 37.7957207841663 | -122.422970868865 | (37.7957207841663, -122.422970868865) | ||
| 138814 | 138814 | 103611 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 200X Buchanan St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6004748.9 | 2109266.8 | 37.7719132424086 | -122.426964371637 | (37.7719132424086, -122.426964371637) | |||||
| 139152 | 139152 | 36701 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3698x 19th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1998 12:00:00 AM | Permit Number 39496 | 6005001.97582164 | 2104885.80884876 | 37.759898394802605 | -122.42577707942199 | (37.7598983948026, -122.425777079422) | ||
| 139196 | 139196 | 72854 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 24 Lunado Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/1998 12:00:00 AM | 5991516.52955398 | 2091408.89207172 | 37.722122935753106 | -122.47143422303499 | (37.7221229357531, -122.471434223035) | ||||
| 139804 | 139804 | 101839 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3815-3817 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6003483.0 | 2105926.0 | 37.762668556023996 | -122.43110471906799 | (37.762668556024, -122.431104719068) | |||||
| 140922 | 140922 | 40278 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 327 Bartlett St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41430 | 6006777.24179017 | 2101874.53362521 | 37.751730286943996 | -122.41942365408998 | (37.751730286944, -122.41942365409) | ||
| 141513 | 141513 | 39210 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 101 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/1999 12:00:00 AM | Permit Number 41852 | 5998202.98711321 | 2108218.1904746 | 37.7686617185434 | -122.449531484363 | (37.7686617185434, -122.449531484363) | ||
| 142126 | 142126 | 104912 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 606 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 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) | |||||
| 143198 | 143198 | 122595 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 524 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6010413.68618597 | 2119615.98935706 | 37.8006483359763 | -122.408099375454 | (37.8006483359763, -122.408099375454) | |||
| 143938 | 143938 | 87251 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2 Argonaut Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50275 | 6008259.0 | 2086838.7 | 37.7105284764145 | -122.413236372693 | (37.7105284764145, -122.413236372693) | |||
| 144392 | 144392 | 114967 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 469 Hill St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x5 | 6003301.68334873 | 2103280.29729908 | 37.7553938131292 | -122.431542939454 | (37.7553938131292, -122.431542939454) | ||||
| 144727 | 144727 | 113324 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1234 10th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5993019.12807809 | 2107069.22790191 | 37.76520905664 | -122.467378332531 | (37.76520905664, -122.467378332531) | |||
| 144880 | 144880 | 103613 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 200X Buchanan St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6004748.9 | 2109266.8 | 37.7719132424086 | -122.426964371637 | (37.7719132424086, -122.426964371637) | |||||
| 145734 | 145734 | 42121 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 110 Melrose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42418 | 5999349.45513333 | 2095526.80253467 | 37.7338797805201 | -122.44465363726002 | (37.7338797805201, -122.44465363726) | ||
| 175378 | 175378 | 38350 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1666 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/1998 12:00:00 AM | 0 | Permit Number 40417 | 5981619.44120207 | 2103744.31851256 | 37.7554151050669 | -122.506559824318 | (37.7554151050669, -122.506559824318) | |
| 41375 | 41375 | 45055 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2311 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2011 12:00:00 AM | 1 | Permit Number 767715 | 5988234.443 | 2099548.661 | 37.7442822204704 | -122.483375858058 | (37.7442822204704, -122.483375858058) | ||
| 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) | |||
| 75369 | 75369 | 176363 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 0 Font Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5988462.773440001 | 2091307.9607099998 | 37.7216686718604 | -122.48198279658399 | (37.7216686718604, -122.481982796584) | ||||
| 76240 | 76240 | 181839 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2301 22nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5989478.1431 | 2099509.7425 | 37.7442476652043 | -122.479072610686 | (37.7442476652043, -122.479072610686) | |||
| 162561 | 162561 | 181838 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2301 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5989472.8976 | 2099634.4509 | 37.744589777235 | -122.47909986870899 | (37.744589777235, -122.479099868709) | |||
| 167432 | 167432 | 105846 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 227-229 09th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | Permit Number 772678 | 6008913.98004 | 2110186.85299 | 37.774674124254 | -122.41262205766 | (37.774674124254, -122.41262205766) | ||
| 26878 | 26878 | 182670 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3130 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5985221.0937 | 2101626.7981 | 37.749812382761604 | -122.493948347017 | (37.7498123827616, -122.493948347017) | |||
| 34903 | 34903 | 209050 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1957 11th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 8ft | 5992832.0563900005 | 2102279.47717 | 37.752046850582104 | -122.46767699299299 | (37.7520468505821, -122.467676992993) | |||
| 37598 | 37598 | 223959 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 642 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002363.563630001 | 2104457.3204 | 37.7585724195079 | -122.434871407414 | (37.7585724195079, -122.434871407414) | |||
| 51031 | 51031 | 206258 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 470 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5998976.70694 | 2094998.91633 | 37.732409052024295 | -122.44590438200198 | (37.7324090520243, -122.445904382002) | ||||
| 59027 | 59027 | 209180 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1265 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5994085.05956 | 2094328.0353599999 | 37.7302864478603 | -122.46276717308099 | (37.7302864478603, -122.462767173081) | |||
| 70601 | 70601 | 209051 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1957 11th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 8ft | 5992829.67425 | 2102278.35273 | 37.7520436256167 | -122.46768514894501 | (37.7520436256167, -122.467685148945) | |||
| 153064 | 153064 | 209107 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 193 Del Sur Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 5996293.217 | 2098512.8371200003 | 37.7419038289077 | -122.455435654254 | (37.7419038289077, -122.455435654254) | |||
| 185731 | 185731 | 223970 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 54 Potomac St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003137.39026 | 2108599.9240900003 | 37.7699909109802 | -122.43249105572399 | (37.7699909109802, -122.432491055724) | |||
| 187237 | 187237 | 181823 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2311 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5987302.7678 | 2099517.8646 | 37.7441433943159 | -122.48659508954799 | (37.7441433943159, -122.486595089548) | |||
| 1502 | 1502 | 223929 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 610 Clipper St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 779880 | 6001216.05485 | 2100901.84413 | 37.748744719898 | -122.43858524950599 | (37.748744719898, -122.438585249506) | |
| 7152 | 7152 | 29781 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2000X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2006 12:00:00 AM | 3 | 6006021.95745 | 2117391.75426 | 37.7942942736085 | -122.42313839334601 | (37.7942942736085, -122.423138393346) | |||
| 8274 | 8274 | 41820 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 848 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/2016 12:00:00 AM | 3 | Permit Number 42207 | 6000005.683999999 | 2111868.9913 | 37.7787888536845 | -122.44355840768 | (37.7787888536845, -122.44355840768) | |
| 15149 | 15149 | 22069 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2955 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/2000 12:00:00 AM | 3 | 3X3 | 6015996.14125 | 2101854.73781 | 37.7521908608401 | -122.387541804919 | (37.7521908608401, -122.387541804919) | ||
| 15438 | 15438 | 104819 | Planning Code 138.1 required 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 468 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2016 12:00:00 AM | 3 | 3X3 | Permit Number 770905 | 6011018.41682 | 2111922.08536 | 37.7795565535331 | -122.405464583724 | (37.7795565535331, -122.405464583724) | |
| 16239 | 16239 | 22065 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2955 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2000 12:00:00 AM | 3 | 3X3 | 6016001.4583 | 2101755.32387 | 37.7519181854896 | -122.387516482698 | (37.7519181854896, -122.387516482698) | ||
| 16446 | 16446 | 22064 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2955 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2000 12:00:00 AM | 3 | 3X3 | 6016002.11901 | 2101736.21307 | 37.751865747830294 | -122.38751286473301 | (37.7518657478303, -122.387512864733) | ||
| 19977 | 19977 | 29369 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 500X Bosworth St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/06/2005 12:00:00 AM | 3 | 3X3 | 6002638.340030001 | 2095276.9082799999 | 37.733380755998894 | -122.43326512830099 | (37.7333807559989, -122.433265128301) | ||
| 21793 | 21793 | 29370 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 500X Bosworth St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/06/2005 12:00:00 AM | 3 | 3X3 | 6002650.152480001 | 2095274.05972 | 37.733373604614 | -122.433224085933 | (37.733373604614, -122.433224085933) | ||
| 67833 | 67833 | 223961 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 650 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002363.39606 | 2104418.0666099996 | 37.7584646285442 | -122.43486917976999 | (37.7584646285442, -122.43486917977) | |||
| 72113 | 72113 | 142421 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 MAYFAIR DR | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5997633.2625 | 2114522.3029 | 37.78593856211079 | -122.451956978624 | (37.7859385621108, -122.451956978624) | |||
| 85139 | 85139 | 6395 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 5X Rosie Lee Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/1993 12:00:00 AM | 3 | 3X4 | 6018168.8629005 | 2094369.8502073998 | 37.7317589621466 | -122.379508204595 | (37.7317589621466, -122.379508204595) | ||
| 99438 | 99438 | 11256 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1145X Ingalls St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/09/2003 12:00:00 AM | 3 | 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) | |
| 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) | |||
| 184713 | 184713 | 66497 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2468 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51581 | 6001708.326 | 2114654.8124 | 37.786534966555 | -122.43786789884399 | (37.786534966555, -122.437867898844) | |
| 27792 | 27792 | 191902 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1195 La Salle Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017450.79978 | 2094350.27208 | 37.7316655752946 | -122.38198935913401 | (37.7316655752946, -122.381989359134) | |||
| 35579 | 35579 | 191894 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1195 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017504.55596 | 2094293.80074 | 37.731513484662706 | -122.381799585104 | (37.7315134846627, -122.381799585104) | |||
| 64586 | 64586 | 191900 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1195 La Salle Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017457.95459 | 2094342.111 | 37.7316435616999 | -122.38196405581101 | (37.7316435616999, -122.381964055811) | |||
| 135904 | 135904 | 209053 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1957 11th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 5992831.69436 | 2102262.26112 | 37.7519995588464 | -122.467676992992 | (37.7519995588464, -122.467676992992) | |||
| 172379 | 172379 | 223971 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 54 Potomac St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003133.19569 | 2108609.74103 | 37.7700176280312 | -122.43250626595301 | (37.7700176280312, -122.432506265953) | |||
| 22909 | 22909 | 209066 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 140 San Aleso Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993360.06028 | 2094684.7320599998 | 37.7312240657298 | -122.46529947329901 | (37.7312240657298, -122.465299473299) | |||
| 24482 | 24482 | 223960 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 646 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002361.48335 | 2104431.90571 | 37.75850251878121 | -122.434876784451 | (37.7585025187812, -122.434876784451) | |||
| 43785 | 43785 | 209158 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 290 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992876.2231 | 2094948.79884 | 37.731921212982606 | -122.46699136156799 | (37.7319212129826, -122.466991361568) | |||
| 51940 | 51940 | 74090 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2301 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 5 | 5986841.7666 | 2102304.3098 | 37.751767339194394 | -122.488393849306 | (37.7517673391944, -122.488393849306) | ||
| 70613 | 70613 | 209087 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 55 San Benito Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 5992856.63194 | 2096437.26886 | 37.736007049788704 | -122.467167275266 | (37.7360070497887, -122.467167275266) | |||
| 137880 | 137880 | 191910 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1195 La Salle Ave | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017194.90189 | 2094527.0562099998 | 37.7321368542252 | -122.38288635642901 | (37.7321368542252, -122.382886356429) | |||
| 149465 | 149465 | 209069 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 177 San Aleso Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993364.4367 | 2094431.43007 | 37.7305288133566 | -122.465265951075 | (37.7305288133566, -122.465265951075) | |||
| 155133 | 155133 | 209159 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 280 San Benito Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992878.6780900005 | 2094978.8756099998 | 37.732003938024796 | -122.466985060028 | (37.7320039380248, -122.466985060028) | |||
| 175539 | 175539 | 223937 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 104 Appleton Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 6005739.63861 | 2096990.5696 | 37.738261535936104 | -122.42266479414101 | (37.7382615359361, -122.422664794141) | |||
| 176514 | 176514 | 185800 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2840 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5986119.1838 | 2101655.0773 | 37.7499425361402 | -122.490844835828 | (37.7499425361402, -122.490844835828) | |||
| 19538 | 19538 | 16588 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 88X Noe St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 3X3 | 6002852.6033 | 2107735.26664 | 37.7676006199961 | -122.43341433031401 | (37.7676006199961, -122.433414330314) | |||
| 20904 | 20904 | 12016 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1230X La Salle Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/09/1992 12:00:00 AM | 6 | 3X3 | 6017323.1168478 | 2094452.6646717 | 37.7319396729967 | -122.382437910438 | (37.7319396729967, -122.382437910438) | ||
| 21291 | 21291 | 2046 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 701X Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001912.87216 | 2095420.3332200001 | 37.733733385587 | -122.43578352768299 | (37.733733385587, -122.435783527683) | |||
| 25083 | 25083 | 250988 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 401 45th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5981857.67732 | 2112961.27677 | 37.780736228431394 | -122.50641942431999 | (37.7807362284314, -122.50641942432) | ||||
| 29272 | 29272 | 206257 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 470 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5998979.032869999 | 2094999.63504 | 37.7324111582444 | -122.44589639242099 | (37.7324111582444, -122.445896392421) | ||||
| 38339 | 38339 | 8592 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2355X Geary Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6000490.27762 | 2113338.60243 | 37.7828516547291 | -122.44198752522699 | (37.7828516547291, -122.441987525227) | |||
| 40028 | 40028 | 223932 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 540 28th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6002411.2824 | 2099479.33596 | 37.74490676593071 | -122.434350476903 | (37.7449067659307, -122.434350476903) | |||
| 40175 | 40175 | 191956 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1322 Hudson Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6017678.2748300005 | 2094778.00279 | 37.7328525994565 | -122.381232654284 | (37.7328525994565, -122.381232654284) | |||
| 70610 | 70610 | 223925 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 500 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999564.17484 | 2104214.7401099997 | 37.7577470163215 | -122.444535489722 | (37.7577470163215, -122.444535489722) | |||
| 73794 | 73794 | 73855 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2301 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 6 | 5986859.2227 | 2102304.8233 | 37.7517697676229 | -122.488333522296 | (37.7517697676229, -122.488333522296) | ||
| 78253 | 78253 | 12004 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1230X La Salle Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6017323.1168478 | 2094452.6646717 | 37.7319396729967 | -122.382437910438 | (37.7319396729967, -122.382437910438) | |||
| 95728 | 95728 | 8589 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2355X Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6000490.27762 | 2113338.60243 | 37.7828516547291 | -122.44198752522699 | (37.7828516547291, -122.441987525227) | |||
| 96730 | 96730 | 16821 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2130 O'Farrell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001107.6476595 | 2113179.9385941 | 37.782451166007 | -122.439840308676 | (37.782451166007, -122.439840308676) | |||
| 97478 | 97478 | 2145 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100X Bosworth St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) |
| 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) | ||
| 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) | ||
| 120398 | 120398 | 12053 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1300X La Salle Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/29/1993 12:00:00 AM | 6 | 3X3 | 6016940.808513099 | 2094664.4394134998 | 37.7325000389111 | -122.38377438405399 | (37.7325000389111, -122.383774384054) | ||
| 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) | |||
| 147984 | 147984 | 247210 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 800 Duboce Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6001850.29311 | 2108285.87334 | 37.769055534222105 | -122.4369206089 | (37.7690555342221, -122.4369206089) | |||
| 154233 | 154233 | 209052 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1957 11th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 5992832.75992 | 2102275.5477 | 37.7520361018924 | -122.467674274354 | (37.7520361018924, -122.467674274354) | |||
| 175778 | 175778 | 247211 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 800 Duboce Ave | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6001837.76454 | 2108286.1140099997 | 37.769055482952105 | -122.43696396161998 | (37.7690554829521, -122.43696396162) | |||
| 181476 | 181476 | 142278 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1775 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5999245.2812 | 2110787.8491 | 37.775776918731395 | -122.44611114298701 | (37.7757769187314, -122.446111142987) |
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");