Street_Tree_List

Data source: data.sfgov.org

11,394 rows where qSpecies = 15 sorted by Latitude

View and edit SQL

Suggested facets: qLegalStatus, qCareAssistant

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude ▼ Longitude Location
1665 251650 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 101X Vicente St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3x3            
1954 20331 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 101X Sunset Blvd 19 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 60            
3168 33093 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15   9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/05/1996 12:00:00 AM     Permit Number 37336          
4009 34002 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 37940          
4171 39901 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/03/2002 12:00:00 AM     Permit Number 41185          
5912 35691 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/10/1998 12:00:00 AM     Permit Number 38993          
6766 33092 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15   8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/05/1996 12:00:00 AM     Permit Number 37336          
7580 33091 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/05/1996 12:00:00 AM     Permit Number 37336          
7627 33085 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15   10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/05/1996 12:00:00 AM     Permit Number 37336          
7750 33087 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15   6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/05/1996 12:00:00 AM     Permit Number 37336          
8246 20349 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 103X Sunset Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 8            
8822 36564 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/19/1998 12:00:00 AM     Permit Number 39428          
9565 20409 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 451X Sunset Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 10            
9595 35817 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 980 Houston St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/22/1998 12:00:00 AM     Permit Number 39055          
9606 20333 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 101X Sunset Blvd 21 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 60            
10191 35689 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15   12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/10/1998 12:00:00 AM     Permit Number 38993          
10242 20328 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 101X Sunset Blvd 16 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 60            
10366 46719 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/24/2002 12:00:00 AM     Permit Number 44843          
10578 39903 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/03/2002 12:00:00 AM     Permit Number 41185          
10962 33089 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15   4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/05/1996 12:00:00 AM     Permit Number 37336          
11036 36559 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15   8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/19/1998 12:00:00 AM     Permit Number 39428          
11116 34003 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 37940          
11483 20348 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 103X Sunset Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 8            
12000 20347 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 103X Sunset Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 8            
12183 20411 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 451X Sunset Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 10            
12200 46197 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/31/2001 12:00:00 AM     Permit Number 44518          
12311 39902 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/03/2002 12:00:00 AM     Permit Number 41185          
12475 36562 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/19/1998 12:00:00 AM     Permit Number 39428          
12674 20327 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 101X Sunset Blvd 15 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 60            
12686 35818 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 980 Houston St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/22/1998 12:00:00 AM     Permit Number 39055          
12828 20459 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 495X Sunset Blvd 24 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 60            
13380 36560 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15   7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/19/1998 12:00:00 AM     Permit Number 39428          
13386 46196 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/31/2001 12:00:00 AM     Permit Number 44518          
13673 33088 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15   5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/05/1996 12:00:00 AM     Permit Number 37336          
13881 35819 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 980 Houston St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/22/1998 12:00:00 AM     Permit Number 39055          
14471 20350 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 103X Sunset Blvd 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 8            
14576 20410 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 451X Sunset Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 10            
14741 33082 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15   7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/05/1996 12:00:00 AM     Permit Number 37336          
14773 46721 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/24/2002 12:00:00 AM     Permit Number 44843          
15188 34004 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 37940          
15368 33086 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/05/1996 12:00:00 AM     Permit Number 37336          
15498 35820 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 980 Houston St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/22/1998 12:00:00 AM     Permit Number 39055          
15698 46198 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/31/2001 12:00:00 AM     Permit Number 44518          
15858 33090 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/05/1996 12:00:00 AM     Permit Number 37336          
16147 36565 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15   6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/19/1998 12:00:00 AM     Permit Number 39428          
16437 36563 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/19/1998 12:00:00 AM     Permit Number 39428          
16615 46720 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/24/2002 12:00:00 AM     Permit Number 44843          
18528 120131 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 799x Shotwell St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3            
20185 120130 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 799x Shotwell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3            
101348 27884 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 280 The Embarcadero 14 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   01/31/2001 12:00:00 AM 12     6015985.589 2013289.4130000002 37.5090039879895 -122.38142014589701 (37.5090039879895, -122.381420145897)
77398 106965 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 63 BELLE AVE   Sidewalk: Property side : Yard 9 Tree 1 Private 1           5991753.8 2086471.1 37.7085786821221 -122.47025464516001 (37.7085786821221, -122.47025464516)
72189 178591 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 67 Belle Ave 1 : 4 Tree 1 Private 1     9 Width 3ft   5991713.92465 2086485.44715 37.70861577046671 -122.470393502266 (37.7086157704667, -122.470393502266)
137765 178592 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 67 Belle Ave 2 : 4 Tree 1 Private 1     9 Width 3ft   5991724.32675 2086485.2281099998 37.7086157704725 -122.470357535671 (37.7086157704725, -122.470357535671)
162521 178554 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 575 Argonaut Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 2ft   6007838.70528 2086225.04271 37.7088198950039 -122.414645608726 (37.7088198950039, -122.414645608726)
52100 178508 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 575 Argonaut Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6007843.72677 2086231.7813400002 37.708838680016704 -122.414628730257 (37.7088386800167, -122.414628730257)
188869 178549 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 42 Kelloch Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6008341.68171 2086226.9900599997 37.7088534882771 -122.412907384688 (37.7088534882771, -122.412907384688)
156719 178517 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 328 Schwerin St 1 : 4 Tree 1 Private 1     19 Width 4ft   6008541.04755 2086224.10569 37.708856757315395 -122.41221814244801 (37.7088567573154, -122.412218142448)
119122 178548 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 328 Schwerin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6008543.60628 2086225.1928599998 37.7088598860379 -122.412209375875 (37.7088598860379, -122.412209375875)
145728 178555 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 580 Argonaut Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 2ft   6007810.831590001 2086243.5160299998 37.708869052843 -122.414743250798 (37.708869052843, -122.414743250798)
10449 98333 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 12X Canyon Dr 2 Median : Cutout 11 Tree 1 DPW 2     99     6003235.70781 2086338.01389 37.708870401808205 -122.43056224915199 (37.7088704018082, -122.430562249152)
147503 178547 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 322 Schwerin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6008553.87122 2086250.69527 37.7089304864164 -122.412175699859 (37.7089304864164, -122.412175699859)
76451 178516 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 322 Schwerin St 1 : 4 Tree 1 Private 1     17 Width 4ft   6008552.66413 2086251.2184400002 37.70893185520271 -122.41217990870001 (37.7089318552027, -122.4121799087)
32945 178518 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 62 Kelloch Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     14 Width 6ft   6008249.62715 2086262.35093 37.708945414261606 -122.41322803793899 (37.7089454142616, -122.413228037939)
70516 178550 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 62 Kelloch Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6008247.372380001 2086262.5391799998 37.7089458045697 -122.413235844076 (37.7089458045697, -122.413235844076)
62440 178519 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 74 Kelloch Ave 1 : 4 Tree 1 Private 1     11 Width 3ft   6008207.90106 2086273.84024 37.7089746188665 -122.413373061735 (37.7089746188665, -122.413373061735)
166145 178551 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 74 Kelloch Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6008208.8909599995 2086276.4009099999 37.70898170551929 -122.413369821453 (37.7089817055193, -122.413369821453)
55176 178556 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 550 Argonaut Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 2ft   6007824.59893 2086288.7583 37.708994052312 -122.414698868372 (37.708994052312, -122.414698868372)
34606 178520 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 74 Kelloch Ave 2 : 4 Tree 1 Private 1     10 Width 3ft   6008160.20585 2086291.9091900003 37.7090215544595 -122.413539180899 (37.7090215544595, -122.413539180899)
70765 178552 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 80 Kelloch Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6008167.33564 2086292.8160599999 37.7090244448819 -122.413514603312 (37.7090244448819, -122.413514603312)
150256 178521 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 90 Kelloch Ave 1 : 4 Tree 1 Private 1     10 Width 3ft   6008137.560430001 2086303.76828 37.7090528454867 -122.413618285264 (37.7090528454867, -122.413618285264)
167412 178553 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 90 Kelloch Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6008120.85709 2086313.06742 37.7090774410456 -122.413676671965 (37.7090774410456, -122.413676671965)
166675 178558 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 525 Argonaut Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 2ft   6007875.12546 2086323.01846 37.7090909623615 -122.414526663487 (37.7090909623615, -122.414526663487)
2767 252950 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 261x Winding Way 2 Front Yard : Cutout 8 Tree 1 Private 1       3x3 Permit Number 780594 6001774.0 2086449.0 37.7090922302752 -122.435622042553 (37.7090922302752, -122.435622042553)
2772 252949 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 261x Winding Way 1 Front Yard : Cutout 8 Tree 1 Private 1       3x3 Permit Number 780594 6001774.0 2086449.0 37.7090922302752 -122.435622042553 (37.7090922302752, -122.435622042553)
173412 178557 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 520 Argonaut Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 2ft   6007843.02927 2086335.9512200002 37.709124669828796 -122.41463850766199 (37.7091246698288, -122.414638507662)
34590 178546 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 304 Schwerin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   6008580.640819999 2086320.97824 37.709124971097296 -122.412088143666 (37.7091249710973, -122.412088143666)
168228 178515 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 304 Schwerin St 1 : 4 Tree 1 Private 1     22 Width 5ft   6008576.98547 2086321.37555 37.709125856931706 -122.41210080521601 (37.7091258569317, -122.412100805216)
173162 178509 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 515 Argonaut Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6007885.078480001 2086346.0784099998 37.7091548393851 -122.41449389489901 (37.7091548393851, -122.414493894899)
131663 178559 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 505 Argonaut Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 2ft   6007887.65657 2086358.0557400002 37.7091878714972 -122.414485831553 (37.7091878714972, -122.414485831553)
184151 178510 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 505 Argonaut Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 2ft   6007893.56338 2086370.2440099998 37.709221669809104 -122.414466278505 (37.7092216698091, -122.414466278505)
54550 178562 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 480 Argonaut Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 2ft   6007827.05834 2086383.84807 37.709255287375996 -122.414697093097 (37.709255287376, -122.414697093097)
55681 178511 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 541 Argonaut Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 2ft   6007882.79465 2086395.27125 37.7092897844697 -122.414505266807 (37.7092897844697, -122.414505266807)
32710 178563 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 480 Argonaut Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 2ft   6007783.22647 2086400.60158 37.70929882625379 -122.414849768326 (37.7092988262538, -122.414849768326)
166470 178560 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 445 Argonaut Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 2ft   6007876.17075 2086399.2113299998 37.7093002309861 -122.414528438753 (37.7093002309861, -122.414528438753)
154364 178512 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 439 Argonaut Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 2ft   6007843.62507 2086410.5828099998 37.7093296262441 -122.41464172634599 (37.7093296262441, -122.414641726346)
26302 178561 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 439 Argonaut Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 2ft   6007844.07465 2086412.1441 37.709333938483205 -122.414640282934 (37.7093339384832, -122.414640282934)
75585 178565 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 460 Argonaut Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 2ft   6007731.20011 2086418.54573 37.7093451736989 -122.41503084952 (37.7093451736989, -122.41503084952)
177503 178590 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 162 Garrison Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 2ft   6008387.31542 2086415.8204700002 37.70937453926629 -122.412763008431 (37.7093745392663, -122.412763008431)
154839 178566 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 440 Argonaut Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 2ft   6007693.49818 2086433.63947 37.7093844992558 -122.415162221581 (37.7093844992558, -122.415162221581)
186646 178513 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 415 Argonaut Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 4ft   6007751.28679 2086446.17262 37.7094221601795 -122.414963380574 (37.7094221601795, -122.414963380574)
55347 178564 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 415 Argonaut Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 2ft   6007748.23718 2086447.86448 37.709426634310105 -122.41497404023 (37.7094266343101, -122.41497404023)
172146 178589 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 148 Garrison Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 2ft   6008325.30704 2086437.13013 37.709429570584 -122.412978825937 (37.709429570584, -122.412978825937)
65454 178567 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 401 Argonaut Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 2ft   6007708.5234 2086465.04543 37.709471577916396 -122.415112513358 (37.7094715779164, -122.415112513358)
184994 178588 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 142 Garrison Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 2ft   6008281.79574 2086454.4645200002 37.709474724661206 -122.413130433618 (37.7094747246612, -122.413130433618)
66536 178514 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 401 Argonaut Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   6007703.2956 2086466.8133200002 37.709476138386606 -122.41513070661999 (37.7094761383866, -122.41513070662)
116930 178587 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 130 Garrison Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 2ft   6008235.1788099995 2086471.34858 37.7095184676674 -122.41329274328001 (37.7095184676674, -122.41329274328)
165834 178538 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 221 Hanover St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5999964.31362 2086649.6943 37.709540337400604 -122.44189096669201 (37.7095403374006, -122.441890966692)
51568 178568 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 324 Argonaut Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 2ft   6007682.95212 2086548.4325400002 37.7096991045948 -122.415206791063 (37.7096991045948, -122.415206791063)
39330 178586 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 50 Garrison Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 2ft   6008179.939230001 2086593.1846599998 37.7098499029291 -122.413492272274 (37.7098499029291, -122.413492272274)
137628 178585 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 38 Garrison Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 2ft   6008197.36949 2086639.4956 37.7099780419221 -122.413435302895 (37.7099780419221, -122.413435302895)

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