Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 420 | 420 | 54426 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 770 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1973 12:00:00 AM | 15 | 3x3 | Permit Number 12242 | 6012397.0815 | 2104349.75534 | 37.758841631549394 | -122.400163199892 | (37.7588416315494, -122.400163199892) | |
| 2997 | 2997 | 246011 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 609 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1988 12:00:00 AM | 8 | Width 0ft | Permit Number 25501 | 5998952.4081 | 2108635.9977 | 37.7698517546883 | -122.446969376408 | (37.7698517546883, -122.446969376408) | |
| 3320 | 3320 | 56733 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1583 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Permit Number 780681 | 6015469.0433 | 2095825.5988 | 37.7356068823061 | -122.388943710821 | (37.7356068823061, -122.388943710821) | |||
| 3796 | 3796 | 182316 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2726 Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2001 12:00:00 AM | 3 | Width 0ft | Permit Number 43905 | 5986380.5744 | 2105064.6172 | 37.759319468361 | -122.490191716108 | (37.759319468361, -122.490191716108) | |
| 4156 | 4156 | 213178 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 629 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2017 08:23:00 AM | 3 | Width 3ft | Permit Number 20774 | 5994856.22066 | 2090552.89382 | 37.7199652039099 | -122.45982783161502 | (37.7199652039099, -122.459827831615) | |
| 4444 | 4444 | 24256 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 203 Willow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2014 12:00:00 AM | 3 | 2x3 | 6006439.8092 | 2113362.67149 | 37.783254981274204 | -122.421406308981 | (37.7832549812742, -122.421406308981) | ||
| 4793 | 4793 | 12272 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 700X Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/1997 12:00:00 AM | 3 | 3X3 | 6004950.3992 | 2111308.9655 | 37.7775319231116 | -122.426412801229 | (37.7775319231116, -122.426412801229) | ||
| 5163 | 5163 | 12318 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 999 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/1997 12:00:00 AM | 6 | 4X4 | 6004783.3056 | 2112237.6551 | 37.7800724294036 | -122.427056996678 | (37.7800724294036, -122.427056996678) | ||
| 5538 | 5538 | 27609 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2695 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2000 12:00:00 AM | 3 | 3x3 | 6001941.56922 | 2115683.47507 | 37.7893726707572 | -122.437134613375 | (37.7893726707572, -122.437134613375) | ||
| 5901 | 5901 | 13142 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1799 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1993 12:00:00 AM | 70 | 3X3 | 6003833.3629 | 2119660.0062 | 37.8003985594643 | -122.43087313241999 | (37.8003985594643, -122.43087313242) | ||
| 7114 | 7114 | 45767 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 99 Blake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/02/2002 12:00:00 AM | 5 | 3x3 | Permit Number 44690 | 5997811.6954 | 2113198.143 | 37.782312986330794 | -122.45124412099399 | (37.7823129863308, -122.451244120994) |
| 7399 | 7399 | 45765 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 99 Blake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/2002 12:00:00 AM | 5 | 3x3 | Permit Number 44690 | 5997815.0796 | 2113173.4382 | 37.782245347199996 | -122.451230630986 | (37.7822453472, -122.451230630986) | |
| 7463 | 7463 | 52815 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2760 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773616 | 6000112.35725 | 2118047.78661 | 37.7957603016641 | -122.44363337348999 | (37.7957603016641, -122.44363337349) | |
| 7980 | 7980 | 12325 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1015 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/1997 12:00:00 AM | 6 | 4X4 | 6004759.9403 | 2112401.4167 | 37.7805207570776 | -122.427149495677 | (37.7805207570776, -122.427149495677) | ||
| 8678 | 8678 | 26493 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 519 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004978.6865 | 2110816.0585 | 37.776180120030205 | -122.42627984394699 | (37.7761801200302, -122.426279843947) | |||
| 9115 | 9115 | 90912 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 545 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5993886.17439 | 2110710.21085 | 37.775256248873895 | -122.464643860229 | (37.7752562488739, -122.464643860229) | ||
| 9171 | 9171 | 26893 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1275X HUDSON AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/1999 12:00:00 AM | 6 | 3X4 | 6017281.0 | 2095243.0 | 37.734107450868 | -122.38263849321599 | (37.734107450868, -122.382638493216) | ||
| 9226 | 9226 | 10863 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1275X HUDSON AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2016 12:00:00 AM | 6 | 3X4 | 6017281.0 | 2095243.0 | 37.734107450868 | -122.38263849321599 | (37.734107450868, -122.382638493216) | ||
| 9360 | 9360 | 3447 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 26 Cameo Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 5999491.3304257 | 2099768.5267533 | 37.7455346409258 | -122.44446787703998 | (37.7455346409258, -122.44446787704) | |||
| 9446 | 9446 | 10864 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1275X HUDSON AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/19/1993 12:00:00 AM | 6 | 3X4 | 6017281.0 | 2095243.0 | 37.734107450868 | -122.38263849321599 | (37.734107450868, -122.382638493216) | ||
| 10112 | 10112 | 5081 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2562 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3X3 | 6002249.017000001 | 2096934.71698 | 37.737910623162705 | -122.434729631968 | (37.7379106231627, -122.434729631968) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 11500 | 11500 | 66889 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 562 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/1991 12:00:00 AM | 8 | 3x3 | Permit Number 30203 | 6003132.96801 | 2090225.04515 | 37.7195375196183 | -122.43119459394899 | (37.7195375196183, -122.431194593949) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 11744 | 11744 | 27020 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1495 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/1999 12:00:00 AM | 6 | 3X3 | 6010228.2725 | 2094648.6070599998 | 37.7320832276456 | -122.40698021658399 | (37.7320832276456, -122.406980216584) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 12327 | 12327 | 27038 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1346 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/2005 12:00:00 AM | 3 | 3X3 | 6009450.86564 | 2094320.46878 | 37.7311386966779 | -122.409644741423 | (37.7311386966779, -122.409644741423) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 12789 | 12789 | 27012 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1478 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/1999 12:00:00 AM | 6 | 3X3 | 6010237.54024 | 2094604.6047900002 | 37.731962925340206 | -122.40694507558099 | (37.7319629253402, -122.406945075581) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 13217 | 13217 | 27037 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1346 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/1999 12:00:00 AM | 6 | 3X3 | 6009433.39606 | 2094313.9953700001 | 37.731119943119296 | -122.409704680324 | (37.7311199431193, -122.409704680324) | ||
| 13832 | 13832 | 27154 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1700X Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/12/2001 12:00:00 AM | 6 | 3X3 | 6011126.61874 | 2095085.7194599998 | 37.7333336755986 | -122.403905168305 | (37.7333336755986, -122.403905168305) | ||
| 13949 | 13949 | 27171 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2206 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/1999 12:00:00 AM | 6 | 2X3 | 6012761.81609 | 2096197.8088200002 | 37.7364784617996 | -122.398329801495 | (37.7364784617996, -122.398329801495) | ||
| 13978 | 13978 | 27170 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2080 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/1999 12:00:00 AM | 6 | 2X3 | 6012569.10474 | 2096085.04169 | 37.7361580900166 | -122.398988178079 | (37.7361580900166, -122.398988178079) | ||
| 14213 | 14213 | 25940 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2018 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/2000 12:00:00 AM | 3 | 3x3 | 6012740.13667 | 2097232.43261 | 37.739318114344 | -122.398477333477 | (37.739318114344, -122.398477333477) | ||
| 14432 | 14432 | 27132 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2009 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/19/2004 12:00:00 AM | 3 | 2X3 | 6012226.6815599995 | 2095938.3676200002 | 37.735736266604704 | -122.40016178436501 | (37.7357362666047, -122.400161784365) | ||
| 14531 | 14531 | 25952 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2370 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1997 12:00:00 AM | 3 | 3X3 | 6011712.98649 | 2098000.83737 | 37.7413707152901 | -122.40208278929701 | (37.7413707152901, -122.402082789297) | ||
| 14877 | 14877 | 27134 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1941 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/2002 12:00:00 AM | 4 | 3X3 | 6011939.40312 | 2095757.43943 | 37.7352234533834 | -122.401142314262 | (37.7352234533834, -122.401142314262) | ||
| 14967 | 14967 | 27136 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1909 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/1999 12:00:00 AM | 7 | 2X3 | 6011799.55776 | 2095649.995 | 37.734920630966 | -122.40161826426599 | (37.734920630966, -122.401618264266) | ||
| 15119 | 15119 | 27174 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2300X Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/1999 12:00:00 AM | 6 | 2X3 | 6013069.06083 | 2096365.0106900001 | 37.7369546735192 | -122.397279240461 | (37.7369546735192, -122.397279240461) | ||
| 15299 | 15299 | 27175 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2300X Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/1999 12:00:00 AM | 6 | 2X3 | 6013102.951669999 | 2096377.5356599998 | 37.736990951255706 | -122.397162941913 | (37.7369909512557, -122.397162941913) | ||
| 15540 | 15540 | 27131 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2015 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/1999 12:00:00 AM | 6 | 2X3 | 6012250.55523 | 2095951.9003599999 | 37.735774755805295 | -122.400080193368 | (37.7357747558053, -122.400080193368) | ||
| 15856 | 15856 | 27155 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1700X Silver Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/29/2000 12:00:00 AM | 6 | 3X3 | 6011143.89147 | 2095098.83858 | 37.733370662922795 | -122.403846374205 | (37.7333706629228, -122.403846374205) | ||
| 16026 | 16026 | 27153 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1700X Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/12/2001 12:00:00 AM | 6 | 3X3 | 6011109.96837 | 2095074.7045 | 37.7333025005961 | -122.403961958687 | (37.7333025005961, -122.403961958687) | ||
| 16142 | 16142 | 27165 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1836 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/1999 12:00:00 AM | 6 | 3X3 | 6011599.21005 | 2095442.31315 | 37.7343391985891 | -122.402296343211 | (37.7343391985891, -122.402296343211) | ||
| 16365 | 16365 | 27145 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1751 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1999 12:00:00 AM | 3 | 2X3 | 6011315.84096 | 2095284.6201400002 | 37.7338903847377 | -122.40326495802499 | (37.7338903847377, -122.403264958025) | ||
| 17274 | 17274 | 22551 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 33 Topaz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/1992 12:00:00 AM | 20 | 2X3 | 6001555.699019999 | 2098568.2188 | 37.74235645138 | -122.437243695762 | (37.74235645138, -122.437243695762) | ||
| 17603 | 17603 | 10401 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1360 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5999635.0074 | 2108810.0697 | 37.770368686739396 | -122.44462080278 | (37.7703686867394, -122.44462080278) | |||
| 17698 | 17698 | 2244 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 15X Brompton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002231.00143 | 2095678.63178 | 37.7344606799209 | -122.43470212621901 | (37.7344606799209, -122.434702126219) | |||
| 18373 | 18373 | 54772 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1446 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/1972 12:00:00 AM | 4x5 | Permit Number 10621 | 5994307.43834186 | 2105670.05162948 | 37.7614415732371 | -122.46282089526899 | (37.7614415732371, -122.462820895269) | ||
| 18758 | 18758 | 4194 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 3870 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004745.48765 | 2100483.94122 | 37.7477973974515 | -122.4263507348 | (37.7477973974515, -122.4263507348) | |||
| 19179 | 19179 | 96019 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 810 Jones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767661 | 6008769.0 | 2115301.0 | 37.7887082111555 | -122.413485341988 | (37.7887082111555, -122.413485341988) | |
| 19209 | 19209 | 7446 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2545 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6008276.38457 | 2103575.68647 | 37.7564855903503 | -122.414359757402 | (37.7564855903503, -122.414359757402) | |||
| 19229 | 19229 | 4867 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 35 Crags Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X2 | 6000770.192869999 | 2098181.8906900003 | 37.7412510011371 | -122.43993203733 | (37.7412510011371, -122.43993203733) | |||
| 20085 | 20085 | 4237 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4018 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6003765.90932 | 2100430.48709 | 37.747595203776 | -122.429734255035 | (37.747595203776, -122.429734255035) | |||
| 21278 | 21278 | 3458 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 58 Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1992 12:00:00 AM | 20 | 3X3 | 5999628.35603 | 2099484.01235 | 37.7447612502235 | -122.443973626603 | (37.7447612502235, -122.443973626603) | ||
| 21641 | 21641 | 22552 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 39 Topaz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/1992 12:00:00 AM | 20 | 2x3 | 6001599.33681 | 2098534.06318 | 37.7422651486201 | -122.43709036493 | (37.7422651486201, -122.43709036493) | ||
| 21739 | 21739 | 22825 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 80 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/04/1993 12:00:00 AM | 25 | 3X3 | 5999298.50958 | 2099073.67343 | 37.7436157369876 | -122.44508467424299 | (37.7436157369876, -122.445084674243) | ||
| 22257 | 22257 | 125 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1032 14th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/1990 12:00:00 AM | 18 | 3X3 | 6002008.22654 | 2107658.0827 | 37.767340750994 | -122.436329391899 | (37.767340750994, -122.436329391899) | ||
| 22702 | 22702 | 21528 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1300 Sutter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2007 12:00:00 AM | 3 | 4X4 | 6006219.829580001 | 2114935.40618 | 37.787560918141295 | -122.422279128893 | (37.7875609181413, -122.422279128893) | ||
| 26719 | 26719 | 44280 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1588 Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/2001 12:00:00 AM | 7 | Permit Number 43704 | 6014158.826330001 | 2095418.03078 | 37.734415072582 | -122.393445153596 | (37.734415072582, -122.393445153596) | ||
| 27183 | 27183 | 48442 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2399 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2002 12:00:00 AM | Permit Number 45814 | 6000698.38093235 | 2113767.30398552 | 37.784040615681 | -122.441298346596 | (37.784040615681, -122.441298346596) | |||
| 27384 | 27384 | 39767 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 476 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2000 12:00:00 AM | 3 | 2x2 | Permit Number 42916 | 6008173.90648 | 2113469.9166 | 37.7836470686025 | -122.41541460189899 | (37.7836470686025, -122.415414601899) |
| 29332 | 29332 | 61172 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 346 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 11 | Permit Number 27084 | 5989366.0565 | 2113024.18126 | 37.781348145965296 | -122.480449215491 | (37.7813481459653, -122.480449215491) | |
| 32793 | 32793 | 67326 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 714 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1992 12:00:00 AM | 12 | Permit Number 30809 | 5993329.61616 | 2111427.9815700003 | 37.7771949529998 | -122.466621290245 | (37.7771949529998, -122.466621290245) | |
| 35176 | 35176 | 43892 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1233 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2000 12:00:00 AM | 6 | Permit Number 43498 | 6009086.19652 | 2110571.7349400003 | 37.7757405834934 | -122.412053529658 | (37.7757405834934, -122.412053529658) |
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");