Street_Tree_List

Data source: data.sfgov.org

5,577 rows where qSpecies = 12 sorted by qAddress

View and edit SQL

Link rowid TreeID qLegalStatus qSpecies qAddress ▼ SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
1828 35192 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
1869 35202 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
2080 34119 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37980          
3062 34116 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37979          
3077 35211 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
3212 34102 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37975          
3420 35199 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
3663 36860 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM     Permit Number 39538          
5605 34138 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37987          
5673 46713 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/24/2002 12:00:00 AM     Permit Number 44843          
5690 34100 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37975          
5885 46715 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/24/2002 12:00:00 AM     Permit Number 44843          
6242 35188 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
6282 46717 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/24/2002 12:00:00 AM     Permit Number 44843          
7169 34120 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37980          
7206 46718 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/24/2002 12:00:00 AM     Permit Number 44843          
7464 35185 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   19 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
7694 36863 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM     Permit Number 39538          
7712 35193 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
8041 46716 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/24/2002 12:00:00 AM     Permit Number 44843          
8802 50777 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 47304          
8884 34133 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37986          
9418 34114 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37978          
9498 36866 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM     Permit Number 39538          
9542 34136 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37986          
9591 36856 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM     Permit Number 39538          
9614 36864 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM     Permit Number 39538          
10854 34134 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37986          
10907 34118 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37979          
11057 46152 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/27/2001 12:00:00 AM     Permit Number 44491          
11107 34137 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37987          
11262 34121 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37980          
11449 35191 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
11627 88529 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12     Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/21/2008 12:00:00 AM   3x3 Permit Number 51479          
11728 35200 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
12079 46714 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/24/2002 12:00:00 AM     Permit Number 44843          
12275 35186 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   18 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
12401 36861 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM     Permit Number 39538          
12589 34135 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37986          
13016 35189 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
13086 34123 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37981          
13445 36857 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM     Permit Number 39538          
13457 36874 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM     Permit Number 39538          
14227 35184 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
14687 35195 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
14730 34101 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37975          
14763 50776 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 47304          
14818 35190 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
14890 36859 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM     Permit Number 39538          
14897 36862 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM     Permit Number 39538          
15003 34117 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37979          
15057 34122 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37981          
15117 36858 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM     Permit Number 39538          
15124 35187 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   17 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
15551 34115 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37978          
15779 50775 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 47304          
15869 46153 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/27/2001 12:00:00 AM     Permit Number 44491          
15972 34132 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37986          
16027 35201 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
16469 35182 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
16677 36865 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM     Permit Number 39538          
16819 34124 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37982          
16829 35194 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
16890 34103 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37975          
17122 35196 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12   5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1998 12:00:00 AM     Permit Number 38712          
53867 204800 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 0 16th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5991281.57381 2102416.71556 37.752334025717296 -122.473048745206 (37.7523340257173, -122.473048745206)
90909 46106 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Alder St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/18/2001 12:00:00 AM     Permit Number 44470 6010785.67875033 2089962.42163565 37.7192471121728 -122.404723343661 (37.7192471121728, -122.404723343661)
102611 46104 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Alder St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/18/2001 12:00:00 AM     Permit Number 44470 6010785.67875033 2089962.42163565 37.7192471121728 -122.404723343661 (37.7192471121728, -122.404723343661)
109583 46105 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Alder St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/18/2001 12:00:00 AM     Permit Number 44470 6010785.67875033 2089962.42163565 37.7192471121728 -122.404723343661 (37.7192471121728, -122.404723343661)
2702 175365 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Brotherhood Way 18 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 5ft   5993296.25394 2087788.76232 37.712285726578 -122.465019407322 (37.712285726578, -122.465019407322)
2703 175367 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Brotherhood Way 23 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 5ft   5993394.31846 2087754.15211 37.7121963492565 -122.464677958129 (37.7121963492565, -122.464677958129)
2705 175366 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Brotherhood Way 22 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 5ft   5993316.47827 2087783.2739799998 37.7122718230516 -122.464949108223 (37.7122718230516, -122.464949108223)
2708 175370 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Brotherhood Way 26 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 5ft   5993448.13741 2087722.6413599998 37.712112930839 -122.464489658971 (37.712112930839, -122.464489658971)
2709 175364 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Brotherhood Way 15 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 5ft   5993263.021319999 2087797.41727 37.7123075747038 -122.465134896479 (37.7123075747038, -122.465134896479)
2716 175362 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Brotherhood Way 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 5ft   5993185.52762 2087808.44828 37.7123333942447 -122.46540353654 (37.7123333942447, -122.46540353654)
2720 175369 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Brotherhood Way 25 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 5ft   5993431.63462 2087732.39125 37.7121387503812 -122.46454740445101 (37.7121387503812, -122.464547404451)
2721 175371 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Brotherhood Way 27 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 5ft   5993471.88559 2087712.01586 37.712085124705204 -122.464406808033 (37.7120851247052, -122.464406808033)
2722 175368 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Brotherhood Way 24 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 5ft   5993415.10175 2087740.6954 37.7121605985029 -122.464605149022 (37.7121605985029, -122.464605149022)
3733 175357 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Brotherhood Way 2 Front Yard : Yard 7 Tree 1 Private 1     3 Width 5ft   5992890.63105 2087809.5806900002 37.7123194916216 -122.466422861444 (37.7123194916216, -122.466422861444)
3737 175356 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Brotherhood Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 5ft   5992860.08995 2087808.05232 37.71231353272879 -122.46652830874201 (37.7123135327288, -122.466528308742)
3738 175361 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Brotherhood Way 6 Front Yard : Yard 7 Tree 1 Private 1     3 Width 5ft   5993097.02114 2087813.9243700001 37.7123433254574 -122.465709836634 (37.7123433254574, -122.465709836634)
3740 175359 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Brotherhood Way 4 Front Yard : Yard 7 Tree 1 Private 1     7 Width 5ft   5993023.53483 2087808.23472 37.7123234639353 -122.465963412176 (37.7123234639353, -122.465963412176)
3743 175363 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Brotherhood Way 8 Side Yard : Yard 17 Tree 1 Private 1     3 Width 5ft   5993226.79298 2087801.79474 37.71231750501779 -122.465260429219 (37.7123175050178, -122.465260429219)
3747 175360 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Brotherhood Way 5 Front Yard : Yard 7 Tree 1 Private 1     5 Width 5ft   5993054.1062900005 2087811.2090200002 37.7123333942521 -122.46585796488002 (37.7123333942521, -122.46585796488)
3748 175358 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Brotherhood Way 3 Front Yard : Yard 7 Tree 1 Private 1     3 Width 5ft   5992915.27224 2087806.8926400002 37.7123135327144 -122.466337499576 (37.7123135327144, -122.466337499576)
47487 221032 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Castro St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6002228.72337 2107859.0178400003 37.7679049955364 -122.43558110199699 (37.7679049955364, -122.435581101997)
71258 221030 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Castro St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6002233.32446 2107776.82877 37.7676795858795 -122.43555930691299 (37.7676795858795, -122.435559306913)
169512 221031 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Castro St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6002232.66397 2107795.66667 37.76773127261 -122.435562939274 (37.76773127261, -122.435562939274)
23559 188032 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Coral Rd 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6012685.55222 2102502.84879 37.7537865099459 -122.39903589429599 (37.7537865099459, -122.399035894296)
41794 188029 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Coral Rd 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6012701.65178 2102497.5852200002 37.753772954465205 -122.39897984856 (37.7537729544652, -122.39897984856)
47119 188031 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Coral Rd 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6012734.91684 2102494.2067299997 37.7537655314595 -122.398864572545 (37.7537655314595, -122.398864572545)
65289 188025 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Coral Rd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6012582.73869 2102525.50011 37.753842975695704 -122.399393039364 (37.7538429756957, -122.399393039364)
68625 188030 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Coral Rd 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6012718.84264 2102495.6973 37.7537687285693 -122.398920265762 (37.7537687285693, -122.398920265762)
155301 188026 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Coral Rd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6012601.825180001 2102523.3374799998 37.7538381013656 -122.399326881633 (37.7538381013656, -122.399326881633)
155536 188028 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Coral Rd 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6012635.81277 2102515.49505 37.753818461957 -122.39920879346 (37.753818461957, -122.39920879346)
164156 188027 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Coral Rd 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6012619.435430001 2102520.28152 37.7538306918346 -122.399265766417 (37.7538306918346, -122.399265766417)
179276 188033 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Coral Rd 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6012652.037140001 2102509.0655400003 37.7538017120961 -122.39915223420799 (37.7538017120961, -122.399152234208)
133650 222061 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Dorland St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6005472.8501 2105742.2338099997 37.7622765336656 -122.424209462512 (37.7622765336656, -122.424209462512)
185671 222060 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Dorland St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6005458.51914 2105741.51022 37.7622737376675 -122.424258976498 (37.7622737376675, -122.424258976498)
117710 46167 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Hill Point Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/28/2001 12:00:00 AM     Permit Number 44496 5996328.40935041 2106768.45994323 37.7645737153289 -122.45591064533001 (37.7645737153289, -122.45591064533)

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