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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 52875 | 52875 | 186786 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1200 Sunset Blvd | 60 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984829.112000001 | 2106870.9818 | 37.7641885128796 | -122.495690587985 | (37.7641885128796, -122.495690587985) | |||
| 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) | |||
| 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) | ||
| 125272 | 125272 | 110420 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 419X 18TH AVE | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | MTA 10 | 3x3 | 5990240.0 | 2112557.0 | 37.7801161452828 | -122.477391675869 | (37.7801161452828, -122.477391675869) | |||
| 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) | ||
| 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) | ||
| 83301 | 83301 | 10882 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1175X Hudson Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6017544.4990408 | 2094830.7506973 | 37.732990049052205 | -122.381698823278 | (37.7329900490522, -122.381698823278) | |||
| 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) | |||
| 146948 | 146948 | 204672 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 370 Monterey Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999659.74264 | 2094714.76051 | 37.7316678047238 | -122.443522570705 | (37.7316678047238, -122.443522570705) | |||
| 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) | ||
| 26495 | 26495 | 188354 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1341 Hudson Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017148.15295 | 2095467.55143 | 37.73471668451 | -122.383113415457 | (37.73471668451, -122.383113415457) | |||
| 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) | |||
| 85326 | 85326 | 106091 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1200 HUDSON AVE | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3x3 | 6017390.0 | 2095089.0 | 37.733690618402704 | -122.382250932174 | (37.7336906184027, -122.382250932174) | |||
| 95289 | 95289 | 37234 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2200X Moraga St | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/12/1998 12:00:00 AM | Permit Number 39797 | 5987459.55498562 | 2104367.82715752 | 37.757469225946295 | -122.48640896705601 | (37.7574692259463, -122.486408967056) | |||
| 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) | ||
| 45351 | 45351 | 188353 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1341 Hudson Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017129.66281 | 2095538.6901900002 | 37.7349109956364 | -122.38318229272899 | (37.7349109956364, -122.383182292729) | |||
| 115986 | 115986 | 37239 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2200X Moraga St | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/12/1998 12:00:00 AM | Permit Number 39797 | 5987459.55498562 | 2104367.82715752 | 37.757469225946295 | -122.48640896705601 | (37.7574692259463, -122.486408967056) | |||
| 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) | |||
| 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) | ||
| 36944 | 36944 | 88065 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2055 Silver Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51066 | 6012481.79699 | 2096085.11316 | 37.7361534207291 | -122.399290043599 | (37.7361534207291, -122.399290043599) | |
| 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) | |||
| 172093 | 172093 | 188352 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1341 Hudson Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017123.5169400005 | 2095558.35639 | 37.7349646554818 | -122.383204909781 | (37.7349646554818, -122.383204909781) | |||
| 402 | 402 | 251283 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1299x Hudson Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 06/06/1997 12:00:00 AM | 3x3 | 6017207.0 | 2095414.0 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | ||
| 50745 | 50745 | 188325 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 9 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6012720.87909 | 2103581.41048 | 37.7567499739592 | -122.39898942183201 | (37.7567499739592, -122.398989421832) | |||
| 95395 | 95395 | 27160 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1700X Silver Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 3X3 | 6011020.5092245005 | 2095004.7366116 | 37.733105385033795 | -122.40426632243 | (37.7331053850338, -122.40426632243) | |||
| 143102 | 143102 | 37235 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2200X Moraga St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/12/1998 12:00:00 AM | Permit Number 39797 | 5987459.55498562 | 2104367.82715752 | 37.757469225946295 | -122.48640896705601 | (37.7574692259463, -122.486408967056) | |||
| 152869 | 152869 | 88064 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2055 Silver Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51066 | 6012497.5295 | 2096095.3068099997 | 37.7361822871662 | -122.399236364881 | (37.7361822871662, -122.399236364881) | |
| 410 | 410 | 251287 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1299x Hudson Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 02/09/1998 12:00:00 AM | 3x3 | 6017207.0 | 2095414.0 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | ||
| 20531 | 20531 | 30747 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 496X Page St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004231.9845 | 2109799.7949 | 37.77334747404829 | -122.42879042330799 | (37.7733474740483, -122.428790423308) |
| 60381 | 60381 | 188345 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2055 Silver Ave | 8 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6012515.97712 | 2096106.6824400001 | 37.73621455036071 | -122.399173381754 | (37.7362145503607, -122.399173381754) | |||
| 95392 | 95392 | 37236 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2200X Moraga St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 03/26/2013 12:00:00 AM | Permit Number 770085 | 5987459.55498562 | 2104367.82715752 | 37.757469225946295 | -122.48640896705601 | (37.7574692259463, -122.486408967056) | |||
| 121613 | 121613 | 116354 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4051X 24TH ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 10 | 3x3 | 6002850.0 | 2101803.0 | 37.7513118941202 | -122.432999456035 | (37.7513118941202, -122.432999456035) | |||
| 179966 | 179966 | 188324 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 8 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6012719.06472 | 2103600.79409 | 37.756803096012 | -122.39899705709 | (37.756803096012, -122.39899705709) | |||
| 358 | 358 | 251286 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1299x Hudson Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 02/09/1998 12:00:00 AM | 3x3 | 6017207.0 | 2095414.0 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | ||
| 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) | ||
| 15147 | 15147 | 96937 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Bay Shore Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010960.45235 | 2094890.17175 | 37.732787457976706 | -122.40446589470699 | (37.7327874579767, -122.404465894707) | |||
| 18822 | 18822 | 30746 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 490X Page St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004256.1031 | 2109802.2559 | 37.7733555963905 | -122.42870716917601 | (37.7733555963905, -122.428707169176) |
| 53435 | 53435 | 222583 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 193 Diamond St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6001753.50389 | 2104887.2031 | 37.7597181171131 | -122.43701204208 | (37.7597181171131, -122.43701204208) | |||
| 54861 | 54861 | 204642 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 290 Granada Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5995680.91746 | 2091957.8181099999 | 37.7238701852543 | -122.457078728228 | (37.7238701852543, -122.457078728228) | |||
| 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) | |||
| 93939 | 93939 | 116353 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4051X 24TH ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 6002850.0 | 2101803.0 | 37.7513118941202 | -122.432999456035 | (37.7513118941202, -122.432999456035) | ||||
| 107624 | 107624 | 24238 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 200X Willow St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/1999 12:00:00 AM | 6 | 4X4 | 6006547.3507 | 2113418.3192 | 37.7834138390239 | -122.421038210119 | (37.7834138390239, -122.421038210119) | ||
| 111008 | 111008 | 116626 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 5732X GEARY BLVD | 7 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 113106 | 113106 | 27129 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2095X Silver Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/16/1999 12:00:00 AM | 6 | 3X3 | 6012407.8106259005 | 2096047.4553772 | 37.736045896585495 | -122.399543203223 | (37.7360458965855, -122.399543203223) | ||
| 136161 | 136161 | 188344 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2055 Silver Ave | 7 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6012532.5163 | 2096115.8290099998 | 37.7362405866356 | -122.39911684046301 | (37.7362405866356, -122.399116840463) | |||
| 177203 | 177203 | 175759 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 201 Tocoloma Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6012872.74847 | 2087577.73375 | 37.7128156646891 | -122.397341941199 | (37.7128156646891, -122.397341941199) | ||||
| 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) | ||
| 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) | ||
| 13770 | 13770 | 96936 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Bay Shore Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010967.89306 | 2094873.35668 | 37.732741703157394 | -122.404438986978 | (37.7327417031574, -122.404438986978) | |||
| 17300 | 17300 | 30745 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 486X Page St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004274.8073 | 2109806.6859 | 37.773368818647 | -122.42864278458 | (37.773368818647, -122.42864278458) |
| 44902 | 44902 | 43889 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1233 Howard St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2000 12:00:00 AM | 4 | Permit Number 43498 | 6009135.81805 | 2110617.1891 | 37.775868173909004 | -122.411885088422 | (37.775868173909, -122.411885088422) | ||
| 61407 | 61407 | 222582 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 193 Diamond St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001750.8913900005 | 2104845.17495 | 37.759602569523395 | -122.437018068443 | (37.7596025695234, -122.437018068443) | |||
| 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) | |||
| 65817 | 65817 | 188323 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 6 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6012718.59247 | 2103642.7954599997 | 37.7569183962771 | -122.399001638237 | (37.7569183962771, -122.399001638237) | |||
| 97270 | 97270 | 27128 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2095X Silver Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/16/1999 12:00:00 AM | 6 | 3X3 | 6012407.8106259005 | 2096047.4553772 | 37.736045896585495 | -122.399543203223 | (37.7360458965855, -122.399543203223) | ||
| 98718 | 98718 | 19415 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 600X Sloat Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/04/1999 12:00:00 AM | 3 | 20 | 5989744.831209299 | 2096044.8028161 | 37.7347493206824 | -122.477897219949 | (37.7347493206824, -122.477897219949) | ||
| 98882 | 98882 | 116352 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4051X 24TH ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 6002850.0 | 2101803.0 | 37.7513118941202 | -122.432999456035 | (37.7513118941202, -122.432999456035) | ||||
| 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) | ||
| 122246 | 122246 | 48437 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2399 Post St | 6 | 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) | |||
| 156145 | 156145 | 116876 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 824 Carolina St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6012412.723680001 | 2104109.13047 | 37.7581818007698 | -122.400092202897 | (37.7581818007698, -122.400092202897) | |||
| 375 | 375 | 251284 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1299x Hudson Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 06/21/1996 12:00:00 AM | 3x3 | 6017207.0 | 2095414.0 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | ||
| 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) | ||
| 16389 | 16389 | 96935 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Bay Shore Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010973.7505 | 2094855.21788 | 37.7326922251695 | -122.404417459925 | (37.7326922251695, -122.404417459925) | |||
| 25966 | 25966 | 204670 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 380 Monterey Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999483.78605 | 2094717.6896400002 | 37.7316658109241 | -122.44413109610001 | (37.7316658109241, -122.4441310961) | |||
| 30579 | 30579 | 175758 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 201 Tocoloma Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6012839.87945 | 2087571.5634599999 | 37.7127968922232 | -122.397455115464 | (37.7127968922232, -122.397455115464) | ||||
| 30747 | 30747 | 188322 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 5 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6012715.86863 | 2103660.87857 | 37.75696789675921 | -122.39901232755399 | (37.7569678967592, -122.399012327554) | |||
| 44691 | 44691 | 175766 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5989094.03032 | 2089506.27121 | 37.7167583770722 | -122.47966897135001 | (37.7167583770722, -122.47966897135) | ||||
| 51195 | 51195 | 244276 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 480 Page St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004294.0037 | 2109808.1625 | 37.7733739594079 | -122.428576486808 | (37.7733739594079, -122.428576486808) | |||
| 59851 | 59851 | 175772 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 5989911.02174 | 2089222.5365 | 37.716026738112 | -122.47682434649201 | (37.716026738112, -122.476824346492) | ||||
| 89141 | 89141 | 30743 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 490X Page St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 01/31/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34630 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.42905135835501 | (37.7740034947051, -122.429051358355) |
| 91224 | 91224 | 96020 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 810 Jones St | 5 | 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) | |
| 92027 | 92027 | 103511 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 100X Leroy Pl | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008356.0 | 2116660.0 | 37.7924164947138 | -122.41501049488501 | (37.7924164947138, -122.415010494885) | |||
| 107908 | 107908 | 41599 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 11 Haight St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/2000 12:00:00 AM | Permit Number 42106 | 6006168.11250893 | 2109650.54781373 | 37.7730470683498 | -122.42208247198299 | (37.7730470683498, -122.422082471983) | |||
| 111947 | 111947 | 48438 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2399 Post St | 5 | 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) | |||
| 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) | ||
| 121491 | 121491 | 116351 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4051X 24TH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 6002850.0 | 2101803.0 | 37.7513118941202 | -122.432999456035 | (37.7513118941202, -122.432999456035) | ||||
| 124787 | 124787 | 16142 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 370 Monterey Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5999632.4946283 | 2094718.5075125 | 37.7316765391045 | -122.443617041287 | (37.7316765391045, -122.443617041287) | |||
| 139848 | 139848 | 27127 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2095X Silver Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/16/1999 12:00:00 AM | 6 | 3X3 | 6012407.8106259005 | 2096047.4553772 | 37.736045896585495 | -122.399543203223 | (37.7360458965855, -122.399543203223) | ||
| 140514 | 140514 | 10856 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1299X HUDSON AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/21/1996 12:00:00 AM | 6 | 3X4 | 6017281.0 | 2095243.0 | 37.734107450868 | -122.38263849321599 | (37.734107450868, -122.382638493216) | ||
| 149081 | 149081 | 116875 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 824 Carolina St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6012413.40755 | 2104121.29509 | 37.7582152402716 | -122.400090692059 | (37.7582152402716, -122.400090692059) | |||
| 150539 | 150539 | 188297 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1582 12th St | 5 | : 4 | Tree 1 | Private 1 | 7 | Width 5ft | 6008118.01492 | 2108896.99552 | 37.771087775398705 | -122.415284140848 | (37.7710877753987, -122.415284140848) | |||
| 158243 | 158243 | 119916 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 3801 Anza St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5986867.2095099995 | 2111818.56024 | 37.777892319492295 | -122.489005232889 | (37.7778923194923, -122.489005232889) | |||
| 162660 | 162660 | 139384 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1492 Broderick St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000711.3822 | 2113738.0773 | 37.7839611073263 | -122.441251269333 | (37.7839611073263, -122.441251269333) | |||
| 170092 | 170092 | 43890 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1233 Howard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2000 12:00:00 AM | 5 | Permit Number 43498 | 6009124.11279 | 2110606.98987 | 37.77583951252829 | -122.41192485917 | (37.7758395125283, -122.41192485917) | ||
| 171701 | 171701 | 175770 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | 5989758.80887 | 2089246.54995 | 37.7160838423675 | -122.477352214341 | (37.7160838423675, -122.477352214341) | ||||
| 180711 | 180711 | 188316 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 850 Carolina St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6012420.02519 | 2103984.29593 | 37.7578394396596 | -122.40005818423799 | (37.7578394396596, -122.400058184238) | |||
| 181339 | 181339 | 124077 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 701 Funston Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 5991933.739630001 | 2110279.93645 | 37.7739620806591 | -122.471366355942 | (37.7739620806591, -122.471366355942) | |||
| 398 | 398 | 251281 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1275x Hudson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 03/23/2006 12:00:00 AM | 3x3 | 6017281.0 | 2095243.0 | 37.734107450868 | -122.38263849321599 | (37.734107450868, -122.382638493216) | ||
| 4203 | 4203 | 252894 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 300x Howth St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 04:10:00 PM | 3 | 3x3 | 5997131.0 | 2090234.0 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | ||
| 5851 | 5851 | 9507 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 935 Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005077.1287 | 2112297.1038 | 37.7802522713917 | -122.42604476220501 | (37.7802522713917, -122.426044762205) | |||
| 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) | ||
| 14841 | 14841 | 96934 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Bay Shore Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010990.76512 | 2094811.6628299998 | 37.7325735829947 | -122.404355571269 | (37.7325735829947, -122.404355571269) | |||
| 15120 | 15120 | 101159 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1490X 19th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6013387.24003 | 2105243.87751 | 37.7613518552239 | -122.39680143245701 | (37.7613518552239, -122.396801432457) | |||
| 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) | ||
| 17361 | 17361 | 30744 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 380 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004178.56485 | 2109886.0183099997 | 37.7735811988523 | -122.428981357915 | (37.7735811988523, -122.428981357915) |
| 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) | |
| 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) | ||
| 27078 | 27078 | 188288 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 106 Langton St | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6010227.812000001 | 2110667.04277 | 37.7760662630739 | -122.40811110056299 | (37.7760662630739, -122.408111100563) |
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");