home / trees

Street_Tree_List

Data source: data.sfgov.org

130 rows where qSpecies = 47

View and edit SQL

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

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
206 100203 DPW Maintained 1 Shrub :: Shrub 47 2237 Sutter St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     0 4x4   6001906.0 2114287.0 37.785536286354606 -122.43715765220301 (37.7855362863546, -122.437157652203) 13 6 11 29490 13
1981 102267 DPW Maintained 1 Shrub :: Shrub 47 100X Casitas Ave 1 Median : Cutout 1 Tree 1 DPW 1     8 6x3   5995287.9 2097019.1 37.7377446590015 -122.458803572065 (37.7377446590015, -122.458803572065) 9 7 4 59 40
1982 102268 DPW Maintained 1 Shrub :: Shrub 47 100X Casitas Ave 2 Median : Cutout 1 Tree 1 DPW 1     8 6x3   5995287.9 2097019.1 37.7377446590015 -122.458803572065 (37.7377446590015, -122.458803572065) 9 7 4 59 40
2441 102755 Undocumented 3 Shrub :: Shrub 47 61 Jordan Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     0 3x3   5996159.1 2114114.4 37.7847340229516 -122.457027629275 (37.7847340229516, -122.457027629275) 11 6 1 54 31
3620 104034 Undocumented 3 Shrub :: Shrub 47 722 Wisconsin St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6012694.0 2104139.0 37.7582794948464 -122.39912151779 (37.7582794948464, -122.39912151779) 10 3 8 28856 29
4256 104783 Undocumented 3 Shrub :: Shrub 47 50 Walnut St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5998501.2 2116298.0 37.790863832623 -122.449082132455 (37.790863832623, -122.449082132455) 13 6 1 54 31
4457 105003 DPW Maintained 1 Shrub :: Shrub 47 607 CONGO ST   Sidewalk: Property side : Yard 5 Landscaping 2 Private 2           6000094.1 2095817.0 37.73471905904071 -122.44210000591002 (37.7347190590407, -122.44210000591) 9 7 4 63 40
5647 106469 Undocumented 3 Shrub :: Shrub 47 100X HENRY ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 5x5   6002548.0 2107375.0 37.7665941299684 -122.43444215139601 (37.7665941299684, -122.434442151396) 15 5 5 28862 3
6012 106932 DPW Maintained 1 Shrub :: Shrub 47 358 SHOTWELL ST 1 Sidewalk: Curb side : Cutout 2 Landscaping 2 Private 2       8x10   6007793.2 2105846.4 37.7626932925098 -122.416191600332 (37.7626932925098, -122.416191600332) 8 4 7 28859 19
6396 107409 DPW Maintained 1 Shrub :: Shrub 47 125 VILLA TER 1 Sidewalk: Curb side : Cutout 2 Landscaping 2 Private 2           5999028.2 2104385.8 37.758186107000796 -122.44640141076401 (37.7581861070008, -122.446401410764) 2 5 5 28862 3
8462 109607 DPW Maintained 1 Shrub :: Shrub 47 775 Congo St 1 Front Yard : Yard 4 Landscaping 2 Private 2           6000381.8 2095947.7 37.7350943222142 -122.44111470541901 (37.7350943222142, -122.441114705419) 9 7 4 63 40
11348 112917 DPW Maintained 1 Shrub :: Shrub 47 480X BEACON ST 1 Sidewalk: Property side : Yard 5 Tree 1 DPW 1           6002571.0 2098077.0 37.7410653426557 -122.433697996676 (37.7410653426557, -122.433697996676) 2 7 5 63 7
12157 113803 Permitted Site 2 Shrub :: Shrub 47 806 SHOTWELL ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2     3x3   6007931.0 2103220.0 37.755489548438 -122.41552904166201 (37.755489548438, -122.415529041662) 2 4 7 28859 19
12487 114185 Undocumented 3 Shrub :: Shrub 47 2200 HAYES ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5997096.0 2109871.0 37.7731365175856 -122.45347979574801 (37.7731365175856, -122.453479795748) 15 5 2 29492 16
12488 114186 Undocumented 3 Shrub :: Shrub 47 2200 HAYES ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5997096.0 2109871.0 37.7731365175856 -122.45347979574801 (37.7731365175856, -122.453479795748) 15 5 2 29492 16
12790 114527 Undocumented 3 Shrub :: Shrub 47 1 TIOGA AVE 3 Sidewalk: Curb side : Yard 7 Tree 1 Private 2           6011351.0 2088602.0 37.715543251319204 -122.402673611341 (37.7155432513192, -122.402673611341) 9 7 8 309 39
12791 114528 Undocumented 3 Shrub :: Shrub 47 1 TIOGA AVE 4 Sidewalk: Curb side : Yard 7 Tree 1 Private 2           6011351.0 2088602.0 37.715543251319204 -122.402673611341 (37.7155432513192, -122.402673611341) 9 7 8 309 39
14736 116577 Significant Tree 4 Shrub :: Shrub 47 3000x 19TH AVE 1 Sidewalk: Property side : Cutout 9 Tree 1 MTA 11 DPW 3   30 3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251) 1 8 4 64 40
14738 116579 Significant Tree 4 Shrub :: Shrub 47 3000x 19TH AVE 2 Sidewalk: Property side : Cutout 9 Tree 1 MTA 11 DPW 3     3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251) 1 8 4 64 40
14740 116580 Significant Tree 4 Shrub :: Shrub 47 3000x 19TH AVE 3 Sidewalk: Property side : Cutout 9 Landscaping 2 MTA 11 DPW 3     3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251) 1 8 4 64 40
15649 117511 DPW Maintained 1 Shrub :: Shrub 47 2634 37TH AVE 1 Median : Yard 11 Landscaping 2 DPW 1     20 3x3   5984921.0 2097163.0 37.737538439530795 -122.49465702329901 (37.7375384395308, -122.494657023299) 1 8 3 29491 35
15754 117610 DPW Maintained 1 Shrub :: Shrub 47 391 NEVADA ST 1 Unaccepted Street : Yard 13 Landscaping 2 Private 2       3x3   6008958.0 2096497.0 37.737087351465796 -122.41150238578501 (37.7370873514658, -122.411502385785) 10 7 7 28859 2
17159 119673 Undocumented 3 Shrub :: Shrub 47 1207 De Haro St 1 Front Yard : Yard 4 Tree 1 Private 2           6012287.0 2102743.0 37.7544236952833 -122.40043105492799 (37.7544236952833, -122.400431054928) 10 3 8 28856 29
18292 120871 DPW Maintained 1 Shrub :: Shrub 47 1387 08th Ave 1 Sidewalk: Curb side : Pot 3 Landscaping 2 Private 2           5993606.0 2106068.0 37.762493810072606 -122.465275766733 (37.7624938100726, -122.465275766733) 1 8 11 56 12
18793 121390 Undocumented 3 Shrub :: Shrub 47 1301x 07th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5993851.0 2106604.0 37.763979651815205 -122.464467327674 (37.7639796518152, -122.464467327674) 1 8 11 56 12
18794 121391 Undocumented 3 Shrub :: Shrub 47 1301x 07th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5993851.0 2106604.0 37.763979651815205 -122.464467327674 (37.7639796518152, -122.464467327674) 1 8 11 56 12
25280 12755 DPW Maintained 1 Shrub :: Shrub 47 1733 Lake St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   02/24/2008 12:00:00 AM 3 3X3   5990033.85435 2114674.56985 37.785918437001705 -122.478259694764 (37.7859184370017, -122.478259694764) 11 6 2 55 26
37693 139390 DPW Maintained 1 Shrub :: Shrub 47 432 OCTAVIA ST 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   05/02/2017 03:33:00 PM 3 Width 0ft   6005538.2982 2110931.9956 37.776530070945796 -122.424352241322 (37.7765300709458, -122.424352241322) 7 9 11 28852 10
38648 140265 DPW Maintained 1 Shrub :: Shrub 47 2100X Grove St 3 Sidewalk: Curb side : Cutout 2 Landscaping 2 Private 2     0 Width 0ft   5997671.17 2110272.3417 37.7742714515841 -122.45151917218 (37.7742714515841, -122.45151917218) 15 5 2 29492 16
43854 15877 DPW Maintained 1 Shrub :: Shrub 47 5508 Mission St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   12/15/1997 12:00:00 AM 3 3X3   5999048.25069 2087729.15393 37.7124520473945 -122.445134579389 (37.7124520473945, -122.445134579389) 9 7 6 28861 25
43864 15888 DPW Maintained 1 Shrub :: Shrub 47 5625 Mission St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     3 3X3   5998561.46984 2087228.1352400002 37.711048567191604 -122.446781008521 (37.7110485671916, -122.446781008521) 9 7 6 28861 5
52211 181343 DPW Maintained 1 Shrub :: Shrub 47 2500 Sunset Blvd 20 Sidewalk: Property side : Yard 5 Tree 1 Private 2     3 Width 0ft   5985164.5677 2097705.9234 37.739043415002705 -122.493854905389 (37.7390434150027, -122.493854905389) 1 8 3 29491 35
52221 181355 DPW Maintained 1 Shrub :: Shrub 47 2300 Sunset Blvd 53 Sidewalk: Property side : Yard 5 Tree 1 Private 2     3 Width 0ft   5985079.1419 2099429.3232 37.7437704079628 -122.49427726096201 (37.7437704079628, -122.494277260962) 1 8 3 29491 35
52441 181567 DPW Maintained 1 Shrub :: Shrub 47 1300 Sunset Blvd 62 Sidewalk: Property side : Yard 5 Tree 1 Private 2     3 Width 0ft   5984855.7554 2106265.0899 37.7625264639896 -122.49555374589599 (37.7625264639896, -122.495553745896) 1 8 3 56 35
52446 181571 DPW Maintained 1 Shrub :: Shrub 47 1200 Sunset Blvd 30 Sidewalk: Property side : Yard 5 Tree 1 Private 2     3 Width 0ft   5984860.385 2106736.0056 37.7638197374851 -122.49557246911101 (37.7638197374851, -122.495572469111) 1 8 3 56 35
52448 181577 DPW Maintained 1 Shrub :: Shrub 47 1200 Sunset Blvd 59 Sidewalk: Property side : Yard 5 Tree 1 Private 2     6 Width 0ft   5984846.2035 2106866.5794 37.76417742600729 -122.49563114953699 (37.7641774260073, -122.495631149537) 1 8 3 56 35
52450 181582 DPW Maintained 1 Shrub :: Shrub 47 1200 Sunset Blvd 72 Sidewalk: Property side : Yard 5 Tree 1 Private 2     5 Width 0ft   5984863.0361 2106906.9776 37.7642893338004 -122.49557591115601 (37.7642893338004, -122.495575911156) 1 8 3 56 35
53641 182676 DPW Maintained 1 Shrub :: Shrub 47 1715 24th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 Width 0ft   5988712.3482 2103638.8826 37.7555406843938 -122.482022959471 (37.7555406843938, -122.482022959471) 1 8 3 56 35
53642 182677 DPW Maintained 1 Shrub :: Shrub 47 1715 24th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 Width 0ft   5988712.8958 2103624.6472 37.755501629655704 -122.482020022938 (37.7555016296557, -122.482020022938) 1 8 3 56 35
55263 184164 DPW Maintained 1 Shrub :: Shrub 47 1595 44th Ave 1 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     1 Width 0ft   5982483.9557 2104274.5677 37.7569218843537 -122.503609385397 (37.7569218843537, -122.503609385397) 1 8 3 56 35
55307 184206 DPW Maintained 1 Shrub :: Shrub 47 1484 41st Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 Width 0ft   5983432.9268 2105012.9881 37.759005126774895 -122.500382134012 (37.7590051267749, -122.500382134012) 1 8 3 56 35
55755 184622 DPW Maintained 1 Shrub :: Shrub 47 1778 40th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 Width 0ft   5983811.7777 2103069.4322 37.7536908962098 -122.498928317229 (37.7536908962098, -122.498928317229) 1 8 3 56 35
55894 184750 DPW Maintained 1 Shrub :: Shrub 47 1301 Sunset Blvd 17 Sidewalk: Property side : Yard 5 Tree 1 Private 2     2 Width 0ft   5984665.0089 2106100.6902 37.7620638971415 -122.496201328503 (37.7620638971415, -122.496201328503) 1 8 3 56 35
55895 184751 DPW Maintained 1 Shrub :: Shrub 47 1301 Sunset Blvd 18 Sidewalk: Property side : Yard 5 Tree 1 Private 2     2 Width 0ft   5984675.641 2106097.6525 37.7620561792493 -122.4961643326 (37.7620561792493, -122.4961643326) 1 8 3 56 35
55896 184752 DPW Maintained 1 Shrub :: Shrub 47 1301 Sunset Blvd 20 Sidewalk: Property side : Yard 5 Tree 1 Private 2     1 Width 0ft   5984700.7025 2106093.8553 37.7620472211463 -122.496077375707 (37.7620472211463, -122.496077375707) 1 8 3 56 35
55897 184753 DPW Maintained 1 Shrub :: Shrub 47 1301 Sunset Blvd 21 Sidewalk: Property side : Yard 5 Tree 1 Private 2     1 Width 0ft   5984707.1578 2106087.4001 37.76202987507679 -122.496054573405 (37.7620298750768, -122.496054573405) 1 8 3 56 35
55898 184754 DPW Maintained 1 Shrub :: Shrub 47 1301 Sunset Blvd 23 Sidewalk: Property side : Yard 5 Tree 1 Private 2     2 Width 0ft   5984657.4145 2106082.8434 37.762014449980704 -122.496226277389 (37.7620144499807, -122.496226277389) 1 8 3 56 35
55899 184755 DPW Maintained 1 Shrub :: Shrub 47 1301 Sunset Blvd 25 Sidewalk: Property side : Yard 5 Tree 1 Private 2     3 Width 0ft   5984688.1718 2106071.0721 37.7619839309054 -122.496119032944 (37.7619839309054, -122.496119032944) 1 8 3 56 35
55900 184756 DPW Maintained 1 Shrub :: Shrub 47 1301 Sunset Blvd 29 Sidewalk: Property side : Yard 5 Tree 1 Private 2     2 Width 0ft   5984687.2225 2106057.4022 37.761946341588 -122.496121307582 (37.761946341588, -122.496121307582) 1 8 3 56 35
56022 184869 DPW Maintained 1 Shrub :: Shrub 47 1201 Sunset Blvd 58 Sidewalk: Property side : Yard 5 Tree 1 Private 2     3 Width 0ft   5984640.7069 2106821.7773 37.764042376179205 -122.496338586447 (37.7640423761792, -122.496338586447) 1 8 3 56 35
56424 185258 DPW Maintained 1 Shrub :: Shrub 47 2101 Vicente St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 Width 0ft   5986433.4347 2097526.3066 37.7386243913853 -122.489454599165 (37.7386243913853, -122.489454599165) 1 8 3 29491 35
56483 185311 DPW Maintained 1 Shrub :: Shrub 47 2601 Sunset Blvd 36 Sidewalk: Property side : Yard 5 Tree 1 Private 2     4 Width 0ft   5984965.5883 2097247.7465 37.737773740404 -122.49450910826799 (37.737773740404, -122.494509108268) 1 8 3 29491 35
56484 185312 DPW Maintained 1 Shrub :: Shrub 47 2601 Sunset Blvd 37 Sidewalk: Property side : Yard 5 Tree 1 Private 2     3 Width 0ft   5984965.1696 2097238.5346 37.737748422490604 -122.494509877006 (37.7377484224906, -122.494509877006) 1 8 3 29491 35
56485 185313 DPW Maintained 1 Shrub :: Shrub 47 2601 Sunset Blvd 38 Sidewalk: Property side : Yard 5 Tree 1 Private 2     3 Width 0ft   5984983.1747 2097234.3473 37.7377379790483 -122.49444731702299 (37.7377379790483, -122.494447317023) 1 8 3 29491 35
56717 185555 DPW Maintained 1 Shrub :: Shrub 47 2201 Sunset Blvd 39 Sidewalk: Property side : Yard 5 Tree 1 Private 2     3 Width 0ft   5984902.7901 2099826.3861 37.7448503133319 -122.49491630522101 (37.7448503133319, -122.494916305221) 1 8 3 29491 35
56864 185692 DPW Maintained 1 Shrub :: Shrub 47 2101 Sunset Blvd 24 Sidewalk: Property side : Yard 5 Tree 1 Private 2     3 Width 0ft   5984851.9348 2100530.8696 37.746781656202295 -122.495144090409 (37.7467816562023, -122.495144090409) 1 8 3 29491 35
57074 185897 DPW Maintained 1 Shrub :: Shrub 47 2000 Sunset Blvd 40 Sidewalk: Property side : Yard 5 Tree 1 Private 2     2 Width 0ft   5985016.2502 2101239.5934 37.7487372369942 -122.494628152274 (37.7487372369942, -122.494628152274) 1 8 3 29491 35
57447 186250 DPW Maintained 1 Shrub :: Shrub 47 1701 Sunset Blvd 61 Sidewalk: Property side : Yard 5 Tree 1 Private 2     3 Width 0ft   5984767.3503 2103112.4152 37.753864919503 -122.495626952484 (37.753864919503, -122.495626952484) 1 8 3 56 35
57541 186340 DPW Maintained 1 Shrub :: Shrub 47 1801 Sunset Blvd 7 Sidewalk: Property side : Yard 5 Tree 1 Private 2     2 Width 0ft   5984827.0787 2102831.0491 37.7530958632805 -122.495399651332 (37.7530958632805, -122.495399651332) 1 8 3 56 35
57564 186362 DPW Maintained 1 Shrub :: Shrub 47 1801 Sunset Blvd 29 Sidewalk: Property side : Yard 5 Tree 1 Private 2     8 Width 0ft   5984819.5753 2102574.8802 37.7523920547151 -122.49540670794501 (37.7523920547151, -122.495406707945) 1 8 3 56 35
57565 186363 DPW Maintained 1 Shrub :: Shrub 47 1801 Sunset Blvd 30 Sidewalk: Property side : Yard 5 Tree 1 Private 2     9 Width 0ft   5984829.0026 2102575.9576 37.752395564949104 -122.49537418673401 (37.7523955649491, -122.495374186734) 1 8 3 56 35
57566 186364 DPW Maintained 1 Shrub :: Shrub 47 1801 Sunset Blvd 31 Sidewalk: Property side : Yard 5 Tree 1 Private 2     4 Width 0ft   5984815.8043 2102571.1093 37.7523814800587 -122.495419470402 (37.7523814800587, -122.495419470402) 1 8 3 56 35
57633 186427 DPW Maintained 1 Shrub :: Shrub 47 1601 Sunset Blvd 15 Sidewalk: Property side : Yard 5 Tree 1 Private 2     3 Width 0ft   5984725.0315 2104075.456 37.7565066846119 -122.495844334494 (37.7565066846119, -122.495844334494) 1 8 3 56 35
58227 187025 DPW Maintained 1 Shrub :: Shrub 47 2501 Sunset Blvd 44 Sidewalk: Property side : Yard 5 Tree 1 Private 2     2 Width 0ft   5984975.6777 2097882.1396 37.7395162040617 -122.494520977899 (37.7395162040617, -122.494520977899) 1 8 3 29491 35
58253 187053 DPW Maintained 1 Shrub :: Shrub 47 2501 Sunset Blvd 72 Sidewalk: Property side : Yard 5 Tree 1 Private 2     2 Width 0ft   5984954.1557 2097623.876 37.7388058219757 -122.494576356208 (37.7388058219757, -122.494576356208) 1 8 3 29491 35
58254 187054 DPW Maintained 1 Shrub :: Shrub 47 2501 Sunset Blvd 73 Sidewalk: Property side : Yard 5 Tree 1 Private 2     2 Width 0ft   5984950.4566 2097599.3275 37.738738201883294 -122.494587336532 (37.7387382018833, -122.494587336532) 1 8 3 29491 35
58255 187055 DPW Maintained 1 Shrub :: Shrub 47 2501 Sunset Blvd 74 Sidewalk: Property side : Yard 5 Tree 1 Private 2     2 Width 0ft   5984955.8371 2097567.7171 37.738651723125294 -122.49456640389 (37.7386517231253, -122.49456640389) 1 8 3 29491 35
58256 187056 DPW Maintained 1 Shrub :: Shrub 47 2501 Sunset Blvd 75 Sidewalk: Property side : Yard 5 Tree 1 Private 2     2 Width 0ft   5984980.0493 2097557.2924 37.7386245167659 -122.49448192258001 (37.7386245167659, -122.49448192258) 1 8 3 29491 35
58311 187122 DPW Maintained 1 Shrub :: Shrub 47 2600 Sunset Blvd 58 Sidewalk: Property side : Yard 5 Tree 1 Private 2     2 Width 0ft   5985165.8082 2097341.5801 37.7380430985113 -122.49382377418101 (37.7380430985113, -122.493823774181) 1 8 3 29491 35
58420 187234 DPW Maintained 1 Shrub :: Shrub 47 2401 Sunset Blvd 17 Sidewalk: Property side : Yard 5 Tree 1 Private 2     3 Width 0ft   5984956.0101 2098625.8109 37.7415569740276 -122.494643790117 (37.7415569740276, -122.494643790117) 1 8 3 29491 35
58439 187251 DPW Maintained 1 Shrub :: Shrub 47 2401 Sunset Blvd 34 Sidewalk: Property side : Yard 5 Tree 1 Private 2     3 Width 0ft   5984973.9834 2098481.6163 37.7411621065182 -122.494571017919 (37.7411621065182, -122.494571017919) 1 8 3 29491 35
58441 187253 DPW Maintained 1 Shrub :: Shrub 47 2401 Sunset Blvd 36 Sidewalk: Property side : Yard 5 Tree 1 Private 2     3 Width 0ft   5984962.1374 2098459.5582 37.741100847588896 -122.494610350765 (37.7411008475889, -122.494610350765) 1 8 3 29491 35
58547 187377 DPW Maintained 1 Shrub :: Shrub 47 2200 Sunset Blvd 63 Sidewalk: Property side : Yard 5 Tree 1 Private 2     3 Width 0ft   5985052.2703 2100029.8298 37.7454176637381 -122.49441443213001 (37.7454176637381, -122.49441443213) 1 8 3 29491 35
65255 19363 DPW Maintained 1 Shrub :: Shrub 47 738 Shields St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     3 3X3   5992103.0127542 2089880.5617979001 37.7179604248963 -122.469295726054 (37.7179604248963, -122.469295726054) 9 8 6 64 24
83077 21130 DPW Maintained 1 Shrub :: Shrub 47 2292X Sunset Blvd 3 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12     5984947.8628076 2099601.6268993 37.7442358239277 -122.49474388696001 (37.7442358239277, -122.49474388696) 1 8 3 29491 35
83109 21133 DPW Maintained 1 Shrub :: Shrub 47 2292X Sunset Blvd 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12     5984947.8628076 2099601.6268993 37.7442358239277 -122.49474388696001 (37.7442358239277, -122.49474388696) 1 8 3 29491 35
96672 22545 DPW Maintained 1 Shrub :: Shrub 47 7 Topaz Way 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     3 2X3   6001395.6747592995 2098711.0868843 37.742739635423206 -122.43780724032301 (37.7427396354232, -122.437807240323) 2 7 5 63 7
109192 237035 DPW Maintained 1 Shrub :: Shrub 47 150 Octavia St 2 : 14 Tree 1 DPW 1   04/12/2017 02:27:00 PM 3 Width 4ft   6005709.86547 2109855.10938 37.7735828886787 -122.423682154918 (37.7735828886787, -122.423682154918) 7 9 11 28852 10
109193 237036 DPW Maintained 1 Shrub :: Shrub 47 150 Octavia St 4 : 14 Tree 1 DPW 1   04/13/2017 02:42:00 PM 3 Width 4ft   6005705.053180001 2109878.39065 37.7736465417793 -122.423700457022 (37.7736465417793, -122.423700457022) 7 9 11 28852 10
111296 23896 DPW Maintained 1 Shrub :: Shrub 47 1581 Webster St 3 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   05/24/2017 12:00:00 AM 3 3x3   6003535.353102201 2114132.0136397 37.7852032161945 -122.43150950273301 (37.7852032161945, -122.431509502733) 13 9 11 29490 13
111509 239154 DPW Maintained 1 Shrub :: Shrub 47 150 Octavia St 6 : 14 Tree 1 DPW 1   04/13/2017 02:47:00 PM 3 Width 4ft   6005701.84613 2109911.12293 37.773736235682 -122.42371387848999 (37.773736235682, -122.42371387849) 7 9 11 28852 10
115382 24292 DPW Maintained 1 Shrub :: Shrub 47 403 Winfield St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   10/28/1992 12:00:00 AM 3 3X3                      
115949 244299 DPW Maintained 1 Shrub :: Shrub 47 350 Octavia St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   04/20/2017 11:32:00 AM 3 Width 0ft   6005603.4021 2110525.6921 37.7754181362545 -122.424098126533 (37.7754181362545, -122.424098126533) 7 9 11 28852 10
115952 244300 DPW Maintained 1 Shrub :: Shrub 47 350 Octavia St 3 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   04/20/2017 11:46:00 AM 3 Width 0ft   6005602.4578 2110538.44 37.775453085580295 -122.424102299872 (37.7754530855803, -122.424102299872) 7 9 11 28852 10
115953 244301 DPW Maintained 1 Shrub :: Shrub 47 350 Octavia St 4 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   04/20/2017 11:53:00 AM 3 Width 0ft   6005600.097 2110553.5487 37.775494437113295 -122.42411154116199 (37.7754944371133, -122.424111541162) 7 9 11 28852 10
116004 244348 DPW Maintained 1 Shrub :: Shrub 47 300 Octavia St 3 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   04/19/2017 02:44:00 PM 3 Width 0ft   6005622.9962 2110384.2841 37.7750309704349 -122.424020287681 (37.7750309704349, -122.424020287681) 7 9 11 28852 10
116005 244349 DPW Maintained 1 Shrub :: Shrub 47 300 Octavia St 4 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   04/19/2017 02:48:00 PM 3 Width 0ft   6005619.6911 2110403.6421 37.77508393621179 -122.424033097665 (37.7750839362118, -122.424033097665) 7 9 11 28852 10
116007 244351 DPW Maintained 1 Shrub :: Shrub 47 300 Octavia St 6 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   04/20/2017 07:17:00 AM 3 Width 0ft   6005616.3861 2110436.6924 37.7751744977295 -122.42404688124701 (37.7751744977295, -122.424046881247) 7 9 11 28852 10
116048 244390 DPW Maintained 1 Shrub :: Shrub 47 250 Octavia St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   04/15/2017 01:00:00 PM 3 Width 0ft   6005651.6782 2110185.3753 37.774486434317105 -122.423906923072 (37.7744864343171, -122.423906923072) 7 9 11 28852 10
116049 244391 DPW Maintained 1 Shrub :: Shrub 47 250 Octavia St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   04/15/2017 01:16:00 PM 3 Width 0ft   6005650.1507 2110201.4148 37.774530388668 -122.42391334778499 (37.774530388668, -122.423913347785) 7 9 11 28852 10
116050 244392 DPW Maintained 1 Shrub :: Shrub 47 250 Octavia St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   04/15/2017 01:27:00 PM 3 Width 0ft   6005647.8593 2110218.2181 37.774576397101995 -122.42392246931401 (37.774576397102, -122.423922469314) 7 9 11 28852 10
116051 244393 DPW Maintained 1 Shrub :: Shrub 47 250 Octavia St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   04/15/2017 01:35:00 PM 3 Width 0ft   6005645.568 2110235.0213 37.774622405266 -122.423931590501 (37.774622405266, -122.423931590501) 7 9 11 28852 10
123064 251642 DPW Maintained 1 Shrub :: Shrub 47 2253 Broderick St 4 Sidewalk: Curb side : Cutout 2 Landscaping 2 Private 2       3x3   6000298.51737 2116393.24113 37.7912279703404 -122.442870356286 (37.7912279703404, -122.442870356286) 13 6 1 29490 27
123075 251655 DPW Maintained 1 Shrub :: Shrub 47 300x Chester Ave 1 Sidewalk: Property side : Yard 5 Tree 1 DPW 1       3x3   5991691.0 2087193.0 37.710557214846794 -122.47052422929701 (37.7105572148468, -122.470524229297) 9 8 4 64 24
123083 251666 DPW Maintained 1 Shrub :: Shrub 47 76 Denslowe Dr 1 Sidewalk: Property side : Cutout 9 Tree 1 Private 2       3x3   5990680.0 2091936.0 37.723521814492294 -122.474364317808 (37.7235218144923, -122.474364317808) 9 8 4 64 40
123084 251667 DPW Maintained 1 Shrub :: Shrub 47 1090x Eucalyptus Dr 1 Sidewalk: Property side : Cutout 9 Tree 1 Private 2       3x3   5988120.0 2094796.0 37.731225993649296 -122.483423232518 (37.7312259936493, -122.483423232518) 1 8 4 64 35
123348 252868 DPW Maintained 1 Shrub :: Shrub 47 15 Foerster St 2 Sidewalk: Curb side : Yard 7 Tree 1 Private 2       Width 3ft   5998080.65269 2093664.7185 37.7286944544712 -122.44890616611099 (37.7286944544712, -122.448906166111) 9 7 4 28861 40
127201 26499 DPW Maintained 1 Shrub :: Shrub 47 2710 Harrison St 3 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     3 4x3   6008889.7812 2102567.01926 37.7537504562032 -122.41216712165199 (37.7537504562032, -122.412167121652) 2 4 7 28859 19
127794 27143 DPW Maintained 1 Shrub :: Shrub 47 1775 Silver Ave 4 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 2X3   6011388.84182 2095356.57174 37.7340920254878 -122.403017629645 (37.7340920254878, -122.403017629645) 10 3 8 58 1
130682 30054 DPW Maintained 1 Shrub :: Shrub 47 610X Junipero Serra Blvd 7 Median : Cutout 1 Tree 1 DPW 1           5991361.953164 2093442.6103069999 37.7276980777014 -122.47211671569599 (37.7276980777014, -122.472116715696) 9 8 4 64 40

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 22.62ms · Data source: data.sfgov.org