trees

11,635 rows where qSpecies_id = 27 sorted by Zip Codes

✎ 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  
1101 245920 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1828 Market St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6005542.6546 2109064.0833 37.7714014816775 -122.424204294394 (37.7714014816775, -122.424204294394) 7 2 5 28852 10
1302 14133 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1642X Market St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 4x4   6006458.8907635 2109942.5653128 37.773865274364 -122.421097370447 (37.773865274364, -122.421097370447) 7 2 11 28852 10
1765 73918 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 740 Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6004497.3871 2111109.5855 37.776958856214 -122.42796571067 (37.776958856214, -122.42796571067) 7 9 11 28852 10
2016 134492 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 199 Fulton St 15 Sidewalk: Property side : Yard Tree Private 2     10 Width 4ft   6008187.17961 2111997.187 37.7796040530222 -122.415264393538 (37.7796040530222, -122.415264393538) 7 10 9 28852 36
2558 134571 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 30 Larkin St 3 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6007831.94374 2111562.01758 37.7783892110202 -122.416462477559 (37.7783892110202, -122.416462477559) 7 9 9 28852 36
2672 134477 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 100 Larkin St 3 Sidewalk: Curb side : Yard Tree Private 2     14 Width 3ft   6007817.15292 2111847.04957 37.7791710087729 -122.416533840565 (37.7791710087729, -122.416533840565) 7 9 9 28852 36
2841 9956 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 155 Grove St 1 Sidewalk: Curb side : Cutout Tree Mayor Office of Housing 11     12 4X4   6007076.05273 2111529.8614 37.7782583803491 -122.419075111548 (37.7782583803491, -122.419075111548) 7 9 9 28852 36
3484 134344 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1028 Market St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6009395.71575 2112755.03795 37.7817527789197 -122.411137077326 (37.7817527789197, -122.411137077326) 14 2 9 28852 36
3538 249405 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 430 Turk St 1 : Tree Private 2     8 Width 4ft   6007893.39158 2113084.10787 37.7825719605735 -122.416357743418 (37.7825719605735, -122.416357743418) 7 10 9 28852 36
3735 134467 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 599 Van Ness Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6006763.32454 2112440.01421 37.780739823924 -122.420221568169 (37.780739823924, -122.420221568169) 7 9 9 28852 36
3777 109546 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 300x Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6006868.4272 2111721.79621 37.778773692788 -122.419806988803 (37.778773692788, -122.419806988803) 7 9 9 28852 36
3956 48783 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 201 Turk St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/30/2002 12:00:00 AM 6   Permit Number 46038 6008763.21846 2113151.61883 37.7828062042714 -122.413353282927 (37.7828062042714, -122.413353282927) 7 10 9 28852 36
3979 13887 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1028 Market St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x4   6009423.70824 2112763.96692 37.7817788655291 -122.411040866943 (37.7817788655291, -122.411040866943) 14 2 9 28852 36
4164 260061 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 100 Larkin St 8 Sidewalk: Property side : Yard Tree Private 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
4544 143321 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1150 MARKET ST 14 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6008853.5011 2112237.2541 37.7803006456525 -122.412976271095 (37.7803006456525, -122.412976271095) 7 2 9 28852 36
5061 250274 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 43 United Nations Plz 15 Sidewalk: Curb side : Yard Tree Private 2     13 Width 0ft   6008410.26158 2112128.0464 37.779975896618 -122.414501916828 (37.779975896618, -122.414501916828) 7 10 9 28852 36
5111 134476 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 100 Larkin St 2 Sidewalk: Curb side : Yard Tree Private 2     13 Width 3ft   6007839.62129 2111720.04477 37.7788235475933 -122.416447114449 (37.7788235475933, -122.416447114449) 7 9 9 28852 36
5189 134478 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 100 Larkin St 4 Sidewalk: Curb side : Yard Tree Private 2     13 Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
5191 13827 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 964 Market St 4 Sidewalk: Curb side : Cutout Tree DPW 1     40 4X4   6009845.6649 2113195.3529 37.7829870022194 -122.409611544992 (37.7829870022194, -122.409611544992) 14 2 9 28852 36
6007 261051 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 770 Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006693 2113137 37.7826496144307 -122.420514344125 (37.7826496144307, -122.420514344125) 7 9 9 28852 36
6120 134430 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 600 McAllister St 10 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6005993.13992 2112128.40319 37.7798407887477 -122.422863859998 (37.7798407887477, -122.422863859998) 7 9 11 28852 41
6503 250273 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 43 United Nations Plz 14 Sidewalk: Curb side : Yard Tree Private 2     14 Width 0ft   6008481.10598 2112153.65237 37.7800501841947 -122.414258645714 (37.7800501841947, -122.414258645714) 7 10 9 28852 36
6609 134440 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 600 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6006735.90509 2112663.11167 37.7813508503011 -122.420332264839 (37.7813508503011, -122.420332264839) 7 9 9 28852 36
6688 119707 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 47 Octavia St 6 Sidewalk: Curb side : Cutout Tree Private 2           6005657.12364045 2109394.65582136 37.772315616937 -122.423831849588 (37.772315616937, -122.423831849588) 7 9 11 28852 10
7181 14058 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1390 Market St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6007799.3288 2111218.6717 37.7774446311696 -122.416550977219 (37.7774446311696, -122.416550977219) 7 2 9 28852 36
7530 27369 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 251 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree War Memorial 17     12 3X3   6006819.3487219 2111354.6736121 37.7777628978385 -122.419950711926 (37.7777628978385, -122.419950711926) 7 9 11 28852 10
7898 143411 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1244 MARKET ST 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6008077.8348 2111482.5707 37.7781848938095 -122.415606219442 (37.7781848938095, -122.415606219442) 7 2 9 28852 36
8078 260059 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 100 Larkin St 6 Sidewalk: Property side : Yard Tree Private 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
8178 13824 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 964 Market St 1 Sidewalk: Curb side : Cutout Tree DPW 1     40 4x4   6009889.5706 2113199.7435 37.7830015179357 -122.409459958667 (37.7830015179357, -122.409459958667) 14 2 9 28852 36
8249 109550 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 300x Van Ness Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6006859.56746 2111778.81942 37.7789297656303 -122.41984168554 (37.7789297656303, -122.41984168554) 7 9 9 28852 36
8276 134481 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 199 Fulton St 3 Sidewalk: Property side : Yard Tree Private 2     8 Width 4ft   6007895.36182 2111951.33143 37.7794617397969 -122.416270671059 (37.7794617397969, -122.416270671059) 7 10 9 28852 36
8431 14116 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1564 Market St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 4x4   6006761.0540098 2110225.9136176 37.7746603099629 -122.420072248795 (37.7746603099629, -122.420072248795) 7 2 11 28852 10
8607 23185 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 560X McAllister St 1 Sidewalk: Curb side : Cutout Tree DPW 1     30 3X3   6006458.921066 2112191.041059 37.7800390474075 -122.421256963785 (37.7800390474075, -122.421256963785) 7 9 11 28852 41
9215 260060 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 100 Larkin St 7 Sidewalk: Property side : Yard Tree Private 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
9558 13935 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1140X Market St 3 Sidewalk: Curb side : Cutout Tree DPW 1     25 4x4   6008690.2869843 2112068.9420038 37.7798293375501 -122.413528998881 (37.7798293375501, -122.413528998881) 7 2 9 28852 36
9608 143298 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1024 MARKET ST 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6009502.2089 2112829.3107 37.7819626858057 -122.410773906539 (37.7819626858057, -122.410773906539) 14 2 9 28852 36
10568 14122 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1600X Market St 3 Sidewalk: Curb side : Cutout Tree DPW 1   07/07/2011 03:22:00 PM 2 4x4   6006469.71168 2109964.77137 37.7739268568633 -122.42106151609 (37.7739268568633, -122.42106151609) 7 2 11 28852 10
10626 117236 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 635 GROVE ST 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004711 2111132 37.7770324835269 -122.427228354699 (37.7770324835269, -122.427228354699) 7 9 11 28852 10
11317 13705 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 750 Market St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x4   6011215.54657 2114485.16599 37.7866051915093 -122.404963137048 (37.7866051915093, -122.404963137048) 5 2 10 28852 6
11559 261050 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 770 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006693 2113137 37.7826496144307 -122.420514344125 (37.7826496144307, -122.420514344125) 7 9 9 28852 36
12000 261047 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 750 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006673 2113065 37.7824507928685 -122.420578423098 (37.7824507928685, -122.420578423098) 7 9 9 28852 36
12408 33687 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 610 Ivy St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/03/1996 12:00:00 AM   2x3 Permit Number 37763 6004420.66783798 2111040.26799248 37.7767641867681 -122.428226164884 (37.7767641867681, -122.428226164884) 7 9 11 28852 10
12935 200972 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1408 Market St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6007378.6483 2110811.6244 37.776303309184 -122.417977390819 (37.776303309184, -122.417977390819) 7 2 9 28852 36
12944 138948 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 738 HAYES ST 1 Sidewalk: Curb side : Cutout Tree Private 2   08/07/2008 12:00:00 AM 4 Width 0ft Permit Number 51651 6004303.429 2110848.9359 37.7762322016228 -122.428618087069 (37.7762322016228, -122.428618087069) 7 9 11 28852 10

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)
);