Street_Tree_List

Data source: data.sfgov.org

246 rows where qSpecies = 118

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
858 251395 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 2101 26th St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6012226.0 2101445.0 37.750856267744496 -122.400550836744 (37.7508562677445, -122.400550836744)
5991 18923 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 2671 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/15/2000 12:00:00 AM 6 4X4   6002050.10915 2115698.07724 37.7894189336721 -122.436760123981 (37.7894189336721, -122.436760123981)
7979 18858 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 2205 Sacramento St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/21/1997 12:00:00 AM 3 3X3   6004161.3463 2115991.64976 37.7903447686476 -122.429476425706 (37.7903447686476, -122.429476425706)
7998 18857 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 2205 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3X3   6004122.834530001 2115986.40617 37.7903281905406 -122.429609299623 (37.7903281905406, -122.429609299623)
8153 14638 DPW Maintained 3 Cupaniopsis anacardioides :: Carrotwood 118 600X McAllister St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     10 4x4   6006218.484130001 2112159.25458 37.7799382114304 -122.42208648601601 (37.7799382114304, -122.422086486016)
9757 16080 DPW Maintained 3 Cupaniopsis anacardioides :: Carrotwood 118 266 Monterey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6000320.86003 2094706.9046 37.7316839160675 -122.44123639873699 (37.7316839160675, -122.441236398737)
10193 121761 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 580 07th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/03/2017 12:00:00 AM 3 3x3 Permit Number 779456 6011520.0 2109619.0 37.7732608451695 -122.403567299641 (37.7732608451695, -122.403567299641)
16443 2539 DPW Maintained 3 Cupaniopsis anacardioides :: Carrotwood 118 1575 Burke Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/05/1999 12:00:00 AM 3 3X3   6016305.53274 2099035.35536 37.7444665522926 -122.386275327464 (37.7444665522926, -122.386275327464)
17191 16057 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 223 Monterey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6000584.1346 2094621.9553599998 37.731465658714704 -122.440320118183 (37.7314656587147, -122.440320118183)
17401 16090 DPW Maintained 3 Cupaniopsis anacardioides :: Carrotwood 118 282 Monterey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6000233.37509 2094706.4626900002 37.7316777188345 -122.44153881915399 (37.7316777188345, -122.441538819154)
17437 16066 DPW Maintained 3 Cupaniopsis anacardioides :: Carrotwood 118 236 Monterey Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6000441.13466 2094703.95832 37.731682676816604 -122.44082037507401 (37.7316826768166, -122.440820375074)
18327 16062 DPW Maintained 3 Cupaniopsis anacardioides :: Carrotwood 118 234 Monterey Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6000489.610780001 2094702.95289 37.731682676805605 -122.44065271176399 (37.7316826768056, -122.440652711764)
18342 16083 DPW Maintained 3 Cupaniopsis anacardioides :: Carrotwood 118 263 Monterey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3x3   6000325.98058 2094626.3605400003 37.7314630524765 -122.441212919239 (37.7314630524765, -122.441212919239)
18508 16079 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 262 Monterey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3X3   6000336.4713 2094705.6777299999 37.731681436630396 -122.441182339604 (37.7316814366304, -122.441182339604)
18515 16081 DPW Maintained 3 Cupaniopsis anacardioides :: Carrotwood 118 270 Monterey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6000295.71125 2094707.20068 37.7316832964356 -122.441323364105 (37.7316832964356, -122.441323364105)
18649 16082 DPW Maintained 3 Cupaniopsis anacardioides :: Carrotwood 118 271 Monterey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6000311.38839 2094627.2960599998 37.7314647899717 -122.441263434174 (37.7314647899717, -122.441263434174)
19001 16065 DPW Maintained 3 Cupaniopsis anacardioides :: Carrotwood 118 236 Monterey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6000470.32804 2094701.9984799998 37.7316789581131 -122.440719307449 (37.7316789581131, -122.440719307449)
19838 33420 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 498X KENWOOD WAY 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/19/1996 12:00:00 AM 2   Permit Number 37528 5993404.0 2093661.0 37.7284156834141 -122.46507324106301 (37.7284156834141, -122.465073241063)
20336 16086 DPW Maintained 3 Cupaniopsis anacardioides :: Carrotwood 118 279 Monterey Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6000243.09762 2094627.4476700001 37.731461315874206 -122.44149953856702 (37.7314613158742, -122.441499538567)
20872 16089 DPW Maintained 3 Cupaniopsis anacardioides :: Carrotwood 118 281 Monterey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6000204.672619999 2094627.9285799998 37.7314604471408 -122.441632415216 (37.7314604471408, -122.441632415216)
21004 16064 DPW Maintained 3 Cupaniopsis anacardioides :: Carrotwood 118 239 Monterey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6000482.86247 2094624.68801 37.7314673953084 -122.440670430219 (37.7314673953084, -122.440670430219)
21129 16061 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 234 Monterey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6000514.97584 2094701.7216599998 37.7316807405534 -122.440564931622 (37.7316807405534, -122.440564931622)
21537 16070 DPW Maintained 3 Cupaniopsis anacardioides :: Carrotwood 118 251 Monterey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6000403.76361 2094624.4309200002 37.731462184634 -122.440943870862 (37.731462184634, -122.440943870862)
21674 16056 DPW Maintained 3 Cupaniopsis anacardioides :: Carrotwood 118 219 Monterey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6000606.99528 2094621.48132 37.73146565869779 -122.440241050681 (37.7314656586978, -122.440241050681)
21789 16084 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 273 Monterey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3X3   6000289.1561199995 2094627.44091 37.731463921221795 -122.441340305536 (37.7314639212218, -122.441340305536)
21795 16068 DPW Maintained 3 Cupaniopsis anacardioides :: Carrotwood 118 241 Monterey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6000456.47013 2094623.3376799999 37.731462184614 -122.44076157649499 (37.731462184614, -122.440761576495)
21884 16063 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 235 Monterey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6000510.81653 2094624.7410400002 37.73146913277839 -122.44057379176701 (37.7314691327784, -122.440573791767)
21977 16078 DPW Maintained 3 Cupaniopsis anacardioides :: Carrotwood 118 259 Monterey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6000361.52828 2094624.9906400002 37.7314613158879 -122.44108992616998 (37.7314613158879, -122.44108992617)
23363 16067 DPW Maintained 3 Cupaniopsis anacardioides :: Carrotwood 118 236 Monterey Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     7 3X3   6000426.63236 2094704.03312 37.7316820562622 -122.44087051766 (37.7316820562622, -122.44087051766)
23694 126409 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 1920 Octavia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   6004775.53242 2116016.61179 37.7904480629696 -122.42735316234 (37.7904480629696, -122.42735316234)
23889 202154 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 1937 Armstrong Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 7ft   6013078.37637 2093416.60548 37.728859480065104 -122.397040363418 (37.7288594800651, -122.397040363418)
23990 223678 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 300 Clipper St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6002810.885530001 2100958.91047 37.7489920046987 -122.43307441626999 (37.7489920046987, -122.43307441627)
24301 206799 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 127 Stillings Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   5999908.7774 2095745.2433799999 37.7345114691125 -122.44273557669099 (37.7345114691125, -122.442735576691)
25837 223675 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 300 Clipper St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6002987.60532 2100970.11932 37.749032804240706 -122.43246411921999 (37.7490328042407, -122.43246411922)
26249 202155 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 1931 Armstrong Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 7ft   6013085.35579 2093411.26351 37.728845200628705 -122.39701586051399 (37.7288452006287, -122.397015860514)
26963 35238 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 1240 Filbert St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/17/1998 12:00:00 AM 6   Permit Number 38734 6006976.68497 2119487.9073799998 37.8001036152424 -122.419983741574 (37.8001036152424, -122.419983741574)
27328 87375 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 2260 Vallejo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/17/2008 12:00:00 AM 6 3x3 Permit Number 50354 6002754.86508 2117851.80472 37.7953725427601 -122.434475803729 (37.7953725427601, -122.434475803729)
28706 223282 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 10 Gladys St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6005802.51447 2097630.0872400003 37.740021055027796 -122.42249282938299 (37.7400210550278, -122.422492829383)
28925 176085 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 301 Tunnel Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6011737.8233199995 2086688.14713 37.710309783833 -122.401202160576 (37.710309783833, -122.401202160576)
29779 202150 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 1961 Armstrong Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 7ft   6013012.274569999 2093463.5941 37.728984821287604 -122.397272177194 (37.7289848212876, -122.397272177194)
30788 190955 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 577 07th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6011602.79384 2109609.35058 37.7732389744272 -122.403280224009 (37.7732389744272, -122.403280224009)
31285 176081 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 127 Mount Vernon Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 1ft   5999102.55094 2089159.5285 37.7163826304266 -122.445049667216 (37.7163826304266, -122.445049667216)
31689 206792 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 2468 14th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   5992061.76726 2098654.7592700003 37.742049801468895 -122.470076832981 (37.7420498014689, -122.470076832981)
31916 36945 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 165 03rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/29/1998 12:00:00 AM 8   Permit Number 39581 5994878.4768199995 2114483.13102 37.7856728338639 -122.461484871659 (37.7856728338639, -122.461484871659)
31924 223281 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 16 Gladys St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6005792.089819999 2097609.55014 37.7399640766707 -122.422527414631 (37.7399640766707, -122.422527414631)
32219 95597 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 1625 Carroll Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 3x3   6013964.9434 2092060.83 37.725186106945294 -122.393880551992 (37.7251861069453, -122.393880551992)
32883 202195 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 1938 Armstrong Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 7ft   6013111.07859 2093460.1186900001 37.7289807788209 -122.39693035835501 (37.7289807788209, -122.396930358355)
33140 248036 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 146 Faith St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 2ft   6010366.793380001 2099106.9890099997 37.7443327385694 -122.406815417622 (37.7443327385694, -122.406815417622)
34440 88670 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 601 25th St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/05/2008 12:00:00 AM 4 3x3 Permit Number 51637 6016858.92761 2102116.1469400004 37.7529563862427 -122.384576334524 (37.7529563862427, -122.384576334524)
35191 202156 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 1925 Armstrong Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 7ft   6013109.746230001 2093393.80545 37.7287986220599 -122.39693031698799 (37.7287986220599, -122.396930316988)
35531 223279 DPW Maintained 3 Cupaniopsis anacardioides :: Carrotwood 118 500x 27th St 21 Median : Cutout 11 Tree 1 DPW 2     5 Width 4ft   6002908.34534 2100066.76519 37.746547910875 -122.432673680157 (37.746547910875, -122.432673680157)
36389 202190 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 1900 Armstrong Ave 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11     6013173.69096 2093416.62895 37.7288648499236 -122.396710853637 (37.7288648499236, -122.396710853637)
37936 202157 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 1919 Armstrong Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 7ft   6013116.58632 2093387.72348 37.7287823029563 -122.39690624394 (37.7287823029563, -122.39690624394)
38709 190954 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 120 Brannan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 6ft   6015962.97968 2113739.68127 37.7848224915123 -122.38848597435499 (37.7848224915123, -122.388485974355)
39690 124367 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 91 Palm Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 5ft   5995866.245209999 2113886.77819 37.7840922124102 -122.458024324937 (37.7840922124102, -122.458024324937)
40845 36941 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 152 03rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/29/1998 12:00:00 AM 5   Permit Number 39580 5994928.17811 2114463.2730099997 37.7856211696771 -122.46131148063401 (37.7856211696771, -122.461311480634)
41797 202202 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 1956 Armstrong Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 7ft   6013055.77305 2093504.05261 37.72909833370429 -122.397124634419 (37.7290983337043, -122.397124634419)
45286 176087 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 301 Tunnel Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6011745.86132 2086717.6563900001 37.710391258824004 -122.40117645164301 (37.710391258824, -122.401176451643)
47155 88663 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 601 25th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/05/2008 12:00:00 AM 4 3x3 Permit Number 51637 6016462.36488 2102094.25346 37.752874333003795 -122.38594621066002 (37.7528743330038, -122.38594621066)
48176 202145 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 1991 Armstrong Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   6012926.39508 2093534.5223299998 37.7291747940604 -122.397574043633 (37.7291747940604, -122.397574043633)
50189 126405 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 2501 Jackson St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6001610.61538 2116620.32989 37.791926213878895 -122.438346819448 (37.7919262138789, -122.438346819448)
50490 2506 DPW Maintained 3 Cupaniopsis anacardioides :: Carrotwood 118 1501 Burke Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/16/1999 12:00:00 AM 3 3x3   6016682.7889975 2098765.8378067003 37.743747386445996 -122.384952066789 (37.743747386446, -122.384952066789)
51737 110134 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 2569x Polk St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 3x3   6006173.03027 2119632.97781 37.800456631538204 -122.422775015965 (37.8004566315382, -122.422775015965)
52637 202151 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 1955 Armstrong Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 7ft   6013019.68164 2093458.4573099997 37.7289711290907 -122.397246210158 (37.7289711290907, -122.397246210158)
52639 206800 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 282 Monterey Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 2ft   6000214.83756 2094708.6530099998 37.731682676796204 -122.44160306404899 (37.7316826767962, -122.441603064049)
52674 223271 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 1301 York St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6010084.63709 2101573.03413 37.751088165204294 -122.407964929261 (37.7510881652043, -122.407964929261)
54466 206796 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 106 Thrift St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   5995821.5045300005 2089648.1918400002 37.7175365712383 -122.456425813227 (37.7175365712383, -122.456425813227)
55108 223680 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 300 Clipper St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6002752.1891 2100957.04892 37.748983563648 -122.433277255656 (37.748983563648, -122.433277255656)
56719 124368 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 91 Jordan Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   5996182.82999 2113897.83552 37.7841407574016 -122.45692986250499 (37.7841407574016, -122.456929862505)
56729 223672 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 3458 20th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6007183.778530001 2104422.9400299997 37.758750515843296 -122.41819845149999 (37.7587505158433, -122.4181984515)
57033 32623 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 39 Boardman Pl 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/23/1996 12:00:00 AM 6   Permit Number 37079 6011706.3965300005 2110130.09648 37.7746746089772 -122.402958479854 (37.7746746089772, -122.402958479854)
57845 223276 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 297 Glenview Dr 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5999284.430790001 2100805.05281 37.748368883313 -122.44525781171998 (37.748368883313, -122.44525781172)
59130 36944 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 152 03rd Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/29/1998 12:00:00 AM 4   Permit Number 39580 5994925.42579 2114533.20025 37.785813012576206 -122.46132607375401 (37.7858130125762, -122.461326073754)
60523 88664 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 601 25th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/05/2008 12:00:00 AM 3 3x3 Permit Number 51637 6016498.80939 2102095.90957 37.752880897153396 -122.385820292998 (37.7528808971534, -122.385820292998)
61202 74227 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 796 Brannan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/27/1996 12:00:00 AM 14     6011650.432519999 2109615.42877 37.773258324233495 -122.40311586211399 (37.7732583242335, -122.403115862114)
61320 206795 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 106 Thrift St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5995838.02992 2089647.4067799998 37.717535364348 -122.456368636129 (37.717535364348, -122.456368636129)
62051 88661 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 601 25th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/05/2008 12:00:00 AM 3 3x3 Permit Number 51637 6016379.4847 2102091.5410599997 37.752862298279 -122.386232639338 (37.752862298279, -122.386232639338)
62076 190960 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 580 07th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6011539.8139 2109577.6540099997 37.7731484252993 -122.403495850865 (37.7731484252993, -122.403495850865)
62408 223683 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 3952 25th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6004110.66083 2101326.75882 37.7500756733741 -122.42860600336999 (37.7500756733741, -122.42860600337)
62935 126410 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 1920 Octavia St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 4ft   6004771.881580001 2116049.56275 37.790538331527 -122.427368142329 (37.790538331527, -122.427368142329)
65480 49145 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 1010 Jamestown Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/21/2003 12:00:00 AM 4   Permit Number 46270 6013902.9734 2089731.1325 37.718785778664206 -122.393931770521 (37.7187857786642, -122.393931770521)
65926 176082 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 120 Lathrop Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6011914.4891800005 2086894.19237 37.7108853976137 -122.400606027845 (37.7108853976137, -122.400606027845)
67329 124369 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 91 Jordan Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   5996183.49476 2113914.94636 37.7841877773764 -122.456928800684 (37.7841877773764, -122.456928800684)
68074 120448 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 5 West Clay St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 6ft   5988914.05514 2114983.86125 37.7867025962414 -122.482156513118 (37.7867025962414, -122.482156513118)
68632 190956 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 577 07th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6011592.10905 2109620.43241 37.7732688058471 -122.40331796407301 (37.7732688058471, -122.403317964073)
72106 206794 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 106 Thrift St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5995856.77369 2089647.2346700002 37.7175359677947 -122.456303835451 (37.7175359677947, -122.456303835451)
72651 176088 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 301 Tunnel Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6011749.37983 2086733.5003900002 37.710434959589 -122.401165403463 (37.710434959589, -122.401165403463)
72750 202197 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 1998 Armstrong Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 8ft   6012952.41894 2093581.1404799998 37.7293042469875 -122.39748734448901 (37.7293042469875, -122.397487344489)
73196 124327 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 104 Palm Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5995930.14296 2113730.15975 37.783665851105106 -122.45779192626001 (37.7836658511051, -122.45779192626)
73336 40136 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 2760 Vallejo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/31/1999 12:00:00 AM 11   Permit Number 41340 6000331.47905 2117521.66329 37.7943282005485 -122.442837375469 (37.7943282005485, -122.442837375469)
75573 223280 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 456 Laidley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6003505.678309999 2096373.7210400002 37.7364415203469 -122.43034472563299 (37.7364415203469, -122.430344725633)
75577 223275 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 57 Winfield St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 1ft   6007321.82644 2099172.60178 37.7443420492586 -122.41734894560601 (37.7443420492586, -122.417348945606)
76256 248031 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 135 Faith St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 2ft   6010398.33522 2099063.65948 37.7442155299264 -122.406703299111 (37.7442155299264, -122.406703299111)
76556 126408 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 2610 Clay St 23 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 5ft   6001492.9294300005 2115998.7145599998 37.7902127247824 -122.438709450393 (37.7902127247824, -122.438709450393)
76668 223269 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 1260 Utah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6010823.03156 2102440.75531 37.7535120494589 -122.405472576922 (37.7535120494589, -122.405472576922)
78385 91478 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 601 25th St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/05/2008 12:00:00 AM   3x3 Permit Number 51637 6016776.9 2102119.9 37.7529621548081 -122.384860265748 (37.7529621548081, -122.384860265748)
78651 52377 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 8TA MARINA Gladeview Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/14/2005 12:00:00 AM     Permit Number 48506 5997748.93752219 2101838.53853326 37.751118812629 -122.450641986228 (37.751118812629, -122.450641986228)
79726 91481 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 601 25th St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/05/2008 12:00:00 AM   3x3 Permit Number 51637 6016776.9 2102119.9 37.7529621548081 -122.384860265748 (37.7529621548081, -122.384860265748)
79932 34810 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 101 Rome St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/1997 12:00:00 AM     Permit Number 38445 5999074.40253363 2089202.20922089 37.7164982153246 -122.44515002823799 (37.7164982153246, -122.445150028238)
80981 39518 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 3964 25TH ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/28/1998 12:00:00 AM 10   Permit Number 40967 6004074.0 2101323.0 37.750063277719704 -122.42873251065399 (37.7500632777197, -122.428732510654)

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" 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");
Powered by Datasette · Query took 109.528ms · Data source: data.sfgov.org