trees

11,635 rows where qSpecies_id = 27 sorted by Police Districts

✎ 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  
673 134853 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 767 Francisco St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 6ft   6007674.44825 2120926.53218 37.8040930033612 -122.417671229348 (37.8040930033612, -122.417671229348) 5 1 1 308 32
787 110793 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 900 CALIFORNIA ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009776 2116634 37.7924247975925 -122.410095399183 (37.7924247975925, -122.410095399183) 5 1 10 28857 21
1223 97704 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 900 North Point St 13 Sidewalk: Curb side : Cutout Tree Private 2   12/02/2008 12:00:00 AM 6 4x8 Permit Number 56162 6006190.09828 2121459.17568 37.8054718673026 -122.422845813285 (37.8054718673026, -122.422845813285) 5 1 1 28858 32
1414 135215 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1500 The Embarcadero 13 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6011722.83075 2121216.32362 37.8051156764096 -122.403681836968 (37.8051156764096, -122.403681836968) 3 1 10 28860 23
1644 134665 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 941 Mason St 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6009507.53925 2116615.63337 37.7923593165687 -122.41102298664 (37.7923593165687, -122.41102298664) 5 1 10 28857 21
2129 134818 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 995 Chestnut St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6007124.95237 2120498.06243 37.8028855978618 -122.419542385778 (37.8028855978618, -122.419542385778) 5 1 1 28858 32
2243 134920 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2618 Taylor St 1 Sidewalk: Property side : Yard Tree Private 2     17 Width 4ft   6008362.41303 2121791.60977 37.8065069770658 -122.415351749199 (37.8065069770658, -122.415351749199) 3 1 10 308 23
2433 134877 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2431 Jones St 5 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 6ft   6007945.45112 2120891.7188 37.8040126606302 -122.416730934203 (37.8040126606302, -122.416730934203) 5 1 1 308 32
2497 134970 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2100 The Embarcadero 4 Sidewalk: Curb side : Yard Tree Private 2     10     6009821.57971 2122377.99729 37.8081989525817 -122.41034344359 (37.8081989525817, -122.41034344359) 3 1 10 308 23
2719 135295 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 701 Pine St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6010513.55959 2116175.58705 37.7912074181307 -122.407511076491 (37.7912074181307, -122.407511076491) 5 1 10 28857 21
2983 135043 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 252 Broadway 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6012138.01944 2118808.29844 37.7985270074667 -122.402075624411 (37.7985270074667, -122.402075624411) 3 1 10 28860 6
3092 261228 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1415 The Embarcadero 18 Sidewalk: Curb side : Cutout Tree Private 2       Width 4ft   6008836.81707 2122534.51599 37.8085734617661 -122.413762563504 (37.8085734617661, -122.413762563504) 3 1 10 308 23
3144 113684 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 500X THE EMBARCADERO 18 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6013440 2119057 37.7992824654164 -122.3975877866 (37.7992824654164, -122.3975877866) 3 1 10 28860 6
3190 142755 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1800 POWELL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6009592.3293 2119871.6258 37.8013042277799 -122.410959684909 (37.8013042277799, -122.410959684909) 3 1 10 308 23
3193 134664 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 941 Mason St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6009504.03557 2116644.82773 37.7924392807096 -122.411037172525 (37.7924392807096, -122.411037172525) 5 1 10 28857 21
3407 261413 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 784 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2           6009845.04505 2118484.93763 37.7975108909305 -122.409987225009 (37.7975108909305, -122.409987225009) 3 1 10 308 4
3810 143266 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1931 Powell St 7 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6009490.8006 2120270.0842 37.8023926020053 -122.411339185274 (37.8023926020053, -122.411339185274) 3 1 10 308 23
4190 71445 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 60 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   14     6013056.35208 2118942.99059 37.798948052957 -122.398907344312 (37.798948052957, -122.398907344312) 3 1 10 28860 6
4400 135044 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1401 The Embarcadero 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 5ft   6010653.51415 2122133.031 37.8075729363076 -122.407447020463 (37.8075729363076, -122.407447020463) 3 1 10 308 23
4518 135591 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 150x Drumm St 3 Median : Yard Tree DPW 1     6 Width 7ft   6013668.97989 2117535.62616 37.7951178808501 -122.39668872043 (37.7951178808501, -122.39668872043) 4 1 10 28860 6
4616 134618 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 950 California St 5 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6009907.30646 2116505.77238 37.792080074374 -122.40963201871 (37.792080074374, -122.40963201871) 5 1 10 28857 21
4772 258681 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 201 Drumm St 4 Sidewalk: Curb side : Cutout Tree Private 2       Width 4ft   6013623 2117823 37.7959043823773 -122.396867976466 (37.7959043823773, -122.396867976466) 3 1 10 28860 6
4848 142730 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 550 CHESTNUT ST 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6009191.766 2120834.438 37.8039254006949 -122.412413910096 (37.8039254006949, -122.412413910096) 3 1 10 308 23
4972 135235 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1255 Battery St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 5ft   6012207.10461 2120275.3796 37.8025591133786 -122.401939753025 (37.8025591133786, -122.401939753025) 3 1 10 28860 6
4993 134332 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1065 Sutter St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6007520.07602 2115063.17563 37.7879849988512 -122.417789583715 (37.7879849988512, -122.417789583715) 13 1 10 28858 21
5036 52410 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 1337 California St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/12/2006 12:00:00 AM   3x3 Permit Number 48529 6007932.42258608 2116165.68067346 37.7910354039916 -122.416441058577 (37.7910354039916, -122.416441058577) 13 1 10 28858 21
5044 261415 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 787 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2           6009827.54432 2118442.11593 37.7973923321705 -122.410044757791 (37.7973923321705, -122.410044757791) 3 1 10 308 4
5107 135449 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 661 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6011377.91329 2117650.09103 37.7953043957415 -122.404624266194 (37.7953043957415, -122.404624266194) 3 1 10 28857 4
5415 135124 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1403 The Embarcadero 25 Sidewalk: Curb side : Yard Tree Private 2     5 Width 7ft   6009811.99757 2122478.3969 37.8084740875856 -122.410383699057 (37.8084740875856, -122.410383699057) 3 1 10 308 23
5530 143483 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 601 Stockton St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6010529.3655 2116257.1483 37.7914322504168 -122.40746214089 (37.7914322504168, -122.40746214089) 5 1 10 28857 21
5546 135526 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 100 Drumm St 4 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6013707.39698 2117557.45496 37.7951799556548 -122.396557321369 (37.7951799556548, -122.396557321369) 4 1 10 28860 6
5770 135182 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 102 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6008631.75152 2122495.19515 37.8084539787355 -122.414469468391 (37.8084539787355, -122.414469468391) 3 1 10 308 23
5943 94347 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1160 Battery St 4 Sidewalk: Curb side : Cutout Tree Private 2   07/19/2010 12:00:00 AM 14 3x3 Permit Number 53632 6012294.84914 2120000.64626 37.8018096588565 -122.401616790282 (37.8018096588565, -122.401616790282) 3 1 10 28860 6
6179 143106 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 500 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6010480.245 2119965.4734 37.8016116597764 -122.407893711932 (37.8016116597764, -122.407893711932) 3 1 10 308 23
6507 106422 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 900 North Point St 22 Sidewalk: Curb side : Cutout Tree Private 2     6     6006057.80404 2121440.5977 37.8054133915718 -122.423302314572 (37.8054133915718, -122.423302314572) 5 1 1 28858 32
6542 135523 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 100 Drumm St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6013726.97141 2117407.75631 37.7947700077844 -122.396479092036 (37.7947700077844, -122.396479092036) 4 1 10 28860 6
6655 134678 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1140 Pine St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6008464.76647 2115943.71402 37.7904558600981 -122.414583448482 (37.7904558600981, -122.414583448482) 5 1 10 28858 21
6693 25675 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 350X The Embarcadero 2 Sidewalk: Curb side : Cutout Tree Port 6   12/18/2000 12:00:00 AM 12 4x4   6013785.7946449 2118604.8635638 37.7980602547356 -122.396359500707 (37.7980602547356, -122.396359500707) 3 1 10 28860 6
6985 135232 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1265 Battery St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6012193.83647 2120370.28822 37.8028189688939 -122.401992343583 (37.8028189688939, -122.401992343583) 3 1 10 28860 6
7268 108186 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 570 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6011358.60189 2118345.70639 37.7972133083976 -122.404740082713 (37.7972133083976, -122.404740082713) 3 1 10 308 23
7654 254471 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 566x Market St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6012330 2115645 37.7898520566818 -122.401188906813 (37.7898520566818, -122.401188906813) 4 1 10 28854 6
8167 103924 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 500X The Embarcadero 21 Sidewalk: Curb side : Cutout Tree DPW 1   10/30/1995 12:00:00 AM   4x4   6013544.1 2119061 37.7992992444467 -122.397227842585 (37.7992992444467, -122.397227842585)   1 10 28860 6
8495 1737 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 50X Bay St 19 Sidewalk: Curb side : Cutout Tree PUC 8     18 3X9   6010708.099243 2121736.3211997 37.8064867247361 -122.407230131732 (37.8064867247361, -122.407230131732) 3 1 10 308 23
8516 21797 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2600X Taylor St 2 Sidewalk: Curb side : Cutout Tree DPW 1   01/22/2016 12:00:00 AM 12 3X3   6008553.39113 2121935.04647 37.8069115498008 -122.414700989571 (37.8069115498008, -122.414700989571) 3 1 10 308 23

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