trees

11,635 rows where qSpecies_id = 27 sorted by Fire Prevention 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                    
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
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  
98286 27706 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 1801 The Embarcadero 1 Sidewalk: Curb side : Cutout Tree Port 6     6     6008269.247115 2122709.555122 37.8090221854411 -122.415739206432 (37.8090221854411, -122.415739206432)   1 10 308 23
101634 135098 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1401 The Embarcadero 56 Sidewalk: Property side : Yard Tree Private 2     6     6010217.76574 2122446.50226 37.808409250946 -122.408977168373 (37.808409250946, -122.408977168373)   1 10 308 23
125862 27707 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 1801 The Embarcadero 2 Sidewalk: Curb side : Cutout Tree Port 6     6     6008269.247115 2122709.555122 37.8090221854411 -122.415739206432 (37.8090221854411, -122.415739206432)   1 10 308 23
164568 133652 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 3301 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6005119.93852 2122348.80077 37.8078541066547 -122.42661263717 (37.8078541066547, -122.42661263717)   9 1 28858 17
179201 103925 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 500X The Embarcadero 22 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
2097 12450 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 200X Lake Merced Blvd 1 Median : Cutout Tree DPW 1     3 6   5983914.9541303 2094860.2401332 37.7311567434968 -122.497965345854 (37.7311567434968, -122.497965345854) 1 8 4 64 35
2322 218250 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2751 14th Ave 1 : Tree Private 2     14 Width 3ft   5992235.80201 2097238.62713 37.738171520993 -122.469372026199 (37.738171520993, -122.469372026199) 1 8 4 59 40
2850 178600 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 200 Winston Dr 6 : Tree Private 2     6 Width 0ft   5989476.93903 2093627.59215 37.7280967254778 -122.478646687712 (37.7280967254778, -122.478646687712) 1 8 4 64 14
2924 23991 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 288 West Portal Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   5992343.1525 2097239.1889 37.7381792665746 -122.469000905839 (37.7381792665746, -122.469000905839) 1 8 4 59 40
2964 22868 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 901X Ulloa St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   5993173.81508 2098252.95685 37.7410107778213 -122.466202563499 (37.7410107778213, -122.466202563499) 1 8 4 59 40
3067 211925 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 115 San Anselmo Ave 1 Sidewalk: Curb side : Yard Tree Private 2     18 Width 8ft   5993291.36421 2096622.21184 37.7365399421628 -122.465677676 (37.7365399421628, -122.465677676) 1 8 4 59 40
3085 262583 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2801X 14th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5992317 2097142 37.7379108993029 -122.469084256099 (37.7379108993029, -122.469084256099) 1 8 4 59 40
3181 103180 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1601X 28th Ave 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5     11 3x4   5987448.1702 2104354.2995 37.7574314190685 -122.486447346513 (37.7574314190685, -122.486447346513) 1 8 3 56 35
3786 24010 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 398 West Portal Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   5991871.0543 2096731.9947 37.7367593513498 -122.470596240632 (37.7367593513498, -122.470596240632) 1 8 4 59 40
3858 23985 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 199 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   5992667.0832 2097455.8503 37.7387928750296 -122.467896678698 (37.7387928750296, -122.467896678698) 1 8 4 59 40
4901 23987 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 199 West Portal Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   5992682.0839 2097477.0777 37.7388520263377 -122.467846357266 (37.7388520263377, -122.467846357266) 1 8 4 59 40
6381 118299 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 275 OLYMPIA WAY 10 Sidewalk: Property side : Cutout Tree Private 2       3x3   5996383 2101914 37.7512477308097 -122.455370966371 (37.7512477308097, -122.455370966371) 1 5 4 63 38
6956 34828 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 1627 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/29/1997 12:00:00 AM     Permit Number 38458 5990549.21563661 2104310.17201234 37.7574905284103 -122.4757195858 (37.7574905284103, -122.4757195858) 1 8 4 56 12
7399 211883 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 99 San Anselmo Ave 2 Sidewalk: Curb side : Yard Tree Private 2     11 Width 8ft   5993091.26879 2096743.17249 37.7368605261804 -122.466378273942 (37.7368605261804, -122.466378273942) 1 8 4 59 40
8217 211895 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 42 San Anselmo Ave 2 Sidewalk: Curb side : Yard Tree Private 2     7 Width 8ft   5992673.51698 2096879.95929 37.7372119947217 -122.467832559536 (37.7372119947217, -122.467832559536) 1 8 4 59 40
9629 103219 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1600X 29th Ave 3 Sidewalk: Property side : Cutout Tree Rec/Park 5     11 3x4   5987198.2105 2103866.2266 37.7560767305116 -122.487275946944 (37.7560767305116, -122.487275946944) 1 8 3 56 35
9637 23993 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 288 West Portal Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1     13 3x3   5992331.2652 2097223.6221 37.7381358372367 -122.469040873258 (37.7381358372367, -122.469040873258) 1 8 4 59 40
11304 118290 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 275 OLYMPIA WAY 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5996383 2101914 37.7512477308097 -122.455370966371 (37.7512477308097, -122.455370966371) 1 5 4 63 38
11538 103186 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1601X 28th Ave 10 Sidewalk: Curb side : Cutout Tree Rec/Park 5     0 3x4   5987489 2103696 37.7556262873159 -122.486257815902 (37.7556262873159, -122.486257815902) 1 8 3 56 35
14560 181721 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1212 28th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   5987399.3466 2107057.8939 37.7648519023124 -122.486814726163 (37.7648519023124, -122.486814726163) 1 8 3 56 35
15014 23978 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 105 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     8 3X3   5992925.3504 2097716.3817 37.7395231391689 -122.467022655462 (37.7395231391689, -122.467022655462) 1 8 4 59 40
15337 23621 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 101X Vicente St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   5992915.3748684 2097772.2419641 37.7396759415931 -122.467061206395 (37.7396759415931, -122.467061206395) 1 8 4 59 40
16519 184107 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2299 Lawton St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   5987278.1739 2104361.4073 37.7574410246195 -122.487035775789 (37.7574410246195, -122.487035775789) 1 8 3 56 35
16739 211939 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 49 Marcela Ave 3 Sidewalk: Curb side : Yard Tree Private 2     9 Width 4ft   5994765.26662 2100732.0982 37.7479095716864 -122.460879577925 (37.7479095716864, -122.460879577925) 1 8 4 29491 40
16855 178604 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 0 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2     2     5988124.07873 2089803.353 37.7175176953569 -122.4830433365 (37.7175176953569, -122.4830433365) 1 8 4 64 14
17789 24002 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 301 West Portal Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   5992335.322527 2097130.166171 37.7378794652642 -122.469020045737 (37.7378794652642, -122.469020045737) 1 8 4 59 40
17806 211933 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 225 Pacheco St 1 Sidewalk: Curb side : Yard Tree Private 2     10 Width 4ft   5994452.61696 2100333.21821 37.7467963530792 -122.461931778432 (37.7467963530792, -122.461931778432) 1 8 4 29491 40
18671 23966 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 15 West Portal Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   11/13/2012 12:00:00 AM 12 3X3 Permit Number 769521 5993257.457595 2098116.538689 37.7406410333741 -122.465903450808 (37.7406410333741, -122.465903450808) 1 8 4 59 40
18807 23982 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 186 West Portal Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     9 3x3   5992611.7504 2097512.5983 37.738945495338 -122.468092118723 (37.738945495338, -122.468092118723) 1 8 4 59 40
18960 262582 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2801X 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5992317 2097142 37.7379108993029 -122.469084256099 (37.7379108993029, -122.469084256099) 1 8 4 59 40
19313 164 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 2790X 15th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     13 3x3   5991861.2323163 2096712.8875627 37.7367063200182 -122.470628807941 (37.7367063200182, -122.470628807941) 1 8 4 59 40
19843 23974 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 99 West Portal Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   5993014.5056 2097814.877 37.7397987281257 -122.466721556006 (37.7397987281257, -122.466721556006) 1 8 4 59 40
19876 291 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 3355 19th Ave 7 Sidewalk: Curb side : Cutout Tree DPW 1   05/10/1994 12:00:00 AM 20 2x10   5990518.29998 2093633.85413 37.7281743270786 -122.475047162015 (37.7281743270786, -122.475047162015) 1 8 4 64 14
20156 183702 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1343 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   5982736.6857 2105979.0791 37.7616168455095 -122.502861540497 (37.7616168455095, -122.502861540497) 1 8 3 56 35
20678 212769 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 101 Vicente St 3 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   5992862.56204 2097797.59669 37.7397425107158 -122.467245652071 (37.7397425107158, -122.467245652071) 1 8 4 59 40
20740 211911 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 160 San Anselmo Ave 2 Sidewalk: Curb side : Yard Tree Private 2     17 Width 8ft   5993445.46093 2096461.84446 37.7361085004973 -122.46513325792 (37.7361085004973, -122.46513325792) 1 8 4 59 40
20795 254779 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 700 Brotherhood Way 2 Sidewalk: Curb side : Cutout Tree Private 2       4x9   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
20921 118291 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 275 OLYMPIA WAY 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   5996383 2101914 37.7512477308097 -122.455370966371 (37.7512477308097, -122.455370966371) 1 5 4 63 38

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