home / trees

Street_Tree_List

Data source: data.sfgov.org

939 rows where qSpecies = 36

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH, PlotSize, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
150 100147 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 3955 18th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6003272.0 2105332.0 37.761025616168396 -122.431792078279 (37.7610256161684, -122.431792078279) 2 4 5 28862 3
156 100152 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 500X Noe St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6002933.4 2105264.1 37.760819979332105 -122.432958296422 (37.7608199793321, -122.432958296422) 2 4 5 28862 3
275 100285 Permitted Site 2 Callistemon viminalis :: Weeping Bottlebrush 36 1426 06th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2         Permit Number 10129 5994323.3 2105790.0 37.761771833907794 -122.462774738749 (37.7617718339078, -122.462774738749) 1 5 11 56 12
710 100793 Permitted Site 2 Callistemon viminalis :: Weeping Bottlebrush 36 2979 21st St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2         Recently planted by FUF. 6008363.0 2103862.0 37.757276607365604 -122.414080464335 (37.7572766073656, -122.414080464335) 2 4 7 28859 19
1003 101156 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 36 1490X 19th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3   6013453.7614400005 2105247.5910900002 37.7613657542352 -122.39657162148501 (37.7613657542352, -122.396571621485) 10 3 8 28856 29
1004 101157 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 36 1490X 19th St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 6x5   6013434.11839 2105245.8196900003 37.7613597971466 -122.396639434871 (37.7613597971466, -122.396639434871) 10 3 8 28856 29
1005 101158 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 36 1490X 19th St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 6x5   6013408.6905 2105245.2503299997 37.7613568185891 -122.396727339995 (37.7613568185891, -122.396727339995) 10 3 8 28856 29
1006 101159 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 36 1490X 19th St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   6013387.24003 2105243.87751 37.7613518552239 -122.39680143245701 (37.7613518552239, -122.396801432457) 10 3 8 28856 29
1417 101601 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 180X Staples Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 2x2   5998894.7 2093810.1 37.7291401587489 -122.446102418286 (37.7291401587489, -122.446102418286) 9 7 4 28861 40
1418 101604 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 180X Staples Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 2x2   5998894.7 2093810.1 37.7291401587489 -122.446102418286 (37.7291401587489, -122.446102418286) 9 7 4 28861 40
1419 101605 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 180X Staples Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 2x2   5998894.7 2093810.1 37.7291401587489 -122.446102418286 (37.7291401587489, -122.446102418286) 9 7 4 28861 40
2286 102585 Permitted Site 2 Callistemon viminalis :: Weeping Bottlebrush 36 173 Marston Ave 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2   03/07/2013 12:00:00 AM     Permit Number 769914 5998407.2 2093120.4 37.7272185530423 -122.44773810752899 (37.7272185530423, -122.447738107529) 9 7 4 28861 40
2553 102871 Permitted Site 2 Callistemon viminalis :: Weeping Bottlebrush 36 173 Marston Ave 2 Sidewalk: Property side : Yard 5 Tree 1 Private 2         Permit Number 769914 5998407.2 2093120.4 37.7272185530423 -122.44773810752899 (37.7272185530423, -122.447738107529) 9 7 4 28861 40
2554 102872 Permitted Site 2 Callistemon viminalis :: Weeping Bottlebrush 36 173 Marston Ave 3 Sidewalk: Property side : Yard 5 Tree 1 Private 2         Permit Number 769914 5998407.2 2093120.4 37.7272185530423 -122.44773810752899 (37.7272185530423, -122.447738107529) 9 7 4 28861 40
3143 103507 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 100X Leroy Pl 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6008356.0 2116660.0 37.7924164947138 -122.41501049488501 (37.7924164947138, -122.415010494885) 5 1 10 28858 21
3144 103508 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 100X Leroy Pl 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6008356.0 2116660.0 37.7924164947138 -122.41501049488501 (37.7924164947138, -122.415010494885) 5 1 10 28858 21
3145 103509 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 100X Leroy Pl 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6008356.0 2116660.0 37.7924164947138 -122.41501049488501 (37.7924164947138, -122.415010494885) 5 1 10 28858 21
3147 103510 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 100X Leroy Pl 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6008356.0 2116660.0 37.7924164947138 -122.41501049488501 (37.7924164947138, -122.415010494885) 5 1 10 28858 21
3148 103511 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 100X Leroy Pl 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6008356.0 2116660.0 37.7924164947138 -122.41501049488501 (37.7924164947138, -122.415010494885) 5 1 10 28858 21
3493 10387 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 36 1352 Haight St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     30 3X3   5999669.18514 2108830.5589 37.7704268951205 -122.44450405514799 (37.7704268951205, -122.444504055148) 15 5 11 29492 9
3599 10401 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 36 1360 Haight St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     18 3X3   5999635.0074 2108810.0697 37.770368686739396 -122.44462080278 (37.7703686867394, -122.44462080278) 15 5 11 29492 9
4002 104501 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 157163 ALBION ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     13 3x3   6005993.0 2106325.0 37.7639060282426 -122.422451867395 (37.7639060282426, -122.422451867395) 8 4 5 28859 19
4004 104503 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 157 ALBION ST   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     13 3x3   6005993.0 2106325.0 37.7639060282426 -122.422451867395 (37.7639060282426, -122.422451867395) 8 4 5 28859 19
4005 104504 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 157-163 ALBION ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     13 3x3   6005993.0 2106325.0 37.7639060282426 -122.422451867395 (37.7639060282426, -122.422451867395) 8 4 5 28859 19
4006 104505 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 157163 ALBION ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 3x3   6005993.0 2106325.0 37.7639060282426 -122.422451867395 (37.7639060282426, -122.422451867395) 8 4 5 28859 19
4238 104766 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 1111 CASTRO ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14 3x3   6002562.6 2102271.3 37.7525814287469 -122.434026788658 (37.7525814287469, -122.434026788658) 2 4 5 28862 22
4239 104767 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 1111 CASTRO ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14 4x4   6002562.6 2102271.3 37.7525814287469 -122.434026788658 (37.7525814287469, -122.434026788658) 2 4 5 28862 22
4275 104807 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 2069 GREEN ST   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6003141.4 2118171.7 37.796272826569705 -122.433161198258 (37.7962728265697, -122.433161198258) 13 9 1 57 17
5264 106009 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 1745 LANE ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     11 3x3   6014990.1 2094194.5 37.7311016564679 -122.390485679987 (37.7311016564679, -122.390485679987) 10 3 8 58 1
5333 106091 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 36 1200 HUDSON AVE 12 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     8 3x3   6017390.0 2095089.0 37.733690618402704 -122.382250932174 (37.7336906184027, -122.382250932174) 10 3 8 58 1
5831 106704 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 179 BRIGHTON AVE 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   5996189.7 2091071.1 37.7214646729593 -122.45525590980199 (37.7214646729593, -122.455255909802) 9 8 6 28861 24
5833 106706 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 199X BRIGHTON AVE 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3   5996224.0 2090880.0 37.7209419254054 -122.455123542447 (37.7209419254054, -122.455123542447) 9 8 6 28861 24
6104 107041 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 1301 18TH ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       4x4   6013691.7 2105657.2 37.7625036896712 -122.39577738754299 (37.7625036896712, -122.395777387543) 10 3 8 28856 29
6146 107105 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 532 NOE ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 4x4   6002950.4 2105092.9 37.760350869576705 -122.43288727007901 (37.7603508695767, -122.432887270079) 2 4 5 28862 3
6147 107106 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 532 NOE ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 4x4   6002950.4 2105092.9 37.760350869576705 -122.43288727007901 (37.7603508695767, -122.432887270079) 2 4 5 28862 3
6247 107235 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 36 786 Sutter St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 3x3   6008834.66692 2115296.44284 37.788699385205796 -122.413257820814 (37.7886993852058, -122.413257820814) 5 1 10 28858 21
6428 107444 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 3333 21ST ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     13 6x6   6006088.7 2103711.1 37.75673426875029 -122.42193517624901 (37.7567342687503, -122.421935176249) 2 4 5 28859 19
7254 108373 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 36 637 Naples St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2   1 3x3 Permit Number 773812 6002662.58132 2089906.96275 37.718637468222 -122.432797836946 (37.718637468222, -122.432797836946) 9 7 6 28861 5
7255 108374 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 36 637 Naples St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2   1 3x3 Permit Number 773812 6002670.30203 2089919.45736 37.718672213540295 -122.432772041698 (37.7186722135403, -122.432772041698) 9 7 6 28861 5
7398 10852 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 36 1299X HUDSON AVE 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   04/07/2016 12:00:00 AM 3 3X4   6017281.0 2095243.0 37.734107450868 -122.38263849321599 (37.734107450868, -122.382638493216) 10 3 8 58 1
7431 10855 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 36 1299X HUDSON AVE 4 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   06/21/1996 12:00:00 AM 6 3X4   6017281.0 2095243.0 37.734107450868 -122.38263849321599 (37.734107450868, -122.382638493216) 10 3 8 58 1
7442 10856 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 36 1299X HUDSON AVE 5 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   06/21/1996 12:00:00 AM 6 3X4   6017281.0 2095243.0 37.734107450868 -122.38263849321599 (37.734107450868, -122.382638493216) 10 3 8 58 1
7464 108581 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 1X GARDENSIDE DR 2 Sidewalk: Property side : Cutout 9 Tree 1 Private 2           5999463.0 2102872.0 37.7540544083949 -122.44478887768 (37.7540544083949, -122.44478887768) 2 5 5 63 38
7514 10863 Permitted Site 2 Callistemon viminalis :: Weeping Bottlebrush 36 1275X HUDSON AVE 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   04/28/2016 12:00:00 AM 6 3X4   6017281.0 2095243.0 37.734107450868 -122.38263849321599 (37.734107450868, -122.382638493216) 10 3 8 58 1
7525 10864 Permitted Site 2 Callistemon viminalis :: Weeping Bottlebrush 36 1275X HUDSON AVE 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   02/19/1993 12:00:00 AM 6 3X4   6017281.0 2095243.0 37.734107450868 -122.38263849321599 (37.734107450868, -122.382638493216) 10 3 8 58 1
7613 108723 Permitted Site 2 Callistemon viminalis :: Weeping Bottlebrush 36 764 Arkansas St   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773103 6013016.81056 2103494.00722 37.7565264696642 -122.39795984425301 (37.7565264696642, -122.397959844253) 10 3 8 28856 29
7618 108730 Permitted Site 2 Callistemon viminalis :: Weeping Bottlebrush 36 1822-1898X 23rd St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773105 6013006.0 2102886.0 37.7548564119513 -122.39795458116001 (37.7548564119513, -122.39795458116) 10 3 8 28856 29
7715 10882 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 36 1175X Hudson Ave 15 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     6 3X4   6017544.4990408 2094830.7506973 37.732990049052205 -122.381698823278 (37.7329900490522, -122.381698823278) 10 3 8 58 1
7768 10887 Permitted Site 2 Callistemon viminalis :: Weeping Bottlebrush 36 1270X Hudson Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/21/1996 12:00:00 AM 6 3X4   6017265.0162454005 2095327.7862917 37.734339374173004 -122.382699652574 (37.734339374173, -122.382699652574) 10 3 8 58 1
7779 10888 Permitted Site 2 Callistemon viminalis :: Weeping Bottlebrush 36 1270X Hudson Ave 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/21/1996 12:00:00 AM 6 3X4   6017265.0162454005 2095327.7862917 37.734339374173004 -122.382699652574 (37.734339374173, -122.382699652574) 10 3 8 58 1
7837 108935 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 12X CAMP ST   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   6005858.0 2106413.0 37.764140038871396 -122.422925047265 (37.7641400388714, -122.422925047265) 8 4 5 28859 19
8087 109185 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 198x JUDSON AVE 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5998796.0 2093546.0 37.7284093651166 -122.446424638984 (37.7284093651166, -122.446424638984) 9 7 4 28861 40
8088 109186 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 198x JUDSON AVE 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5998796.0 2093546.0 37.7284093651166 -122.446424638984 (37.7284093651166, -122.446424638984) 9 7 4 28861 40
8280 109380 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 725X BURNETT AVE 3 Sidewalk: Property side : Cutout 9 Tree 1 Private 2           5999257.1 2101645.9 37.7506760851616 -122.44541277185499 (37.7506760851616, -122.445412771855) 2 5 5 63 38
9044 110420 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 419X 18TH AVE 18 Sidewalk: Curb side : Cutout 2 Tree 1 DPW for City Agency 5 MTA 6     3x3   5990240.0 2112557.0 37.7801161452828 -122.477391675869 (37.7801161452828, -122.477391675869) 11 6 2 55 26
9322 110720 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 1898X 10th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           5993137.43282 2102888.05903 37.753735486992 -122.466665198088 (37.753735486992, -122.466665198088) 1 8 4 56 12
9323 110721 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 1898X 10th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           5993137.43282 2102888.05903 37.753735486992 -122.466665198088 (37.753735486992, -122.466665198088) 1 8 4 56 12
9324 110722 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 1898X 10th Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           5993137.43282 2102888.05903 37.753735486992 -122.466665198088 (37.753735486992, -122.466665198088) 1 8 4 56 12
9682 111080 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 2811 14TH AVE 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   5992341.0 2097126.0 37.737868354045204 -122.469000113007 (37.7378683540452, -122.469000113007) 1 8 4 59 40
9830 111230 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 1113 SCOTT ST 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6001842.0 2112262.0 37.779972512780105 -122.4372340286 (37.7799725127801, -122.4372340286) 15 5 11 29490 41
10212 111669 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 99x CARL ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5998115.0 2107097.0 37.7655781805803 -122.44975501544201 (37.7655781805803, -122.449755015442) 15 5 11 29492 9
10214 111670 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 99x CARL ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5998115.0 2107097.0 37.7655781805803 -122.44975501544201 (37.7655781805803, -122.449755015442) 15 5 11 29492 9
10618 112175 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 36 607 29th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     17 3x3   5986883.70014 2111802.41515 37.7778489521099 -122.488946999613 (37.7778489521099, -122.488946999613) 11 6 2 55 26
10619 112176 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 36 607 29th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     21 3x3   5986882.73557 2111785.73395 37.7778030939685 -122.48894910976601 (37.7778030939685, -122.488949109766) 11 6 2 55 26
10845 112393 Permitted Site 2 Callistemon viminalis :: Weeping Bottlebrush 36 4127 18TH ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6002153.0 2105221.0 37.7606573415981 -122.43565426597401 (37.7606573415981, -122.435654265974) 2 4 5 28862 3
10988 112551 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 26 HIDALGO TER 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     15 3x3   6004993.0 2107524.0 37.7671417328885 -122.425995926974 (37.7671417328885, -122.425995926974) 8 4 5 28853 19
11599 113225 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 36 970JONES Bush St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2   5 3x3   6008828.65356 2115644.6839900003 37.7896552332384 -122.413303262628 (37.7896552332384, -122.413303262628) 5 1 10 28858 21
11646 113271 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 36 1321 Revere Ave   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/16/2015 12:00:00 AM     Permit Number 774420 6016529.9 2093260.0 37.7286210040554 -122.38509718743299 (37.7286210040554, -122.385097187433) 10 3 8 58 1
12609 114307 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 595 ELLIS ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6008020.0 2113749.0 37.7844047125189 -122.415966831143 (37.7844047125189, -122.415966831143) 7 10 9 28858 36
12812 114552 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 36 1121 Kansas St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/24/2015 12:00:00 AM 1   Permit Number 777071 6011681.54455 2103150.14548 37.7555078447183 -122.402553516927 (37.7555078447183, -122.402553516927) 10 3 8 28856 29
12830 114570 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 366 MISSISSIPPI ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6014008.0 2105399.0 37.7618123194661 -122.394665331171 (37.7618123194661, -122.394665331171) 10 3 8 28856 29
12925 114669 Permitted Site 2 Callistemon viminalis :: Weeping Bottlebrush 36 176X Peralta Ave 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/30/2015 12:00:00 AM     Permit Number 774564 6009847.7 2100071.6 37.7469522901695 -122.408678376857 (37.7469522901695, -122.408678376857) 2 7 7 28859 2
14528 116347 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 4051X 24TH ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 MTA 11     10 3x3   6002850.0 2101803.0 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035) 2 4 5 28862 22
14529 116348 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 4051X 24TH ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 MTA 11       3x3   6002850.0 2101803.0 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035) 2 4 5 28862 22
14530 116349 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 4051X 24TH ST 3 Sidewalk: Curb side : Cutout 2 Tree 1 MTA 11       3x3   6002850.0 2101803.0 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035) 2 4 5 28862 22
14533 116351 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 4051X 24TH ST 5 Sidewalk: Curb side : Cutout 2 Tree 1 MTA 11       3x3   6002850.0 2101803.0 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035) 2 4 5 28862 22
14534 116352 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 4051X 24TH ST 6 Sidewalk: Curb side : Cutout 2 Tree 1 MTA 11       3x3   6002850.0 2101803.0 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035) 2 4 5 28862 22
14535 116353 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 4051X 24TH ST 7 Sidewalk: Curb side : Cutout 2 Tree 1 MTA 11       3x3   6002850.0 2101803.0 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035) 2 4 5 28862 22
14536 116354 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 4051X 24TH ST 8 Sidewalk: Curb side : Cutout 2 Tree 1 MTA 11     10 3x3   6002850.0 2101803.0 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035) 2 4 5 28862 22
14557 116373 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 36 366 Mississippi St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     16 3x3   6014023.28278 2105408.18049 37.761838376751896 -122.394613116617 (37.7618383767519, -122.394613116617) 10 3 8 28856 29
14787 116626 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 5732X GEARY BLVD 7 Front Yard : Cutout 10 Tree 1 MTA 11 DPW 3     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
14885 116726 Permitted Site 2 Callistemon viminalis :: Weeping Bottlebrush 36 180X PERALTA AVE 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       4x4   6009777.0 2100122.0 37.7470867174475 -122.408926407614 (37.7470867174475, -122.408926407614) 2 7 7 28859 2
15040 116874 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 36 824 Carolina St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3   6012413.67241 2104134.33813 37.7582510683591 -122.400090692038 (37.7582510683591, -122.400090692038) 10 3 8 28856 29
15041 116875 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 36 824 Carolina St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   6012413.40755 2104121.29509 37.7582152402716 -122.400090692059 (37.7582152402716, -122.400090692059) 10 3 8 28856 29
15042 116876 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 36 824 Carolina St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     11 3x3   6012412.723680001 2104109.13047 37.7581818007698 -122.400092202897 (37.7581818007698, -122.400092202897) 10 3 8 28856 29
15100 116948 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 123 WEST PORTAL AVE 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5992936.0 2097647.0 37.7393332491746 -122.46698079132099 (37.7393332491746, -122.466980791321) 1 8 4 59 40
15101 116949 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 123 WEST PORTAL AVE 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5992936.0 2097647.0 37.7393332491746 -122.46698079132099 (37.7393332491746, -122.466980791321) 1 8 4 59 40
16119 118039 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 36 3501 Clement St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   03/17/2018 12:00:00 AM 3 Width 5ft   5984617.866719999 2113142.5664 37.7813961183692 -122.496884124491 (37.7813961183692, -122.496884124491) 11 6 2 55 26
16612 118672 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 36 4600 Balboa St 3 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   03/17/2018 12:00:00 AM 3 Width 3ft   5981237.2536 2110989.81786 37.7752866381156 -122.508419343439 (37.7752866381156, -122.508419343439) 11 6 2 55 26
17406 119916 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 36 3801 Anza St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 Width 3ft   5986867.2095099995 2111818.56024 37.777892319492295 -122.489005232889 (37.7778923194923, -122.489005232889) 11 6 2 55 26
17649 120154 Permitted Site 2 Callistemon viminalis :: Weeping Bottlebrush 36 187 Hartford St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2         6002716.18242301 2104822.03495589 37.759593852181894 -122.433677959685 (37.7595938521819, -122.433677959685) 2 4 5 28862 3
17650 120155 Permitted Site 2 Callistemon viminalis :: Weeping Bottlebrush 36 187 Hartford St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2         6002716.18242301 2104822.03495589 37.759593852181894 -122.433677959685 (37.7595938521819, -122.433677959685) 2 4 5 28862 3
18101 120687 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 36 2040 Balboa St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   03/29/2018 12:45:00 PM 3 Width 3ft   5989191.37637 2111280.32009 37.776549837038495 -122.48092579961501 (37.7765498370385, -122.480925799615) 11 6 2 55 26
18754 121353 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 36 1221 37th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/27/2016 12:00:00 AM 3 3x3   5984567.3281 2106871.8527 37.76417557031971 -122.496596073864 (37.7641755703197, -122.496596073864) 1 8 3 56 35
19082 121682 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 1645 07th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5993978.0 2104308.0 37.757682752419896 -122.46386140871401 (37.7576827524199, -122.463861408714) 1 8 4 56 12
19083 121683 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 1645 07th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5993978.0 2104308.0 37.757682752419896 -122.46386140871401 (37.7576827524199, -122.463861408714) 1 8 4 56 12
20105 12272 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 36 700X Laguna St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/18/1997 12:00:00 AM 3 3X3   6004950.3992 2111308.9655 37.7775319231116 -122.426412801229 (37.7775319231116, -122.426412801229) 7 9 11 28852 10
20206 12283 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 36 803X Laguna St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   03/01/2000 12:00:00 AM 3 4X4   6004627.99576 2111737.28964 37.7786897656705 -122.427558625827 (37.7786897656705, -122.427558625827) 7 9 11 28852 41
20306 12293 Permitted Site 2 Callistemon viminalis :: Weeping Bottlebrush 36 841X Laguna St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   05/06/2002 12:00:00 AM 3 4X4   6004846.05575 2111737.27176 37.7787020480516 -122.42680427007099 (37.7787020480516, -122.426804270071) 7 9 11 28852 41
20347 12297 Permitted Site 2 Callistemon viminalis :: Weeping Bottlebrush 36 861 Laguna St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   02/07/2004 12:00:00 AM 3 4X4   6004837.02716 2111802.36626 37.778880271067294 -122.426840140564 (37.7788802710673, -122.426840140564) 7 9 11 28852 41

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 39.948ms · Data source: data.sfgov.org