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) | ||
| 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) | |||
| 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) | ||
| 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) | |||||
| 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) | |
| 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) | |
| 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) | |
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | ||
| 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) | |||
| 181505 | 181505 | 191904 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1195 La Salle Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6017421.0392 | 2094371.6417099999 | 37.731722608506104 | -122.38209373444401 | (37.7317226085061, -122.382093734444) | |||
| 183383 | 183383 | 209176 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2337 09th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5992771.7219 | 2100498.8972099996 | 37.7471543516063 | -122.467756148633 | (37.7471543516063, -122.467756148633) | |||
| 26017 | 26017 | 82939 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 741 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52449 | 6009171.80953 | 2110382.94472 | 37.775227013061 | -122.411744028881 | (37.775227013061, -122.411744028881) | |
| 27119 | 27119 | 209185 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 140 Kensington Way | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | Width 3ft | 5994853.690119999 | 2098493.2474700003 | 37.741767335194105 | -122.460411617495 | (37.7417673351941, -122.460411617495) | |||
| 31651 | 31651 | 209143 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 338 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5995743.47227 | 2090580.0284400003 | 37.7200906944019 | -122.456762889002 | (37.7200906944019, -122.456762889002) | |||
| 55679 | 55679 | 200228 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1079 Ingerson Ave | 2 | unknown : Yard 19 | Tree 1 | Private 1 | 7 | Width 0ft | 6013685.1573 | 2090181.4131 | 37.7200100518893 | -122.394716195485 | (37.7200100518893, -122.394716195485) | |||
| 58850 | 58850 | 142639 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 22 VANDEWATER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6009078.1452 | 2121326.0074 | 37.8052687504629 | -122.412841878433 | (37.8052687504629, -122.412841878433) | |||
| 72895 | 72895 | 209128 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 262 Juanita Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5995594.34182 | 2097856.84111 | 37.740062499390895 | -122.45780466457501 | (37.7400624993909, -122.457804664575) | |||
| 74888 | 74888 | 248336 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1549 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5998153.3936 | 2108210.9771 | 37.7686390752497 | -122.449702503746 | (37.7686390752497, -122.449702503746) | |||
| 157487 | 157487 | 38868 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2439 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2006 12:00:00 AM | 7 | Permit Number 40694 | 5987331.8721 | 2098675.8712 | 37.7418332004815 | -122.486432648249 | (37.7418332004815, -122.486432648249) | |
| 158451 | 158451 | 209127 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 262 Juanita Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5995604.03201 | 2097864.96226 | 37.7400853547621 | -122.457771747584 | (37.7400853547621, -122.457771747584) | |||
| 35899 | 35899 | 191874 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1446 Osceola Ln | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6017213.67337 | 2094295.67432 | 37.7315025623769 | -122.38280536260099 | (37.7315025623769, -122.382805362601) | |||
| 52793 | 52793 | 191948 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1322 Hudson Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6017805.35755 | 2094693.89417 | 37.7326286682735 | -122.380787447581 | (37.7326286682735, -122.380787447581) | |||
| 53277 | 53277 | 209085 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 59 San Benito Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 8ft | 5992858.20265 | 2096383.97186 | 37.7358608002304 | -122.467157970863 | (37.7358608002304, -122.467157970863) | |||
| 60205 | 60205 | 209170 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 445 Darien Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5992852.574469999 | 2094916.2637 | 37.7318305145565 | -122.46707075461501 | (37.7318305145565, -122.467070754615) | |||
| 67508 | 67508 | 126593 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1903 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6004413.74304 | 2117671.69069 | 37.7949720215818 | -122.428722965614 | (37.7949720215818, -122.428722965614) | |||
| 135992 | 135992 | 209123 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 254 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5995738.130530001 | 2097948.40357 | 37.7403221669414 | -122.457314127542 | (37.7403221669414, -122.457314127542) | |||
| 165553 | 165553 | 209171 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 445 Darien Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5992804.12959 | 2094918.0083 | 37.731832508358 | -122.46723836397499 | (37.731832508358, -122.467238363975) | |||
| 167442 | 167442 | 209144 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 515 Niagara Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5998030.205080001 | 2090461.4048799998 | 37.7198960190796 | -122.448849923382 | (37.7198960190796, -122.448849923382) | |||
| 171739 | 171739 | 73437 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 201 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2008 12:00:00 AM | 8 | 4x4 | Permit Number 50063 | 5992414.36096 | 2114080.94062 | 37.784426393924605 | -122.46998063366001 | (37.7844263939246, -122.46998063366) | |
| 174126 | 174126 | 72282 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 734 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 8 | 5982929.57235 | 2110777.2604400003 | 37.774802607591894 | -122.50254958518299 | (37.7748026075919, -122.502549585183) | ||
| 177588 | 177588 | 140907 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2311 Geary Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6000544.5361 | 2113345.4411 | 37.7828735237408 | -122.44180030507401 | (37.7828735237408, -122.441800305074) | |||
| 177796 | 177796 | 191969 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1322 Hudson Ave | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6017439.33628 | 2095027.5859 | 37.7335247123006 | -122.382076089739 | (37.7335247123006, -122.382076089739) | |||
| 178418 | 178418 | 244114 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 418 Shrader St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997491.8129 | 2108946.6394 | 37.770621142726796 | -122.45204393067301 | (37.7706211427268, -122.452043930673) | |||
| 181977 | 181977 | 209054 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1957 11th Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 5992825.40755 | 2102262.3933200003 | 37.7519995588359 | -122.467698743122 | (37.7519995588359, -122.467698743122) | |||
| 185066 | 185066 | 209063 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 145 San Benito Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 6ft | 5992885.628190001 | 2095683.4514799998 | 37.7339389292425 | -122.46701223754299 | (37.7339389292425, -122.467012237543) | |||
| 187645 | 187645 | 209124 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 254 Juanita Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5995716.94205 | 2097934.51072 | 37.7402828036061 | -122.457386383573 | (37.7402828036061, -122.457386383573) | |||
| 37535 | 37535 | 223924 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1013 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008041.687530001 | 2101929.49372 | 37.751952331841295 | -122.41505490906601 | (37.7519523318413, -122.415054909066) | |||
| 60349 | 60349 | 123310 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 401 05th Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5994327.796159999 | 2112619.24355 | 37.78052339146429 | -122.463254756685 | (37.7805233914643, -122.463254756685) | |||
| 68442 | 68442 | 126585 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2626 Baker St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 5999659.00092 | 2117875.6856 | 37.7952618910822 | -122.445189684462 | (37.7952618910822, -122.445189684462) |
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");