trees

8,298 rows where qLegalStatus_id = 4 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)
767 100549 Undocumented 4 Acer spp :: Maple 88 290X Tehama St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 3x4                      
3669 103667 Undocumented 4 Tree(s) :: 17 350X Hickory St 6 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
4476 112909 Undocumented 4 Tree(s) :: 17 1899X Beach St 2 Sidewalk: Curb side : Cutout Tree Private 2                              
4983 112267 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X Geary St 1 Sidewalk: Curb side : Cutout Tree Private 2                              
5100 101532 Undocumented 4 Tree(s) :: 17 11323 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3                      
5748 115724 Undocumented 4 Syzygium paniculatum :: Brush Cherry 243 250x Octavia St 1 Side Yard : Yard Tree Dept of Real Estate 7                              
6238 103666 Undocumented 4 Tree(s) :: 17 350X Hickory St 5 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
7827 115725 Undocumented 4 Syzygium paniculatum :: Brush Cherry 243 250X Octavia St 2 Side Yard : Yard Tree Dept of Real Estate 7                              
9335 112908 Undocumented 4 Tree(s) :: 17 1899X Beach St 1 Sidewalk: Curb side : Cutout Tree Private 2                              
9557 112910 Undocumented 4 Tree(s) :: 17 1899X Beach St 3 Sidewalk: Curb side : Cutout Tree Private 2                              
10205 173902 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 601x Hearst Ave 2 Sidewalk: Curb side : Cutout Tree Private 2                              
10489 102839 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1101X Portola Dr 2 Sidewalk: Property side : Yard Tree DPW 1                              
10516 102842 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 1101X Portola Dr 8 Sidewalk: Property side : Yard Tree DPW 1                              
10813 100543 Undocumented 4 Acer spp :: Maple 88 290X Tehama St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 3x4                      
10916 108180 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 835 Sacramento St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3                      
10998 100001 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 501X 01st St 2 Sidewalk: Curb side : Pot Tree Private 2         Address is 100 1st Street                    
11335 112269 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X Geary St 3 Sidewalk: Curb side : Cutout Tree Private 2                              
12733 102843 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 1101X Portola Dr 10 Sidewalk: Property side : Yard Tree DPW 1                              
14524 99746 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 4250 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3                      
15154 102838 Undocumented 4 Pinus radiata :: Monterey Pine 15 1101X Portola Dr 1 Sidewalk: Property side : Yard Tree DPW 1                              
15233 109923 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 214 state st 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3                      
15258 103665 Undocumented 4 Tree(s) :: 17 350X Hickory St 4 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
16355 103663 Undocumented 4 Tree(s) :: 17 350X Hickory St 2 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
18064 103664 Undocumented 4 Tree(s) :: 17 350X Hickory St 3 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
18422 112268 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X Geary St 2 Sidewalk: Curb side : Cutout Tree Private 2                              
18674 103662 Undocumented 4 Tree(s) :: 17 350X Hickory St 1 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
61359 116892 Undocumented 4 Ficus laurel :: 247 2798X LYON ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999158 2118194 37.7961072882302 -122.446946138081 (37.7961072882302, -122.446946138081) 13   1 57 30
103178 107527 Undocumented 4 Populus alba :: White Poplar 184 2540x LYON ST 1 Unaccepted Street : Yard Tree Private 2     30   Permit Number 774117 5999227 2117510 37.7942331479636 -122.446658147156 (37.7942331479636, -122.446658147156) 13   1 57 30
231 116978 Undocumented 4 Grevillea robusta :: Silk Oak Tree 76 111 BAY ST 4 Front Yard : Yard Tree Private 2           6010550 2121704 37.8063891294227 -122.407774985143 (37.8063891294227, -122.407774985143) 3 1 10 308 23
233 100684 Undocumented 4 Tree(s) :: 17 400 California St 3 Sidewalk: Curb side : Pot Tree Private 2           6012367 2116823 37.7930886299645 -122.401143699021 (37.7930886299645, -122.401143699021) 4 1 10 28854 6
466 116275 Undocumented 4 :: 45 700X Greenwich St 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6009521.9 2120182.3 37.8021533125646 -122.411225360908 (37.8021533125646, -122.411225360908) 3 1 10 308 23
694 114020 Undocumented 4 Crateagus spp :: Hawthorn 130 1 HANGAH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010635 2117072 37.7936755489769 -122.407154109442 (37.7936755489769, -122.407154109442) 3 1 10 28857 4
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
1127 263624 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 980 Green St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008397 2119007 37.7988630807128 -122.415034830901 (37.7988630807128, -122.415034830901) 5 1 10 308 32
1376 263620 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 900 Beach St 3 Side Yard : Yard Tree DPW 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
1444 256097 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 2 North Point St 15 Sidewalk: Curb side : Cutout Tree Private 2   01/17/2020 12:12:00 PM 3 3x3   6010298.36751 2122029.07931 37.8072676263732 -122.408668755752 (37.8072676263732, -122.408668755752) 3 1 10 308 23
1841 113206 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 50x DASHIELL HAMMETT ST 2 Sidewalk: Curb side : Cutout Tree Private 2       2x2   6010410 2116139 37.7911011617465 -122.407866810246 (37.7911011617465, -122.407866810246) 5 1 10 28857 21
2261 101055 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 760 Geary St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008077 2114493 37.7864507606031 -122.415822330961 (37.7864507606031, -122.415822330961) 13 1 9 28858 36
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
3804 117402 Undocumented 4 Ficus nitida :: Laurel Fig 53 75x BEACH ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
4127 74230 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 1011 Kearny St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/1996 12:00:00 AM 10     6011143.4423 2118449.9882 37.7974876128867 -122.405491940883 (37.7974876128867, -122.405491940883) 3 1 10 308 23
4231 261663 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 1099x Broadway   Sidewalk: Curb side : Cutout Tree Private 2   10/28/2020 12:00:00 AM 3 3x3   6008393 2118190 37.7966195766837 -122.414990814528 (37.7966195766837, -122.414990814528) 5 1 10 308 21
4710 143042 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 443 LOMBARD ST 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6010246.7521 2120590.0026 37.8033133880365 -122.408745792286 (37.8033133880365, -122.408745792286) 3 1 10 308 23
4869 102616 Undocumented 4 Ulmus spp :: Elm Spp 98 2000X Stockton St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6009928.4 2120915.8 37.8041901109125 -122.409870477339 (37.8041901109125, -122.409870477339) 3 1 10 308 23
6858 261031 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 150 Chestnut St 1 Front Yard : Yard Tree Private 2       3x3   6011107 2121175 37.8049677916951 -122.405810090856 (37.8049677916951, -122.405810090856) 3 1 10 308 23
7298 108182 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 835 Sacramento St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010686.57825 2116924.79472 37.7932742451254 -122.406965263124 (37.7932742451254, -122.406965263124) 3 1 10 28857 4
7637 263625 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 980 Green St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008397 2119007 37.7988630807128 -122.415034830901 (37.7988630807128, -122.415034830901) 5 1 10 308 32
7669 101056 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 746 Geary St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008144 2114503 37.7864819845184 -122.415591235338 (37.7864819845184, -122.415591235338) 13 1 9 28858 36
8152 116289 Undocumented 4 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1901X Powell St 5 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6009504.70132 2120333.42493 37.8025672995432 -122.41129555893 (37.8025672995432, -122.41129555893) 3 1 10 308 23
9068 74830 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 493 Broadway 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/27/2013 12:00:00 AM   6x6 Permit Number 769961 6011188.26118785 2118621.30079081 37.7979605016561 -122.405348925503 (37.7979605016561, -122.405348925503) 3 1 10 308 23
9498 97930 Undocumented 4 Shrub :: Shrub 66 1615 Grant Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010461.1 2120070.1 37.801897866839 -122.40796734514 (37.801897866839, -122.40796734514) 3 1 10 308 23
9788 128384 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 109 Trenton St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6010084.71998 2117858.53397 37.7958043693257 -122.40911365939 (37.7958043693257, -122.40911365939) 3 1 10 308 4
9792 102746 Undocumented 4 Maytenus boaria :: Mayten 58 801 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009087.2 2119736.4 37.8009045934233 -122.412698096408 (37.8009045934233, -122.412698096408) 3 1 10 308 32
9892 258923 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 900 Hyde St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007771 2115657 37.7896296127826 -122.416963519552 (37.7896296127826, -122.416963519552) 13 1 10 28858 21
10172 100673 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 680X Francisco St 4 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6008043.6 2121019.4 37.804368760788 -122.41640033173 (37.804368760788, -122.41640033173) 5 1 10 308 32
10225 263619 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 900 Beach St 2 Side Yard : Yard Tree DPW 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
10228 142720 Undocumented 4 :: 45 1170 COLUMBUS AVE 3 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   6007999.4825 2121188.7351 37.8048312311886 -122.416565007078 (37.8048312311886, -122.416565007078) 5 1 10 308 23
10567 263621 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 900 Beach St 4 Side Yard : Yard Tree DPW 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
10735 121071 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 600x Sansome St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012133 2117811 37.7957883852557 -122.402022845886 (37.7957883852557, -122.402022845886) 3 1 10 28860 4
11053 116828 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 15 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
11284 117186 Undocumented 4 Ficus nitida :: Laurel Fig 53 201x GREENWICH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6011833 2120374 37.8028090150843 -122.40324129087 (37.8028090150843, -122.40324129087) 3 1 10 308 23
11426 113463 Undocumented 4 Ficus Spp. :: 101 18X LEROY PL 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008359 2116564 37.7921530708525 -122.414993316892 (37.7921530708525, -122.414993316892) 5 1 10 28858 21
11694 263618 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 900 Beach St 1 Side Yard : Yard Tree DPW 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
11921 263623 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 980 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008397 2119007 37.7988630807128 -122.415034830901 (37.7988630807128, -122.415034830901) 5 1 10 308 32
12765 117400 Undocumented 4 Ficus nitida :: Laurel Fig 53 75x BEACH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
13581 113413 Undocumented 4 Ficus nitida :: Laurel Fig 53 16X LEROY PL 1 Sidewalk: Curb side : Cutout Tree Private 2     7 1x1   6008359 2116497 37.7919691052865 -122.414988572568 (37.7919691052865, -122.414988572568) 5 1 10 28858 21
13714 116827 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 14 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
13947 109612 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 311x DAVIS ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013158 2117662 37.7954364211004 -122.398465672767 (37.7954364211004, -122.398465672767) 3 1 10 28860 6
14985 113673 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 500X THE EMBARCADERO 7 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6013440 2119057 37.7992824654164 -122.3975877866 (37.7992824654164, -122.3975877866) 3 1 10 28860 6
15292 116408 Undocumented 4 Elaeocarpus decipiens :: Japanese Blueberry Tree 321 600x GRANT AVE 2 Sidewalk: Curb side : Pot Tree Private 2           6011037 2116673 37.7926024798136 -122.405735030164 (37.7926024798136, -122.405735030164) 3 1 10 28857 4
15677 255256 Undocumented 4 Acer rubrum :: Red Maple 75 240 Pacific Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   04/27/2018 12:00:00 AM 3 3x3   6012609 2118531 37.797791888474 -122.400426386373 (37.797791888474, -122.400426386373) 3 1 10 28860 6
15734 102859 Undocumented 4 Tree(s) :: 17 696 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6009251 2115330 37.7888148901218 -122.411819735773 (37.7888148901218, -122.411819735773) 5 1 10 28852 21
16200 103940 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2300 Mason St 4 Sidewalk: Curb side : Cutout Tree Private 2           6008943.2 2121170.5 37.804834190774 -122.413297871125 (37.804834190774, -122.413297871125) 3 1 10 308 23
16204 114507 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 10 LOMBARD ST 2 Back Yard : Cutout Tree Port 6       4x4   6011932 2120995 37.8045196580749 -122.402942401468 (37.8045196580749, -122.402942401468) 3 1 10 28860 6
16826 116366 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 100x SACRAMENTO ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013491 2117477 37.7949470000015 -122.397300449207 (37.7949470000015, -122.397300449207) 3 1 10 28860 6
18062 264811 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 1420 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/20/2020 12:00:00 AM 3 3x3   6008504 2117376 37.7943907703496 -122.414549098287 (37.7943907703496, -122.414549098287) 5 1 10 28857 21
19899 109490 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1315x PINE ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007628 2115744 37.789860448493 -122.417464454457 (37.789860448493, -122.417464454457) 13 1 10 28858 21
20003 99987 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 535@Clay Washington St 5 Sidewalk: Curb side : Cutout Tree Private 2           6012018 2117734 37.7955705425922 -122.402415352518 (37.7955705425922, -122.402415352518) 3 1 10 28860 4
20131 113298 Undocumented 4 Ficus nitida :: Laurel Fig 53 700X DAVIS ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013208 2119104 37.7993985951424 -122.398393892143 (37.7993985951424, -122.398393892143) 3 1 10 28860 6
20147 103506 Undocumented 4 Ficus nitida :: Laurel Fig 53 1348 Sacramento St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6008356 2116660 37.7924164947138 -122.415010494885 (37.7924164947138, -122.415010494885) 5 1 10 28858 21
20155 98985 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 847 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009438.4 2115684 37.7897973999496 -122.411196371815 (37.7897973999496, -122.411196371815) 5 1 10 28857 21
20469 114842 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2670 LEAVENWORTH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007398 2121652 37.8060693936166 -122.418679378695 (37.8060693936166, -122.418679378695) 5 1 1 308 23
21026 114508 Undocumented 4 Maytenus boaria :: Mayten 58 10 LOMBARD ST 3 Back Yard : Cutout Tree Port 6       4x4   6011932 2120995 37.8045196580749 -122.402942401468 (37.8045196580749, -122.402942401468) 3 1 10 28860 6
21249 112640 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 299X STOCKTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     15 6x9   6010693 2115178 37.7884783251045 -122.406819877074 (37.7884783251045, -122.406819877074) 5 1 10 28852 6
21701 113690 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 1 WALTER U LUM PL 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010972 2117336 37.7944192831765 -122.406006661324 (37.7944192831765, -122.406006661324) 3 1 10 28857 4
22546 122826 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 201x Broadway 2 Sidewalk: Curb side : Cutout Tree Private 2       9x6   6012272 2118721 37.7982947840288 -122.401605868068 (37.7982947840288, -122.401605868068) 3 1 10 28860 6
22667 116824 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 11 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
22799 101714 Undocumented 4 Melaleuca ericifolia :: Heath Melaleuca 151 1240 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2           6006918 2119116 37.7990791449181 -122.420160405591 (37.7990791449181, -122.420160405591) 5 1 1 28858 32
23186 103507 Undocumented 4 Callistemon viminalis :: Weeping Bottlebrush 60 100X Leroy Pl 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6008356 2116660 37.7924164947138 -122.415010494885 (37.7924164947138, -122.415010494885) 5 1 10 28858 21
23377 100670 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 680X Francisco St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6008043.6 2121019.4 37.804368760788 -122.41640033173 (37.804368760788, -122.41640033173) 5 1 10 308 32
24272 117475 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 1200x MONTGOMERY ST 2 Unaccepted Street : Cutout Tree Private 2           6011580 2119440 37.800230345698 -122.404051036068 (37.800230345698, -122.404051036068) 3 1 10 308 23
24458 121068 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 600x Sansome St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012133 2117811 37.7957883852557 -122.402022845886 (37.7957883852557, -122.402022845886) 3 1 10 28860 4
25618 101054 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 760 Geary St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008077 2114493 37.7864507606031 -122.415822330961 (37.7864507606031, -122.415822330961) 13 1 9 28858 36
26567 110786 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 410 PACIFIC AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012080 2118442 37.7975180016372 -122.402250623365 (37.7975180016372, -122.402250623365) 3 1 10 308 23
26574 100103 Undocumented 4 Pittosporum crassifolium :: Karo Tree 95 461 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2           6007004.8 2122229.7 37.8076334645768 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
26828 255255 Undocumented 4 Acer rubrum :: Red Maple 75 240 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   04/27/2018 12:00:00 AM 3 3x3   6012609 2118531 37.797791888474 -122.400426386373 (37.797791888474, -122.400426386373) 3 1 10 28860 6
26923 101895 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 590X Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011780 2117743.1 37.795582240012 -122.403239519119 (37.795582240012, -122.403239519119) 3 1 10 28860 4
27591 113681 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 500X THE EMBARCADERO 15 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6013440 2119057 37.7992824654164 -122.3975877866 (37.7992824654164, -122.3975877866) 3 1 10 28860 6
28305 121625 Undocumented 4 Ficus nitida :: Laurel Fig 53 101x Trenton St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010049 2117862 37.7958118850813 -122.409237502382 (37.7958118850813, -122.409237502382) 3 1 10 308 4
28490 111716 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 2390x MASON ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008938 2121373 37.8053899130211 -122.413330195558 (37.8053899130211, -122.413330195558) 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)
);