trees

11,635 rows where qSpecies_id = 27 sorted by XCoord

✎ 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                    
79055 68576 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 32 Sutro Heights Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/1993 12:00:00 AM 7   Permit Number 32469 5981483.59375 2111332.33196 37.7762415958941 -122.507592631969 (37.7762415958941, -122.507592631969) 11 6 2 55 26
70528 118510 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 8137 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 5ft   5981731.77881 2112327.0562 37.7789874331261 -122.50680790507 (37.7789874331261, -122.50680790507) 11 6 2 55 26
33327 39821 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2101 46th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/06/1999 12:00:00 AM 3   Permit Number 41148 5981982.6078 2100745.8281 37.7472034694978 -122.505081701882 (37.7472034694978, -122.505081701882) 1 8 3 29491 35
93962 47445 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 811 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM 7   Permit Number 45355 5982594.30489 2110210.15333 37.7732257896796 -122.503667318467 (37.7732257896796, -122.503667318467) 11 6 2 55 26
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
95127 183703 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1343 43rd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   5982737.637 2105959.1018 37.7615620494337 -122.502856771493 (37.7615620494337, -122.502856771493) 1 8 3 56 35
183760 67224 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 6400 Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1992 12:00:00 AM 6   Permit Number 30683 5983507.38436 2109708.43135 37.7719018478529 -122.500471801712 (37.7719018478529, -122.500471801712) 11 6 2 55 26
153025 57999 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 871 40th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/18/1977 12:00:00 AM 19   Permit Number 16964 5983538.74255 2109889.72287 37.772401462891 -122.500376739285 (37.772401462891, -122.500376739285) 11 6 2 55 26
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
24222 12455 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 200X Lake Merced Blvd 6 Median : Cutout Tree DPW 1     3 6   5983914.9541303 2094860.2401332 37.7311567434968 -122.497965345854 (37.7311567434968, -122.497965345854) 1 8 4 64 35
30330 12454 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 200X Lake Merced Blvd 5 Median : Cutout Tree DPW 1     3 6   5983914.9541303 2094860.2401332 37.7311567434968 -122.497965345854 (37.7311567434968, -122.497965345854) 1 8 4 64 35
69807 12452 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 200X Lake Merced Blvd 3 Median : Cutout Tree DPW 1     3 6   5983914.9541303 2094860.2401332 37.7311567434968 -122.497965345854 (37.7311567434968, -122.497965345854) 1 8 4 64 35
120064 12451 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 200X Lake Merced Blvd 2 Median : Cutout Tree DPW 1     3 6   5983914.9541303 2094860.2401332 37.7311567434968 -122.497965345854 (37.7311567434968, -122.497965345854) 1 8 4 64 35
153638 12453 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 200X Lake Merced Blvd 4 Median : Cutout Tree DPW 1     3 6   5983914.9541303 2094860.2401332 37.7311567434968 -122.497965345854 (37.7311567434968, -122.497965345854) 1 8 4 64 35
61374 117894 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 559 38th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   5984080.21374 2112029.04271 37.7783071869826 -122.498661831158 (37.7783071869826, -122.498661831158) 11 6 2 55 26
138313 183712 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 3733 Lincoln Way 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5984088.4104 2106972.4655 37.7644237543554 -122.498259918056 (37.7644237543554, -122.498259918056) 1 8 3 56 35
160876 183713 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 3733 Lincoln Way 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   5984106.6873 2106973.5567 37.7644278221565 -122.498196784885 (37.7644278221565, -122.498196784885) 1 8 3 56 35
68892 102368 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 851 38th Ave 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5     4   Permit Number 769895 5984151.13176 2110133.93549 37.7731079279349 -122.49827649972 (37.7731079279349, -122.49827649972) 11 6 2 55 26
46680 102369 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 851 38th Ave 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5     12   Permit Number 769895 5984151.59861 2110096.53732 37.773005270668 -122.498272122211 (37.773005270668, -122.498272122211) 11 6 2 55 26
86758 102372 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 851 38th Ave 4 Sidewalk: Curb side : Cutout Tree Rec/Park 5     3   Permit Number 769895 5984152.56349 2110057.09296 37.7728970243511 -122.498265870843 (37.7728970243511, -122.498265870843) 11 6 2 55 26
123981 102370 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 851 38th Ave 5 Sidewalk: Curb side : Cutout Tree Rec/Park 5     3   Permit Number 769895 5984153.18727 2110032.649 37.7728299448261 -122.498261907462 (37.7728299448261, -122.498261907462) 11 6 2 55 26
56700 102371 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 851 38th Ave 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5     3   Permit Number 769895 5984153.68011 2110075.48808 37.7729475975471 -122.498263367238 (37.7729475975471, -122.498263367238) 11 6 2 55 26
164210 102379 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 851 38th Ave 6 Sidewalk: Curb side : Cutout Tree Rec/Park 5     3     5984156.57881 2110013.67242 37.7727780394481 -122.49824877412 (37.7727780394481, -122.49824877412) 11 6 2 55 26
25869 102376 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 851 38th Ave 7 Sidewalk: Curb side : Cutout Tree Rec/Park 5     12     5984157.51207 2109978.36457 37.7726811489417 -122.498242937742 (37.7726811489417, -122.498242937742) 11 6 2 55 26
185902 184819 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1201 Sunset Blvd 8 Sidewalk: Property side : Yard Tree Private 2     14 Width 0ft   5984690.0704 2106941.5787 37.7643742087001 -122.496176694676 (37.7643742087001, -122.496176694676) 1 8 3 56 35
68308 184818 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1201 Sunset Blvd 7 Sidewalk: Property side : Yard Tree Private 2     14 Width 0ft   5984694.627 2106957.5269 37.7644182648708 -122.49616211163 (37.7644182648708, -122.49616211163) 1 8 3 56 35
138861 184890 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1201 Sunset Blvd 1 Sidewalk: Property side : Yard Tree Private 2     14 Width 0ft   5984711.7144 2106963.4126 37.7644354262232 -122.496103446187 (37.7644354262232, -122.496103446187) 1 8 3 56 35
87171 118267 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 675 36th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 2ft   5984728.94591 2111276.55423 37.776279095764 -122.496362122462 (37.776279095764, -122.496362122462) 11 6 2 55 26
98489 118268 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 675 36th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   5984729.81712 2111254.48497 37.7762185509537 -122.496357479966 (37.7762185509537, -122.496357479966) 11 6 2 55 26
39958 20469 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1203X Sunset Blvd 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5     12 40   5984781.3005655 2107242.2257009 37.7652050441375 -122.495883339617 (37.7652050441375, -122.495883339617) 11 6 2 55 8
145909 20476 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1203X Sunset Blvd 10 Sidewalk: Curb side : Cutout Tree Rec/Park 5     12 40   5984781.3005655 2107242.2257009 37.7652050441375 -122.495883339617 (37.7652050441375, -122.495883339617) 11 6 2 55 8
156373 20467 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1203X Sunset Blvd 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5     12 40   5984781.3005655 2107242.2257009 37.7652050441375 -122.495883339617 (37.7652050441375, -122.495883339617) 11 6 2 55 8
32831 20504 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1203X Sunset Blvd 13 Sidewalk: Curb side : Cutout Tree Rec/Park 5   03/02/1991 12:00:00 AM 18 10   5984781.8902056 2107224.2505442 37.7651557239541 -122.495879974111 (37.7651557239541, -122.495879974111) 11 6 2 55 8
100851 256441 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 3001 Sunset Blvd 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5984950 2095029 37.7316807417675 -122.494399498116 (37.7316807417675, -122.494399498116) 1 8 4 64 35
149777 256440 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 3001 Sunset Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5984950 2095029 37.7316807417675 -122.494399498116 (37.7316807417675, -122.494399498116) 1 8 4 64 35
161054 256439 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 3001 Sunset Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5984950 2095029 37.7316807417675 -122.494399498116 (37.7316807417675, -122.494399498116) 1 8 4 64 35
162804 256442 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 3001 Sunset Blvd 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5984950 2095029 37.7316807417675 -122.494399498116 (37.7316807417675, -122.494399498116) 1 8 4 64 35
168096 256438 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 3001 Sunset Blvd 26 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
65451 118256 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 747 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   5985057.16315 2110772.73924 37.774914985746 -122.49518958386 (37.774914985746, -122.49518958386) 11 6 2 55 26
70890 118255 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 747 35th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   5985057.6853 2110754.64892 37.7748653454703 -122.49518644334 (37.7748653454703, -122.49518644334) 11 6 2 55 26
105751 21495 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2792X Sunset Blvd 16 Sidewalk: Curb side : Cutout Tree DPW 1     18 60   5985060.3629888 2096294.4798015 37.7351618711636 -122.49411119238 (37.7351618711636, -122.49411119238) 1 8 3 29491 35
11363 78048 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 783 35th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     5985063.43296 2110545.25732 37.7742907524801 -122.495151117096 (37.7742907524801, -122.495151117096) 11 6 2 55 26
9957 78350 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 764 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5985108.45002 2110660.38164 37.7746094864044 -122.495003887719 (37.7746094864044, -122.495003887719) 11 6 2 55 26
2711 69872 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 799x 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6 3x3   5985114.18885 2110476.07325 37.7741037641519 -122.494970443436 (37.7741037641519, -122.494970443436) 11 6 2 55 26
152068 186920 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2700 Sunset Blvd 69 Sidewalk: Property side : Yard Tree Private 2     16 Width 0ft   5985200.7204 2096727.014 37.7363577067767 -122.493657794712 (37.7363577067767, -122.493657794712) 1 8 3 29491 35

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