trees

11,635 rows where qSpecies_id = 27 sorted by YCoord

✎ View and edit SQL

This data as json, CSV (advanced)

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord ▼ Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
525 33087 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   6 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
582 20409 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 451X Sunset Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 10                      
1191 34003 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 37940                    
1227 46197 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   2 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
1605 35819 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 980 Houston St 4 Sidewalk: Curb side : Cutout Tree Private 2   04/22/1998 12:00:00 AM     Permit Number 39055                    
2564 20333 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 101X Sunset Blvd 21 Sidewalk: Curb side : Cutout Tree DPW 1     24 60                      
2988 35689 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   12 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
3253 33090 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   3 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
3352 20327 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 101X Sunset Blvd 15 Sidewalk: Curb side : Cutout Tree DPW 1     18 60                      
3443 33088 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   5 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
3932 36559 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   8 Sidewalk: Curb side : Cutout Tree Private 2   05/19/1998 12:00:00 AM     Permit Number 39428                    
4354 20459 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 495X Sunset Blvd 24 Sidewalk: Curb side : Cutout Tree DPW 1     18 60                      
4642 254121 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 150 Jennings St 3 Sidewalk: Property side : Yard Tree Private 2   01/02/2018 12:00:00 AM 3   Permit Number 781123                    
4666 36564 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   1 Sidewalk: Curb side : Cutout Tree Private 2   05/19/1998 12:00:00 AM     Permit Number 39428                    
4952 20349 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 103X Sunset Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 8                      
5071 254119 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 150 Jennings St 1 Sidewalk: Property side : Yard Tree Private 2   01/02/2018 12:00:00 AM 3   Permit Number 781123                    
5256 20347 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 103X Sunset Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 8                      
5488 46196 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   3 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
6511 46719 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   3 Sidewalk: Curb side : Cutout Tree Private 2   04/24/2002 12:00:00 AM     Permit Number 44843                    
6996 261387 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 600 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2                              
7549 34002 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 37940                    
7997 46198 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   1 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
8327 33086 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   1 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
8443 36563 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   2 Sidewalk: Curb side : Cutout Tree Private 2   05/19/1998 12:00:00 AM     Permit Number 39428                    
8748 261394 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 690 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2                              
8960 39903 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   1 Sidewalk: Curb side : Cutout Tree Private 2   01/03/2002 12:00:00 AM     Permit Number 41185                    
9263 254120 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 150 Jennings St 2 Sidewalk: Property side : Yard Tree Private 2   01/02/2018 12:00:00 AM 3   Permit Number 781123                    
10801 20411 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 451X Sunset Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 10                      
10942 36562 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   3 Sidewalk: Curb side : Cutout Tree Private 2   05/19/1998 12:00:00 AM     Permit Number 39428                    
11082 20348 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 103X Sunset Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 8                      
11484 20350 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 103X Sunset Blvd 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 8                      
11566 46721 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   1 Sidewalk: Curb side : Cutout Tree Private 2   04/24/2002 12:00:00 AM     Permit Number 44843                    
11814 39901 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   3 Sidewalk: Curb side : Cutout Tree Private 2   01/03/2002 12:00:00 AM     Permit Number 41185                    
11924 20331 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 101X Sunset Blvd 19 Sidewalk: Curb side : Cutout Tree DPW 1     24 60                      
11949 34004 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 37940                    
12503 33089 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   4 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
12533 251650 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 101X Vicente St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3                      
12540 33092 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   8 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
12675 35820 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 980 Houston St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/22/1998 12:00:00 AM     Permit Number 39055                    
12691 120130 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 799x Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3                      
12780 33093 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   9 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
13042 39902 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   2 Sidewalk: Curb side : Cutout Tree Private 2   01/03/2002 12:00:00 AM     Permit Number 41185                    
14174 120131 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 799x Shotwell St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3                      
14606 36560 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   7 Sidewalk: Curb side : Cutout Tree Private 2   05/19/1998 12:00:00 AM     Permit Number 39428                    
15431 36565 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   6 Sidewalk: Curb side : Cutout Tree Private 2   05/19/1998 12:00:00 AM     Permit Number 39428                    
15824 20410 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 451X Sunset Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 10                      
16113 33085 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   10 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
16329 35818 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 980 Houston St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/22/1998 12:00:00 AM     Permit Number 39055                    
17106 33091 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   2 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
17326 33082 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   7 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
17709 46720 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   2 Sidewalk: Curb side : Cutout Tree Private 2   04/24/2002 12:00:00 AM     Permit Number 44843                    
18507 254122 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 150 Jennings St 4 Sidewalk: Property side : Yard Tree Private 2   01/02/2018 12:00:00 AM 3   Permit Number 781123                    
18524 35817 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 980 Houston St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/22/1998 12:00:00 AM     Permit Number 39055                    
18937 20328 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 101X Sunset Blvd 16 Sidewalk: Curb side : Cutout Tree DPW 1     18 60                      
19426 35691 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   1 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
87271 27884 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 280 The Embarcadero 14 Sidewalk: Curb side : Cutout Tree Port 6   01/31/2001 12:00:00 AM 12     6015985.589 2013289.413 37.5090039879895 -122.381420145897 (37.5090039879895, -122.381420145897)       28590  
19901 178517 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 328 Schwerin St 1 : Tree Private 2     19 Width 4ft   6008541.04755 2086224.10569 37.7088567573154 -122.412218142448 (37.7088567573154, -122.412218142448) 9 7 8 309 39
61206 178554 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 575 Argonaut Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6007838.70528 2086225.04271 37.7088198950039 -122.414645608726 (37.7088198950039, -122.414645608726) 9 7 8 309 39
74391 178548 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 328 Schwerin St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6008543.60628 2086225.19286 37.7088598860379 -122.412209375875 (37.7088598860379, -122.412209375875) 9 7 8 309 39
57113 178549 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 42 Kelloch Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6008341.68171 2086226.99006 37.7088534882771 -122.412907384688 (37.7088534882771, -122.412907384688) 9 7 8 309 39
27407 178508 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 575 Argonaut Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6007843.72677 2086231.78134 37.7088386800167 -122.414628730257 (37.7088386800167, -122.414628730257) 9 7 8 309 39
116816 178555 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 580 Argonaut Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 2ft   6007810.83159 2086243.51603 37.708869052843 -122.414743250798 (37.708869052843, -122.414743250798) 9 7 8 309 39
192686 178547 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 322 Schwerin St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6008553.87122 2086250.69527 37.7089304864164 -122.412175699859 (37.7089304864164, -122.412175699859) 9 7 8 309 39
157831 178516 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 322 Schwerin St 1 : Tree Private 2     17 Width 4ft   6008552.66413 2086251.21844 37.7089318552027 -122.4121799087 (37.7089318552027, -122.4121799087) 9 7 8 309 39
192561 178518 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 62 Kelloch Ave 1 Sidewalk: Curb side : Pot Tree Private 2     14 Width 6ft   6008249.62715 2086262.35093 37.7089454142616 -122.413228037939 (37.7089454142616, -122.413228037939) 9 7 8 309 39
52982 178550 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 62 Kelloch Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6008247.37238 2086262.53918 37.7089458045697 -122.413235844076 (37.7089458045697, -122.413235844076) 9 7 8 309 39
15448 178519 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 74 Kelloch Ave 1 : Tree Private 2     11 Width 3ft   6008207.90106 2086273.84024 37.7089746188665 -122.413373061735 (37.7089746188665, -122.413373061735) 9 7 8 309 39
131901 178551 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 74 Kelloch Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6008208.89096 2086276.40091 37.7089817055193 -122.413369821453 (37.7089817055193, -122.413369821453) 9 7 8 309 39
34091 178556 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 550 Argonaut Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 2ft   6007824.59893 2086288.7583 37.708994052312 -122.414698868372 (37.708994052312, -122.414698868372) 9 7 8 309 39
98739 178520 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 74 Kelloch Ave 2 : Tree Private 2     10 Width 3ft   6008160.20585 2086291.90919 37.7090215544595 -122.413539180899 (37.7090215544595, -122.413539180899) 9 7 8 309 39
158685 178552 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 80 Kelloch Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6008167.33564 2086292.81606 37.7090244448819 -122.413514603312 (37.7090244448819, -122.413514603312) 9 7 8 309 39
130448 178521 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 90 Kelloch Ave 1 : Tree Private 2     10 Width 3ft   6008137.56043 2086303.76828 37.7090528454867 -122.413618285264 (37.7090528454867, -122.413618285264) 9 7 8 309 39
46080 178553 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 90 Kelloch Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6008120.85709 2086313.06742 37.7090774410456 -122.413676671965 (37.7090774410456, -122.413676671965) 9 7 8 309 39
58395 178546 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 304 Schwerin St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6008580.64082 2086320.97824 37.7091249710973 -122.412088143666 (37.7091249710973, -122.412088143666) 9 7 8 309 39
71423 178515 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 304 Schwerin St 1 : Tree Private 2     22 Width 5ft   6008576.98547 2086321.37555 37.7091258569317 -122.412100805216 (37.7091258569317, -122.412100805216) 9 7 8 309 39
105366 178558 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 525 Argonaut Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 2ft   6007875.12546 2086323.01846 37.7090909623615 -122.414526663487 (37.7090909623615, -122.414526663487) 9 7 8 309 39
190353 178557 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 520 Argonaut Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 2ft   6007843.02927 2086335.95122 37.7091246698288 -122.414638507662 (37.7091246698288, -122.414638507662) 9 7 8 309 39
30729 98333 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 12X Canyon Dr 2 Median : Cutout Tree DPW 1     99     6003235.70781 2086338.01389 37.7088704018082 -122.430562249152 (37.7088704018082, -122.430562249152) 9 7 6 28861 5
74997 178509 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 515 Argonaut Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6007885.07848 2086346.07841 37.7091548393851 -122.414493894899 (37.7091548393851, -122.414493894899) 9 7 8 309 39
168764 178559 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 505 Argonaut Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 2ft   6007887.65657 2086358.05574 37.7091878714972 -122.414485831553 (37.7091878714972, -122.414485831553) 9 7 8 309 39
71300 178510 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 505 Argonaut Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 2ft   6007893.56338 2086370.24401 37.7092216698091 -122.414466278505 (37.7092216698091, -122.414466278505) 9 7 8 309 39
27118 178562 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 480 Argonaut Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 2ft   6007827.05834 2086383.84807 37.709255287376 -122.414697093097 (37.709255287376, -122.414697093097) 9 7 8 309 39
181678 178511 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 541 Argonaut Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 2ft   6007882.79465 2086395.27125 37.7092897844697 -122.414505266807 (37.7092897844697, -122.414505266807) 9 7 8 309 39
41247 178560 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 445 Argonaut Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 2ft   6007876.17075 2086399.21133 37.7093002309861 -122.414528438753 (37.7093002309861, -122.414528438753) 9 7 8 309 39
118272 178563 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 480 Argonaut Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 2ft   6007783.22647 2086400.60158 37.7092988262538 -122.414849768326 (37.7092988262538, -122.414849768326) 9 7 8 309 39
6842 178512 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 439 Argonaut Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 2ft   6007843.62507 2086410.58281 37.7093296262441 -122.414641726346 (37.7093296262441, -122.414641726346) 9 7 8 309 39
168349 178561 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 439 Argonaut Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 2ft   6007844.07465 2086412.1441 37.7093339384832 -122.414640282934 (37.7093339384832, -122.414640282934) 9 7 8 309 39
97288 178590 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 162 Garrison Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6008387.31542 2086415.82047 37.7093745392663 -122.412763008431 (37.7093745392663, -122.412763008431) 9 7 8 309 39
60637 178565 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 460 Argonaut Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6007731.20011 2086418.54573 37.7093451736989 -122.41503084952 (37.7093451736989, -122.41503084952) 9 7 8 309 39
145180 178566 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 440 Argonaut Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6007693.49818 2086433.63947 37.7093844992558 -122.415162221581 (37.7093844992558, -122.415162221581) 9 7 8 309 39
90545 178589 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 148 Garrison Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6008325.30704 2086437.13013 37.709429570584 -122.412978825937 (37.709429570584, -122.412978825937) 9 7 8 309 39
25632 178513 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 415 Argonaut Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6007751.28679 2086446.17262 37.7094221601795 -122.414963380574 (37.7094221601795, -122.414963380574) 9 7 8 309 39
183439 178564 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 415 Argonaut Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 2ft   6007748.23718 2086447.86448 37.7094266343101 -122.41497404023 (37.7094266343101, -122.41497404023) 9 7 8 309 39
49700 252950 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 261x Winding Way 2 Front Yard : Cutout Tree Private 2       3x3 Permit Number 780594 6001774 2086449 37.7090922302752 -122.435622042553 (37.7090922302752, -122.435622042553) 9 7 6 28861 5
86980 252949 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 261x Winding Way 1 Front Yard : Cutout Tree Private 2       3x3 Permit Number 780594 6001774 2086449 37.7090922302752 -122.435622042553 (37.7090922302752, -122.435622042553) 9 7 6 28861 5
190024 178588 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 142 Garrison Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6008281.79574 2086454.46452 37.7094747246612 -122.413130433618 (37.7094747246612, -122.413130433618) 9 7 8 309 39
117886 178567 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 401 Argonaut Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6007708.5234 2086465.04543 37.7094715779164 -122.415112513358 (37.7094715779164, -122.415112513358) 9 7 8 309 39
107024 178514 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 401 Argonaut Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6007703.2956 2086466.81332 37.7094761383866 -122.41513070662 (37.7094761383866, -122.41513070662) 9 7 8 309 39
29963 106965 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 63 BELLE AVE   Sidewalk: Property side : Yard Tree Private 2           5991753.8 2086471.1 37.7085786821221 -122.47025464516 (37.7085786821221, -122.47025464516) 9 8 4 64 24
25548 178587 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 130 Garrison Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6008235.17881 2086471.34858 37.7095184676674 -122.41329274328 (37.7095184676674, -122.41329274328) 9 7 8 309 39

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);