Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▼ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |
| 1567 | 1567 | 251594 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3698 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005038.0 | 2104916.0 | 37.7599833282319 | -122.42565463806999 | (37.7599833282319, -122.42565463807) | ||||
| 1574 | 1574 | 251596 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3698 19th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005038.0 | 2104916.0 | 37.7599833282319 | -122.42565463806999 | (37.7599833282319, -122.42565463807) | ||||
| 1583 | 1583 | 251593 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3698 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005038.0 | 2104916.0 | 37.7599833282319 | -122.42565463806999 | (37.7599833282319, -122.42565463807) | ||||
| 1592 | 1592 | 251595 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3698 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005038.0 | 2104916.0 | 37.7599833282319 | -122.42565463806999 | (37.7599833282319, -122.42565463807) | ||||
| 1985 | 1985 | 252841 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1763 Golden Gate Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/1998 12:00:00 AM | 3x3 | Permit Number 40601 | 6001163.0 | 2111730.0 | 37.7784731541065 | -122.43954484007 | (37.7784731541065, -122.43954484007) | |||
| 4251 | 4251 | 246122 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1518 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | Permit Number 46036 | 5998379.9097 | 2108286.3815 | 37.768859073318 | -122.448924438468 | (37.768859073318, -122.448924438468) | ||
| 5531 | 5531 | 7687 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 521 Francisco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6008787.0132 | 2121079.8095 | 37.8045764073538 | -122.413831954826 | (37.8045764073538, -122.413831954826) | |||
| 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) | |
| 9470 | 9470 | 105079 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3770 24TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6004633.1 | 2101955.7 | 37.7518321521274 | -122.426844164794 | (37.7518321521274, -122.426844164794) | |||
| 11387 | 11387 | 104350 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 349 Guttenberg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 5999840.77458 | 2086361.4281900001 | 37.708741782568104 | -122.44229725703 | (37.7087417825681, -122.44229725703) | |||
| 11531 | 11531 | 43168 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 285 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 14 | 3x3 | Permit Number 42977 | 6005738.99154 | 2092366.96158 | 37.7255660943895 | -122.422338611837 | (37.7255660943895, -122.422338611837) |
| 12964 | 12964 | 44723 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1946 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 13 | Permit Number 43842 | 5989432.8015 | 2102080.7043 | 37.751304216428 | -122.47941744514699 | (37.751304216428, -122.479417445147) | |
| 13735 | 13735 | 22066 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2955 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2000 12:00:00 AM | 14 | 3X3 | 6015999.04813 | 2101774.12278 | 37.751969669865396 | -122.387526128851 | (37.7519696698654, -122.387526128851) | ||
| 14844 | 14844 | 12128 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1400X La Salle Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6016480.84106 | 2095117.09347 | 37.73371749994771 | -122.385396148429 | (37.7337174999477, -122.385396148429) | |||
| 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) | |
| 17255 | 17255 | 32525 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 864 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/15/1996 12:00:00 AM | 14 | 3x3 | Permit Number 37027 | 6007539.30835 | 2095267.7389900002 | 37.7336323917164 | -122.41632041617399 | (37.7336323917164, -122.416320416174) | |
| 17710 | 17710 | 4470 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1500 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004528.8343 | 2100105.60966 | 37.746746337268206 | -122.42707296863999 | (37.7467463372682, -122.42707296864) | |||
| 17771 | 17771 | 16032 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 155 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5993339.50797 | 2095294.7939400002 | 37.7328979594755 | -122.465414825734 | (37.7328979594755, -122.465414825734) | |||
| 18999 | 18999 | 4466 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1484 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6004525.42539 | 2100206.65772 | 37.747023599154204 | -122.427091952431 | (37.7470235991542, -122.427091952431) | |||
| 19052 | 19052 | 22819 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 61 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 2X2 | 10/31/08 | 5999145.766480001 | 2099274.26515 | 37.7441577943622 | -122.445627242426 | (37.7441577943622, -122.445627242426) | ||
| 19220 | 19220 | 4482 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1551 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004606.71516 | 2099825.83197 | 37.7459825358766 | -122.426783743093 | (37.7459825358766, -122.426783743093) | |||
| 19560 | 19560 | 103375 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 22 VANDEWATER ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x2.5 | Permit Number 770057 | 6009069.0 | 2121391.0 | 37.8054466905223 | -122.41287812458401 | (37.8054466905223, -122.412878124584) | ||||
| 21257 | 21257 | 4479 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1542 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6004543.28364 | 2099929.0819200003 | 37.7462624498637 | -122.427010433384 | (37.7462624498637, -122.427010433384) | |||
| 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) | |||
| 23439 | 23439 | 209167 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 102 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 5992842.6234800005 | 2095968.7682299998 | 37.7347198555328 | -122.46718165450599 | (37.7347198555328, -122.467181654506) | |||
| 23593 | 23593 | 140908 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2313 Geary Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6000568.9025 | 2113347.1332 | 37.782879558173 | -122.44171612920601 | (37.782879558173, -122.441716129206) | |||
| 23691 | 23691 | 126591 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2547 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6002516.512 | 2116417.22855 | 37.7914200340546 | -122.435197883791 | (37.7914200340546, -122.435197883791) | |||
| 23872 | 23872 | 191975 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1322 Hudson Ave | 39 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6017399.67227 | 2095082.1979 | 37.7336724754063 | -122.38221701890801 | (37.7336724754063, -122.382217018908) | |||
| 23885 | 23885 | 191818 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 800 Vermont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 5ft | 6011263.76094 | 2104558.51579 | 37.7593515840395 | -122.40409746133899 | (37.7593515840395, -122.404097461339) | |||
| 24127 | 24127 | 191921 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1197 La Salle Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 6016798.849090001 | 2094747.4221400002 | 37.7327200447776 | -122.384270953564 | (37.7327200447776, -122.384270953564) | |||
| 24217 | 24217 | 206259 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 125 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6000067.98121 | 2094222.9592799998 | 37.73034070664679 | -122.442075923983 | (37.7303407066468, -122.442075923983) | |||
| 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) | |||
| 24581 | 24581 | 191958 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1322 Hudson Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6017653.96329 | 2094797.5572 | 37.732904949909994 | -122.381318065575 | (37.73290494991, -122.381318065575) | |||
| 24685 | 24685 | 32723 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1082 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 12 | Permit Number 37114 | 6007012.43686 | 2114697.78275 | 37.786953139214894 | -122.419519994465 | (37.7869531392149, -122.419519994465) | |
| 24829 | 24829 | 126588 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 116 Alhambra St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 4ft | 6001687.928040001 | 2120423.89073 | 37.8023741929754 | -122.438351935704 | (37.8023741929754, -122.438351935704) | |||
| 25389 | 25389 | 191966 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1322 Hudson Ave | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6017499.193519999 | 2094948.2745700001 | 37.7333102446675 | -122.381863629414 | (37.7333102446675, -122.381863629414) | |||
| 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) | |
| 26530 | 26530 | 32698 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 665 Geary St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 11 | Permit Number 37104 | 6008567.49434 | 2114513.32482 | 37.7865341297888 | -122.41412677632799 | (37.7865341297888, -122.414126776328) | |
| 26861 | 26861 | 223941 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2920 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 5ft | 6008707.1886599995 | 2103338.13414 | 37.755857516419795 | -122.412853084526 | (37.7558575164198, -122.412853084526) | |||
| 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) | |||
| 26906 | 26906 | 191961 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1322 Hudson Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6017640.3936 | 2094798.44512 | 37.7329066388304 | -122.381365041689 | (37.7329066388304, -122.381365041689) | |||
| 27432 | 27432 | 66268 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2008 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/1990 12:00:00 AM | 12 | Permit Number 29375 | 5986711.6119 | 2096941.9622 | 37.7370361716902 | -122.488449873835 | (37.7370361716902, -122.488449873835) | ||
| 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) | |||
| 27826 | 27826 | 224310 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 321 Fair Oaks St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 6ft | 6005486.40879 | 2101775.92672 | 37.751386746407796 | -122.423880520163 | (37.7513867464078, -122.423880520163) | |||
| 28144 | 28144 | 126582 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2626 Baker St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5999650.13095 | 2117889.12235 | 37.795298278541104 | -122.445221342394 | (37.7952982785411, -122.445221342394) | |||
| 28636 | 28636 | 126598 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6007429.13284 | 2114453.39413 | 37.7863055697923 | -122.418060985632 | (37.7863055697923, -122.418060985632) | |||
| 28637 | 28637 | 191976 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1322 Hudson Ave | 42 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6017379.91787 | 2095113.3460400002 | 37.7337569109368 | -122.38228748260599 | (37.7337569109368, -122.382287482606) | |||
| 29148 | 29148 | 191903 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1195 La Salle Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6017445.64237 | 2094357.66392 | 37.7316855870107 | -122.38200770350201 | (37.7316855870107, -122.382007703502) | |||
| 29750 | 29750 | 192007 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1201 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6017817.46724 | 2093902.85475 | 37.730457297459395 | -122.38069061399099 | (37.7304572974594, -122.380690613991) | |||
| 29768 | 29768 | 191907 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1195 La Salle Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6017354.46575 | 2094427.64232 | 37.7318726981701 | -122.382327789305 | (37.7318726981701, -122.382327789305) | |||
| 29839 | 29839 | 191883 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1190 La Salle Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 4ft | 6017587.33306 | 2094052.1604900002 | 37.730854558576496 | -122.381496607983 | (37.7308545585765, -122.381496607983) | |||
| 29965 | 29965 | 223938 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 680 Ogden Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6007710.43222 | 2096117.68841 | 37.735975788442396 | -122.41578895281602 | (37.7359757884424, -122.415788952816) | |||
| 29980 | 29980 | 191882 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1190 La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6017584.53768 | 2094069.90933 | 37.730903139072204 | -122.381507505984 | (37.7309031390722, -122.381507505984) | |||
| 30141 | 30141 | 42966 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 160 Belgrave Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2000 12:00:00 AM | Permit Number 42854 | 5997814.60948514 | 2104925.35351079 | 37.75959819679839 | -122.45063741216002 | (37.7595981967984, -122.45063741216) | |||
| 30464 | 30464 | 126590 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1697 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6006724.680980001 | 2116351.61631 | 37.791477944987896 | -122.42063301249901 | (37.7914779449879, -122.420633012499) | |||
| 30876 | 30876 | 37950 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 609 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 17 | Permit Number 40190 | 6013298.71774 | 2104246.1656 | 37.7586074292188 | -122.397037638472 | (37.7586074292188, -122.397037638472) | |
| 31029 | 31029 | 223935 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 111 Surrey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6002262.24862 | 2096228.5508700002 | 37.7359724051861 | -122.434633403615 | (37.7359724051861, -122.434633403615) | |||
| 31274 | 31274 | 209156 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 180 Madrone Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5992579.721969999 | 2097988.26683 | 37.7402497112547 | -122.468237451412 | (37.7402497112547, -122.468237451412) | |||
| 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) | |||
| 31782 | 31782 | 223948 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 469 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6003275.133640001 | 2103282.37568 | 37.755398015022 | -122.43163490472601 | (37.755398015022, -122.431634904726) | |||
| 32610 | 32610 | 176356 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 450 Italy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 2ft | 6001754.19818 | 2089213.77814 | 37.716682575925 | -122.43588817192101 | (37.716682575925, -122.435888171921) | |||
| 32905 | 32905 | 191914 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1197 La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6017038.90107 | 2094607.8859400002 | 37.73235017612 | -122.383431315903 | (37.73235017612, -122.383431315903) | |||
| 33413 | 33413 | 191913 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1195 La Salle Ave | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6017141.57749 | 2094559.46795 | 37.7322229040473 | -122.383072967557 | (37.7322229040473, -122.383072967557) | |||
| 33569 | 33569 | 209056 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1364 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 2ft | 5992426.38178 | 2106168.37832 | 37.7627013248255 | -122.469362904392 | (37.7627013248255, -122.469362904392) | |||
| 33921 | 33921 | 209055 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1701 Irving St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 5990354.8517 | 2106504.69261 | 37.7635048250025 | -122.476552083032 | (37.7635048250025, -122.476552083032) | |||
| 33999 | 33999 | 191871 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1196 La Salle Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6017366.50596 | 2094360.99224 | 37.73169035522479 | -122.382281528172 | (37.7316903552248, -122.382281528172) | |||
| 34411 | 34411 | 199336 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 15 Beatrice Ln | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6017966.39006 | 2094043.2312 | 37.7308509612846 | -122.38018551245399 | (37.7308509612846, -122.380185512454) | |||
| 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) | |||
| 35740 | 35740 | 223964 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 90 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6001033.19206 | 2105884.60415 | 37.7624157676075 | -122.439574740289 | (37.7624157676075, -122.439574740289) | |||
| 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) | |||
| 35908 | 35908 | 192005 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1241 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6017726.88625 | 2093915.31646 | 37.7304865155426 | -122.38100463475901 | (37.7304865155426, -122.381004634759) | |||
| 35963 | 35963 | 140902 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2301 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6000347.067000001 | 2113317.3521 | 37.782785144864 | -122.442481446452 | (37.782785144864, -122.442481446452) | |||
| 36064 | 36064 | 73981 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1020 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1988 12:00:00 AM | 22 | 6007232.56543 | 2114727.7662400003 | 37.7870478630276 | -122.418760525075 | (37.7870478630276, -122.418760525075) | ||
| 36246 | 36246 | 224308 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 321 Fair Oaks St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6005492.11509 | 2101727.90157 | 37.7512552025777 | -122.42385737251499 | (37.7512552025777, -122.423857372515) | |||
| 36637 | 36637 | 192000 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1301 Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 3ft | 6017496.52836 | 2093947.2221900001 | 37.7305614047807 | -122.381803241742 | (37.7305614047807, -122.381803241742) | |||
| 37328 | 37328 | 191887 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1189 La Salle Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6017601.124969999 | 2094139.4908099999 | 37.731095111950395 | -122.381454997274 | (37.7310951119504, -122.381454997274) | |||
| 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) | |||
| 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) | |||
| 37794 | 37794 | 191977 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1322 Hudson Ave | 43 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 3ft | 6017367.63238 | 2095116.6683200002 | 37.7337653546743 | -122.382330188681 | (37.7337653546743, -122.382330188681) | |||
| 37807 | 37807 | 32670 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 450 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 25 | Permit Number 37094 | 6011135.7894 | 2112024.86418 | 37.7798453222359 | -122.405065778479 | (37.7798453222359, -122.405065778479) | |
| 38065 | 38065 | 191955 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1322 Hudson Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6017686.38672 | 2094766.769 | 37.732822201480104 | -122.38120382830499 | (37.7328222014801, -122.381203828305) | |||
| 38175 | 38175 | 183909 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100 Santiago St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5988935.0449 | 2099710.5313 | 37.7447674238538 | -122.480965203869 | (37.7447674238538, -122.480965203869) | |||
| 38827 | 38827 | 191997 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1301 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Width 3ft | 6017389.868919999 | 2093956.67155 | 37.7305814605653 | -122.382172640078 | (37.7305814605653, -122.382172640078) | |||
| 40072 | 40072 | 37951 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 609 Connecticut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 12 | Permit Number 40190 | 6013298.65055 | 2104257.08873 | 37.7586374180095 | -122.397038636728 | (37.7586374180095, -122.397038636728) | |
| 40152 | 40152 | 223947 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 4261 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001509.65338 | 2101728.3731 | 37.7510308684778 | -122.437629173946 | (37.7510308684778, -122.437629173946) | |||
| 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) | |||
| 40220 | 40220 | 223962 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 393 Cumberland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6003123.78162 | 2104447.14367 | 37.7585876099598 | -122.432241505563 | (37.7585876099598, -122.432241505563) | |||
| 40457 | 40457 | 224327 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 147 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5997757.791 | 2106766.0657599997 | 37.764649075606705 | -122.450966650497 | (37.7646490756067, -122.450966650497) | |||
| 40488 | 40488 | 32598 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1488 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1996 12:00:00 AM | 10 | Permit Number 770751 | 5985603.1005 | 2105094.5695 | 37.759356274150704 | -122.492882766578 | (37.7593562741507, -122.492882766578) | ||
| 40533 | 40533 | 192001 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1395 Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6017559.96669 | 2093940.58979 | 37.73054669636571 | -122.38158346271001 | (37.7305466963657, -122.38158346271) | |||
| 40673 | 40673 | 191970 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1322 Hudson Ave | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6017432.113390001 | 2095036.9566 | 37.7335500434817 | -122.382101713228 | (37.7335500434817, -122.382101713228) | |||
| 40833 | 40833 | 191885 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1190 La Salle Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 3ft | 6017587.790709999 | 2094017.9071400003 | 37.7307605308653 | -122.381492644674 | (37.7307605308653, -122.381492644674) | |||
| 40959 | 40959 | 191886 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1189 La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6017618.3449 | 2094055.2465 | 37.7308647442976 | -122.38138960844 | (37.7308647442976, -122.38138960844) | |||
| 41202 | 41202 | 191993 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1395 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 3ft | 6017281.31768 | 2093927.6967 | 37.7304959053633 | -122.382545906371 | (37.7304959053633, -122.382545906371) | |||
| 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) | ||
| 41491 | 41491 | 176355 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 450 Italy Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6001789.17934 | 2089190.90398 | 37.7166217556775 | -122.435765623984 | (37.7166217556775, -122.435765623984) | |||
| 41796 | 41796 | 126583 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2626 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5999651.95245 | 2117866.72111 | 37.7952368746476 | -122.44521342838101 | (37.7952368746476, -122.445213428381) | |||
| 41800 | 41800 | 137854 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 411 Austin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6005199.1009 | 2115273.8946 | 37.788432693763795 | -122.425834752578 | (37.7884326937638, -122.425834752578) | |||
| 41911 | 41911 | 191934 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1333 Hudson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6017770.61427 | 2094662.9626799999 | 37.732541818939204 | -122.38090541525699 | (37.7325418189392, -122.380905415257) |
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");