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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | ||||
80412 | 80412 | 99239 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 940 Laguna Honda Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/2012 12:00:00 AM | Permit Number 768814 | 5996167.3 | 2098870.1 | 37.7428775588654 | -122.45589685275 | (37.7428775588654, -122.45589685275) | ||||
90156 | 90156 | 104503 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 157 ALBION ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6005993.0 | 2106325.0 | 37.7639060282426 | -122.422451867395 | (37.7639060282426, -122.422451867395) | ||||
90159 | 90159 | 104807 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2069 GREEN ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6003141.4 | 2118171.7 | 37.796272826569705 | -122.433161198258 | (37.7962728265697, -122.433161198258) | ||||||
97552 | 97552 | 108723 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 764 Arkansas St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773103 | 6013016.81056 | 2103494.00722 | 37.7565264696642 | -122.39795984425301 | (37.7565264696642, -122.397959844253) | |
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) | |||||
127139 | 127139 | 108935 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 12X CAMP ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6005858.0 | 2106413.0 | 37.764140038871396 | -122.422925047265 | (37.7641400388714, -122.422925047265) | ||||
66 | 66 | 222538 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1 Newburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002556.19825 | 2099973.42317 | 37.746271638232 | -122.43388469462201 | (37.746271638232, -122.433884694622) | |||
385 | 385 | 251282 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1299x Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 04/07/2016 12:00:00 AM | 3x3 | 6017207.0 | 2095414.0 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | ||
392 | 392 | 251280 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1275x Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 03/11/2006 12:00:00 AM | 3x3 | 6017281.0 | 2095243.0 | 37.734107450868 | -122.38263849321599 | (37.734107450868, -122.382638493216) | ||
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) | |
1380 | 1380 | 251512 | Property Tree 7 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4116x 18th St | 1 | Back Yard : Yard 13 | Tree 1 | MTA 6 | 3x3 | 6002190.0 | 2105341.0 | 37.760988934022706 | -122.43553488468001 | (37.7609889340227, -122.43553488468) | ||||
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) | |||
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) | |
4201 | 4201 | 252891 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 300x Howth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 04:13:00 PM | 3 | 3x3 | 5997131.0 | 2090234.0 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | ||
4212 | 4212 | 204652 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 324 Howth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:45:00 PM | 3 | Width 3ft | 5997137.29551 | 2090290.56774 | 37.719375836806705 | -122.45192406695601 | (37.7193758368067, -122.451924066956) | ||
4291 | 4291 | 252895 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 790x Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:29:00 PM | 3 | 3x3 | 5997282.0 | 2090432.0 | 37.719772464034904 | -122.45143407539 | (37.7197724640349, -122.45143407539) | ||
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) | ||
4849 | 4849 | 253684 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 767 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009074.0 | 2092682.0 | 37.7266186845557 | -122.410831962563 | (37.7266186845557, -122.410831962563) | ||||
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) | ||
5700 | 5700 | 107235 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 786 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6008834.66692 | 2115296.44284 | 37.788699385205796 | -122.413257820814 | (37.7886993852058, -122.413257820814) | |||
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) |
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) | ||
10007 | 10007 | 99273 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2825 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | DPW for City Agency 2 | 02/01/2013 12:00:00 AM | 3 | 3x3 | 6002499.0 | 2095479.8 | 37.733929944538204 | -122.43376136145201 | (37.7339299445382, -122.433761361452) | |
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) | |||
10145 | 10145 | 173881 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1245 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996703.0 | 2107106.0 | 37.7655220059747 | -122.45463943175601 | (37.7655220059747, -122.454639431756) | ||||
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) | ||
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) | ||
10673 | 10673 | 121353 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1221 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/2016 12:00:00 AM | 3 | 3x3 | 5984567.3281 | 2106871.8527 | 37.76417557031971 | -122.496596073864 | (37.7641755703197, -122.496596073864) | ||
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) | ||
10826 | 10826 | 27011 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1468 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/02/1999 12:00:00 AM | 6 | 3X3 | 6010181.11487 | 2094586.49515 | 37.7319100425197 | -122.407138874981 | (37.7319100425197, -122.407138874981) | ||
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) | ||
10969 | 10969 | 26989 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1327 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/22/1999 12:00:00 AM | 6 | 3X3 | 6009306.59459 | 2094318.78355 | 37.7311259838562 | -122.41014339480101 | (37.7311259838562, -122.410143394801) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | |
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) | |||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
13269 | 13269 | 187626 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 298x Molimo Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5997428.0 | 2096652.0 | 37.7368594694916 | -122.451377782024 | (37.7368594694916, -122.451377782024) | ||||
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) | ||
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) | ||
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) | ||
15602 | 15602 | 101156 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1490X 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6013453.7614400005 | 2105247.5910900002 | 37.7613657542352 | -122.39657162148501 | (37.7613657542352, -122.396571621485) | |||
15677 | 15677 | 27163 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1824 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/02/1999 12:00:00 AM | 6 | 3X3 | 6011556.81745 | 2095410.2686400001 | 37.734248844606206 | -122.402440656527 | (37.7342488446062, -122.402440656527) | ||
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) | ||
16407 | 16407 | 97995 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1450 Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2016 12:00:00 AM | 3 | 3x3 | 6013004.40763 | 2106156.2643 | 37.7638357521307 | -122.398189511757 | (37.7638357521307, -122.398189511757) | ||
17253 | 17253 | 26483 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 148 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/2001 12:00:00 AM | 10 | 3X3 | 6001028.50664 | 2098685.10655 | 37.7426474144589 | -122.43907493846001 | (37.7426474144589, -122.43907493846) | ||
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) | |||
18107 | 18107 | 4392 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 25 Chilton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001719.13999 | 2095716.38889 | 37.734535279584605 | -122.43647449840799 | (37.7345352795846, -122.436474498408) | |||
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) | |||
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) | |||
20005 | 20005 | 9345 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 216 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/03/1992 12:00:00 AM | 25 | 2X2 | 6000780.1302 | 2098439.42056 | 37.7419586830354 | -122.439916138241 | (37.7419586830354, -122.439916138241) | ||
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) | |||
21100 | 21100 | 4336 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 870 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001641.12667 | 2095893.9772400002 | 37.7350184628259 | -122.436756924204 | (37.7350184628259, -122.436756924204) | |||
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) | ||
23127 | 23127 | 27661 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2211 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2000 12:00:00 AM | 6 | 3X3 | 6012766.85578 | 2096252.7885099999 | 37.7366297052834 | -122.398316233412 | (37.7366297052834, -122.398316233412) | ||
23457 | 23457 | 221362 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1301 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001384.01408 | 2099859.31671 | 37.7458917403255 | -122.437929785824 | (37.7458917403255, -122.437929785824) |
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");