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 ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11230 | 11230 | 27210 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 302 Silver Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/2000 12:00:00 AM | 3 | 3X3 | 6003698.299930001 | 2093465.5644 | 37.728467287514206 | -122.42947142096901 | (37.7284672875142, -122.429471420969) | ||
| 71455 | 71455 | 175779 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 302 Silver Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003783.14523 | 2093465.1437900001 | 37.728470936062706 | -122.429178076504 | (37.7284709360627, -122.429178076504) | |||
| 10628 | 10628 | 27211 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 302 Silver Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1999 12:00:00 AM | 6 | 3X3 | 6003731.93996 | 2093466.46517 | 37.7284716654181 | -122.429355189899 | (37.7284716654181, -122.429355189899) | ||
| 165500 | 165500 | 175780 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 302 Silver Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003848.49776 | 2093464.0621200001 | 37.728471665422504 | -122.4289520724 | (37.7284716654225, -122.4289520724) | |||
| 11548 | 11548 | 27209 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 302 Silver Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1999 12:00:00 AM | 6 | 3X3 | 6003678.0618199995 | 2093467.5761400003 | 37.728471665429396 | -122.42954152854401 | (37.7284716654294, -122.429541528544) | ||
| 11894 | 11894 | 27208 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 302 Silver Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1999 12:00:00 AM | 6 | 3X3 | 6003655.1292 | 2093468.31467 | 37.7284723947828 | -122.429620860416 | (37.7284723947828, -122.429620860416) | ||
| 10857 | 10857 | 27206 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 302 Silver Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/28/2012 12:00:00 AM | 3 | 3X3 | 6003601.03384 | 2093471.82188 | 37.7284789616114 | -122.429808120849 | (37.7284789616114, -122.429808120849) | ||
| 11918 | 11918 | 27214 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 418 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1999 12:00:00 AM | 6 | 3X3 | 6004063.83311 | 2093462.31817 | 37.7284790632589 | -122.428207522784 | (37.7284790632589, -122.428207522784) | ||
| 10380 | 10380 | 27204 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 302 Silver Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2005 12:00:00 AM | 3 | 3X3 | 6003546.09454 | 2093473.22062 | 37.728479690960796 | -122.429998148515 | (37.7284796909608, -122.429998148515) | ||
| 10845 | 10845 | 27213 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 408 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1999 12:00:00 AM | 6 | 3X3 | 6003994.27009 | 2093465.08607 | 37.728482727073995 | -122.428448202938 | (37.728482727074, -122.428448202938) | ||
| 11852 | 11852 | 27203 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 302 Silver Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2001 12:00:00 AM | 6 | 3X3 | 6003520.15249 | 2093475.1012 | 37.7284833853765 | -122.43008796558901 | (37.7284833853765, -122.430087965589) | ||
| 12768 | 12768 | 27200 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 302 Silver Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2005 12:00:00 AM | 3 | 3X3 | 6003430.014219999 | 2093478.3653900002 | 37.728487242572605 | -122.430399810923 | (37.7284872425726, -122.430399810923) | ||
| 158669 | 158669 | 175791 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 223 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6009517.433730001 | 2093353.53583 | 37.7284874341444 | -122.409346391343 | (37.7284874341444, -122.409346391343) | |||
| 11632 | 11632 | 27199 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 302 Silver Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1999 12:00:00 AM | 3 | 3X3 | 6003401.87305 | 2093484.5761900002 | 37.7285027019175 | -122.43049753933998 | (37.7285027019175, -122.43049753934) | ||
| 11345 | 11345 | 27198 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 302 Silver Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1999 12:00:00 AM | 3 | 3X3 | 6003379.2285400005 | 2093490.3772 | 37.7285173473825 | -122.43057623633001 | (37.7285173473825, -122.43057623633) | ||
| 11092 | 11092 | 27197 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 302 Silver Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1999 12:00:00 AM | 3 | 3X3 | 6003357.925480001 | 2093496.2985900003 | 37.72853239932861 | -122.43065030447501 | (37.7285323993286, -122.430650304475) | ||
| 10875 | 10875 | 27118 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 488 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/1999 12:00:00 AM | 6 | 3X3 | 6004485.4929 | 2093473.96445 | 37.7285348904523 | -122.426750651627 | (37.7285348904523, -122.426750651627) | ||
| 80831 | 80831 | 26977 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 526 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/08/1999 12:00:00 AM | 6 | 3X3 | 6004737.76851 | 2093468.91574 | 37.728535287917 | -122.425878161452 | (37.728535287917, -122.425878161452) | ||
| 61855 | 61855 | 175792 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 223 Holyoke St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6009511.22188 | 2093372.0739 | 37.728537987719605 | -122.409369173844 | (37.7285379877196, -122.409369173844) | |||
| 10985 | 10985 | 27196 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 302 Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2001 12:00:00 AM | 3 | 3X3 | 6003338.54684 | 2093501.7358400002 | 37.7285462309168 | -122.430717685294 | (37.7285462309168, -122.430717685294) | ||
| 12322 | 12322 | 27195 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 302 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2001 12:00:00 AM | 3 | 3X3 | 6003315.89626 | 2093507.2409400002 | 37.728560063388294 | -122.430796382249 | (37.7285600633883, -122.430796382249) | ||
| 11624 | 11624 | 27194 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 302 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2001 12:00:00 AM | 6 | 3X3 | 6003295.095930001 | 2093512.42424 | 37.7285731170511 | -122.430868659863 | (37.7285731170511, -122.430868659863) | ||
| 176001 | 176001 | 175793 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 223 Holyoke St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6009507.12766 | 2093386.74095 | 37.7285780309381 | -122.409384362505 | (37.7285780309381, -122.409384362505) | |||
| 12696 | 12696 | 27224 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 367 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1999 12:00:00 AM | 3 | 3X3 | 6003787.64028 | 2093509.2466099998 | 37.728592287005604 | -122.429165680266 | (37.7285922870056, -122.429165680266) | ||
| 13092 | 13092 | 27221 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 385 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1999 12:00:00 AM | 10 | 3x3 | 6003913.32371 | 2093508.9041799998 | 37.7285984608493 | -122.428731161129 | (37.7285984608493, -122.428731161129) | ||
| 12660 | 12660 | 27219 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 391 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/1999 12:00:00 AM | 6 | 3X3 | 6003983.54515 | 2093507.70675 | 37.728599147032 | -122.428488316285 | (37.728599147032, -122.428488316285) | ||
| 12081 | 12081 | 27218 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 393 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/10/1999 12:00:00 AM | 6 | 3x3 | 6004009.64112 | 2093507.9183200002 | 37.728601204683706 | -122.42839811609699 | (37.7286012046837, -122.428398116097) | ||
| 159078 | 159078 | 175794 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 223 Holyoke St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6009502.30517 | 2093401.60497 | 37.7286185741876 | -122.409402082759 | (37.7286185741876, -122.409402082759) | |||
| 50086 | 50086 | 113271 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1321 Revere Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/2015 12:00:00 AM | Permit Number 774420 | 6016529.9 | 2093260.0 | 37.7286210040554 | -122.38509718743299 | (37.7286210040554, -122.385097187433) | ||||
| 10789 | 10789 | 27116 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 431 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/2000 12:00:00 AM | 3 | 3X3 | 6004280.51311 | 2093512.4294900002 | 37.7286289154695 | -122.42746201715599 | (37.7286289154695, -122.427462017156) | ||
| 11914 | 11914 | 27040 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 590 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1999 12:00:00 AM | 6 | 3X3 | 6005314.150169999 | 2093510.97607 | 37.728683332565396 | -122.423888566416 | (37.7286833325654, -122.423888566416) | ||
| 12561 | 12561 | 27049 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 910 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/1999 12:00:00 AM | 6 | 3x3 | 6007348.52678 | 2093482.2197099999 | 37.7287190140661 | -122.41685354777701 | (37.7287190140661, -122.416853547777) | ||
| 173434 | 173434 | 47219 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 102 Colby St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 6 | Permit Number 45167 | 6008176.9578 | 2093476.05572 | 37.7287486521041 | -122.413989164793 | (37.7287486521041, -122.413989164793) | |
| 72258 | 72258 | 47216 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 102 Colby St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 4 | Permit Number 45167 | 6008173.05313 | 2093488.0369799999 | 37.728781330768896 | -122.41400351077299 | (37.7287813307689, -122.414003510773) | |
| 13190 | 13190 | 27285 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 670 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1999 12:00:00 AM | 3 | 3X3 | 6005819.54085 | 2093537.91486 | 37.728785819299105 | -122.422143310586 | (37.7287858192991, -122.422143310586) | ||
| 133403 | 133403 | 175786 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 913 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008114.21781 | 2093492.5462599997 | 37.728790407640794 | -122.41420722787599 | (37.7287904076408, -122.414207227876) | |||
| 135580 | 135580 | 175787 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 913 Silliman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008123.2351400005 | 2093495.1719799999 | 37.7287981238093 | -122.414176239965 | (37.7287981238093, -122.414176239965) | |||
| 184588 | 184588 | 175788 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 913 Silliman St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008132.91971 | 2093497.9491400002 | 37.7288062932694 | -122.414142956056 | (37.7288062932694, -122.414142956056) | |||
| 12570 | 12570 | 27105 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 595 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1999 12:00:00 AM | 3 | 3X3 | 6005329.57476 | 2093556.08719 | 37.728808068530796 | -122.42383844898701 | (37.7288080685308, -122.423838448987) | ||
| 10695 | 10695 | 27041 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 708 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1999 12:00:00 AM | 7 | 6006055.4905900005 | 2093548.93813 | 37.728829392352 | -122.42132839800199 | (37.728829392352, -122.421328398002) | |||
| 98121 | 98121 | 47220 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 102 Colby St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45167 | 6008165.27144692 | 2093507.30784615 | 37.7288338073717 | -122.414031775389 | (37.7288338073717, -122.414031775389) | ||
| 115878 | 115878 | 47217 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 102 Colby St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45167 | 6008165.27144692 | 2093507.30784615 | 37.7288338073717 | -122.414031775389 | (37.7288338073717, -122.414031775389) | ||
| 120251 | 120251 | 47218 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 102 Colby St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45167 | 6008165.27144692 | 2093507.30784615 | 37.7288338073717 | -122.414031775389 | (37.7288338073717, -122.414031775389) | ||
| 124336 | 124336 | 47221 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 102 Colby St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45167 | 6008165.27144692 | 2093507.30784615 | 37.7288338073717 | -122.414031775389 | (37.7288338073717, -122.414031775389) | ||
| 11796 | 11796 | 27192 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 284 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1999 12:00:00 AM | 6 | 2X3 | 6003080.50306 | 2093615.49168 | 37.7288439559672 | -122.431617874266 | (37.7288439559672, -122.431617874266) | ||
| 11427 | 11427 | 27057 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 945 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/25/1999 12:00:00 AM | 7 | 2X3 | 6007415.89764 | 2093543.05958 | 37.72888985646029 | -122.416624950003 | (37.7288898564603, -122.416624950003) | ||
| 12957 | 12957 | 27096 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 707 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/2006 12:00:00 AM | 3 | 3X3 | 6006037.723730001 | 2093592.8940700002 | 37.7289490840269 | -122.42139293964199 | (37.7289490840269, -122.421392939642) | ||
| 78376 | 78376 | 36468 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1469 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39366 | 5995883.06149021 | 2093810.4895036 | 37.728968784247705 | -122.456513863949 | (37.7289687842477, -122.456513863949) | ||
| 89646 | 89646 | 27087 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 743X Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1999 12:00:00 AM | 6 | 2X3 | 6006221.2435099995 | 2093597.03752 | 37.7289708064437 | -122.420758791245 | (37.7289708064437, -122.420758791245) | ||
| 122819 | 122819 | 27088 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 743X Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1999 12:00:00 AM | 6 | 2X3 | 6006210.7557 | 2093597.31773 | 37.728970984710294 | -122.42079506833099 | (37.7289709847103, -122.420795068331) | ||
| 150799 | 150799 | 175784 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 741 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6006219.087180001 | 2093598.2968400002 | 37.7289741427237 | -122.420766335217 | (37.7289741427237, -122.420766335217) | |||
| 176762 | 176762 | 175785 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 741 Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6006201.21806 | 2093598.82119 | 37.7289745752989 | -122.420828147413 | (37.7289745752989, -122.420828147413) | |||
| 124216 | 124216 | 27086 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 743X Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1999 12:00:00 AM | 6 | 2X3 | 6006263.01382 | 2093613.9745099999 | 37.7290196659204 | -122.42061558974702 | (37.7290196659204, -122.420615589747) | ||
| 10587 | 10587 | 27191 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 270 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1999 12:00:00 AM | 6 | 2X3 | 6002970.12798 | 2093687.91706 | 37.729036562883 | -122.43200461784299 | (37.729036562883, -122.432004617843) | ||
| 25555 | 25555 | 175783 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 771 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006465.53434 | 2093625.53998 | 37.729062833884605 | -122.419916279827 | (37.7290628338846, -122.419916279827) | |||
| 12742 | 12742 | 27190 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 266 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/08/1999 12:00:00 AM | 6 | 2X3 | 6002951.03979 | 2093700.24177 | 37.729069321573604 | -122.432071486902 | (37.7290693215736, -122.432071486902) | ||
| 185696 | 185696 | 175790 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 79 Colby St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6008193.10922 | 2093597.69816 | 37.7290835632519 | -122.413941929669 | (37.7290835632519, -122.413941929669) | |||
| 27115 | 27115 | 175782 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 769 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006531.05237 | 2093633.80708 | 37.729089224484795 | -122.419690364741 | (37.7290892244848, -122.419690364741) | |||
| 136571 | 136571 | 175789 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1038 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007776.24891 | 2093611.0245700001 | 37.7290967338157 | -122.415383996168 | (37.7290967338157, -122.415383996168) | |||
| 10609 | 10609 | 27189 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 262 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1999 12:00:00 AM | 6 | 2X3 | 6002929.54622 | 2093714.9160799999 | 37.729108395319706 | -122.432146839331 | (37.7291083953197, -122.432146839331) | ||
| 86882 | 86882 | 27082 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 799X Silver Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2000 12:00:00 AM | 6 | 2X3 | 6006577.59669 | 2093640.7294700001 | 37.7291108536609 | -122.419529947915 | (37.7291108536609, -122.419529947915) | ||
| 100453 | 100453 | 27079 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 799X Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/26/1999 12:00:00 AM | 8 | 2X3 | 6006577.59669 | 2093640.7294700001 | 37.7291108536609 | -122.419529947915 | (37.7291108536609, -122.419529947915) | ||
| 143415 | 143415 | 27238 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 275 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/26/1999 12:00:00 AM | 6 | 3X3 | 6003040.40904 | 2093714.4077 | 37.729113284389 | -122.43176354159401 | (37.729113284389, -122.431763541594) | ||
| 73669 | 73669 | 204638 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 181 Staples Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 1ft | 5998850.558130001 | 2093801.2422 | 37.729113316421106 | -122.44625438283701 | (37.7291133164211, -122.446254382837) | |||
| 32358 | 32358 | 204636 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 181 Staples Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 1ft | 5998882.21711 | 2093801.6387 | 37.729116213139704 | -122.446144964113 | (37.7291162131397, -122.446144964113) | |||
| 63144 | 63144 | 204637 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 181 Staples Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 1ft | 5998869.73196 | 2093802.12764 | 37.7291168426482 | -122.446188161278 | (37.7291168426482, -122.446188161278) | |||
| 105413 | 105413 | 101601 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 180X Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 2x2 | 5998894.7 | 2093810.1 | 37.7291401587489 | -122.446102418286 | (37.7291401587489, -122.446102418286) | |||
| 113526 | 113526 | 101605 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 180X Staples Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 2x2 | 5998894.7 | 2093810.1 | 37.7291401587489 | -122.446102418286 | (37.7291401587489, -122.446102418286) | |||
| 125961 | 125961 | 101604 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 180X Staples Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 2x2 | 5998894.7 | 2093810.1 | 37.7291401587489 | -122.446102418286 | (37.7291401587489, -122.446102418286) | |||
| 12234 | 12234 | 27239 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 267 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/19/2004 12:00:00 AM | 3 | 3X3 | 6002994.26296 | 2093731.2602 | 37.7291569416186 | -122.431924275083 | (37.7291569416186, -122.431924275083) | ||
| 115613 | 115613 | 27054 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1048X Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/1999 12:00:00 AM | 6 | 3X3 | 6007856.910540001 | 2093638.04837 | 37.7291754686195 | -122.41510705369 | (37.7291754686195, -122.41510705369) | ||
| 10716 | 10716 | 27187 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 250 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/2002 12:00:00 AM | 6 | 2X3 | 6002862.24087 | 2093754.97277 | 37.7292145657007 | -122.43238237894501 | (37.7292145657007, -122.432382378945) | ||
| 13026 | 13026 | 27186 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 246 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1999 12:00:00 AM | 6 | 2x3 | 6002844.3159300005 | 2093767.7045599998 | 37.729248507888606 | -122.432445255941 | (37.7292485078886, -122.432445255941) | ||
| 104783 | 104783 | 96999 | Property Tree 7 | Callistemon viminalis :: Weeping Bottlebrush 20 | 195A Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 125835 | 125835 | 97004 | Property Tree 7 | Callistemon viminalis :: Weeping Bottlebrush 20 | 195A Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 12304 | 12304 | 27185 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 238 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1999 12:00:00 AM | 6 | 2X3 | 6002801.11945 | 2093793.8954 | 37.7293179724305 | -122.43259645987101 | (37.7293179724305, -122.432596459871) | ||
| 12164 | 12164 | 27184 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 234 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1999 12:00:00 AM | 6 | 2x3 | 6002780.32065 | 2093807.2617400002 | 37.7293534938515 | -122.432669317552 | (37.7293534938515, -122.432669317552) | ||
| 11022 | 11022 | 27183 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 218 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1999 12:00:00 AM | 6 | 2x3 | 6002694.31138 | 2093864.23527 | 37.729505052106795 | -122.43297072801701 | (37.7295050521068, -122.432970728017) | ||
| 2817 | 2817 | 253222 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 148 Felton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6010428.10303 | 2093767.62468 | 37.729675416078294 | -122.406227307752 | (37.7296754160783, -122.406227307752) | ||||
| 2839 | 2839 | 253221 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 148 Felton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6010428.10303 | 2093767.62468 | 37.729675416078294 | -122.406227307752 | (37.7296754160783, -122.406227307752) | ||||
| 11557 | 11557 | 27528 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1136 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/25/2002 12:00:00 AM | 3 | 6008310.55132 | 2093825.05625 | 37.729714434952506 | -122.413551995327 | (37.7297144349525, -122.413551995327) | |||
| 145192 | 145192 | 33403 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 384 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/2003 12:00:00 AM | Permit Number 46425 | 5992447.80765363 | 2094243.66151518 | 37.729960344135996 | -122.468421188533 | (37.729960344136, -122.468421188533) | ||
| 12154 | 12154 | 26999 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1200 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/1999 12:00:00 AM | 6 | 3X3 | 6008714.80501 | 2094009.36438 | 37.7302431967539 | -122.41216746208401 | (37.7302431967539, -122.412167462084) | ||
| 10976 | 10976 | 26998 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1223 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/25/1999 12:00:00 AM | 6 | 3X3 | 6008728.29906 | 2094063.8664 | 37.7303936047791 | -122.41212466153499 | (37.7303936047791, -122.412124661535) | ||
| 10667 | 10667 | 26997 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1231 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/1999 12:00:00 AM | 6 | 3X3 | 6008770.22229 | 2094084.7874099999 | 37.7304534015961 | -122.41198120438801 | (37.7304534015961, -122.411981204388) | ||
| 11300 | 11300 | 26996 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1239 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2000 12:00:00 AM | 3 | 3X3 | 6008815.333330001 | 2094106.20179 | 37.730514731765396 | -122.41182676109399 | (37.7305147317654, -122.411826761094) | ||
| 177360 | 177360 | 95997 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 56 Neptune St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767648 | 6013070.55126 | 2094035.71681 | 37.730558997287396 | -122.39711080912501 | (37.7305589972874, -122.397110809125) |
| 42503 | 42503 | 204633 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 451 Hearst Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5998410.37704 | 2094369.2089900002 | 37.7306476704498 | -122.447816990888 | (37.7306476704498, -122.447816990888) | |||
| 146446 | 146446 | 204634 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 451 Hearst Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5998426.7778900005 | 2094369.13977 | 37.7306484177936 | -122.44776028591002 | (37.7306484177936, -122.44776028591) | |||
| 170117 | 170117 | 204631 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 451 Hearst Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5998374.865180001 | 2094370.4925900002 | 37.7306491651061 | -122.447939852652 | (37.7306491651061, -122.447939852652) | |||
| 178908 | 178908 | 204632 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 451 Hearst Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5998393.17334 | 2094370.1114700001 | 37.7306491651244 | -122.447876531394 | (37.7306491651244, -122.447876531394) | |||
| 151548 | 151548 | 204635 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 458 Hearst Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998373.34514 | 2094412.4750299999 | 37.73076435209 | -122.447948129107 | (37.73076435209, -122.447948129107) | ||||
| 72610 | 72610 | 204630 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 304 Gennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 5997471.23605 | 2094490.2943 | 37.7309264189197 | -122.45107245665501 | (37.7309264189197, -122.451072456655) | |||
| 87714 | 87714 | 27034 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1300X Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/1999 12:00:00 AM | 6 | 3X3 | 6009318.030669999 | 2094252.37415 | 37.7309442788115 | -122.41009917146799 | (37.7309442788115, -122.410099171468) | ||
| 11657 | 11657 | 27033 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1300X Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/1999 12:00:00 AM | 6 | 3X3 | 6009267.3963 | 2094255.34405 | 37.730949595331296 | -122.410274433211 | (37.7309495953313, -122.410274433211) | ||
| 93655 | 93655 | 97046 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1590X SHAFTER AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6014988.0 | 2094146.0 | 37.7309683687499 | -122.390489552503 | (37.7309683687499, -122.390489552503) | |||
| 92699 | 92699 | 97048 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1590X Shafter Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6014988.7 | 2094146.3 | 37.7309692313217 | -122.39048715342 | (37.7309692313217, -122.39048715342) | |||
| 109764 | 109764 | 97047 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1590X Shafter Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6014988.7 | 2094146.3 | 37.7309692313217 | -122.39048715342 | (37.7309692313217, -122.39048715342) | |||
| 148378 | 148378 | 31102 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 215 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 6 | Permit Number 34832 | 6000072.59523 | 2094462.74015 | 37.7309993521219 | -122.44207717762801 | (37.7309993521219, -122.442077177628) | |
| 12971 | 12971 | 26990 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1305 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/1999 12:00:00 AM | 6 | 3X3 | 6009240.62739 | 2094292.02443 | 37.731048811250794 | -122.41036956712601 | (37.7310488112508, -122.410369567126) |
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");