trees

Custom SQL query returning 28 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
61387 114840 6 70 2455x HYDE ST   Sidewalk: Curb side : Cutout Tree 8     12 3x3   6006980 2120877 37.8039178984324 -122.420070904619 (37.8039178984324, -122.420070904619) 5 1 1 28858 32
6580 261206 6 41 2301 Leavenworth St 1 Side Yard : Yard Tree 2       3x3   6007514 2120271 37.8022840477627 -122.418179969724 (37.8022840477627, -122.418179969724) 5 1 1 28858 32
9964 262274 6 155 4 Montclair Ter 1 Side Yard : Yard Tree 2           6007298.70359 2120216.09204 37.8021211637502 -122.418921105258 (37.8021211637502, -122.418921105258) 5 1 1 28858 32
45867 107185 6 19 10 Florence St 1 Front Yard : Cutout Tree 2         Permit Number 773363 6008515.42073 2118375.20615 37.7971349853662 -122.41458032272 (37.7971349853662, -122.41458032272) 5 1 10 308 21
70399 121205 6 96 930 Chestnut St 1 Front Yard : Yard Tree 2     20 3x3   6007386.5238 2120591.43483 37.8031567047665 -122.418643837145 (37.8031567047665, -122.418643837145) 5 1 1 28858 32
71235 98244 6 86 901 Bay St 1 Front Yard : Yard Tree 2     5     6006420.63185 2121080.7781 37.8044458892203 -122.422021121489 (37.8044458892203, -122.422021121489) 5 1 1 28858 32
80380 114184 6 17 2454 HYDE ST 1 Front Yard : Cutout Tree 2   01/07/2016 12:00:00 AM   30x30 Permit Number 776893 6007060 2120781 37.8036588138585 -122.41978724304 (37.8036588138585, -122.41978724304) 5 1 1 28858 32
83429 112481 6 58 1275 Columbus Ave 1 Front Yard : Yard Tree 2   08/03/2015 12:00:00 AM       6007539.6 2121483.9 37.8056158049656 -122.418177422209 (37.8056158049656, -122.418177422209) 5 1 1 308 32
124108 258218 6 9 1000 North Point St 1 Sidewalk: Property side : Yard Tree 2           6005937.91741 2121414.48699 37.8053349315385 -122.423715341013 (37.8053349315385, -122.423715341013) 5 1 1 28858 32
147624 121449 6 16 1274 Filbert St 1 Front Yard : Yard Tree 2     12 10x6   6006927.94593 2119481.89109 37.800084349978 -122.420151970562 (37.800084349978, -122.420151970562) 5 1 1 28858 32
151937 251657 6 15 1050 North Point St 1 Sidewalk: Curb side : Cutout Tree 2       6x6   6005628 2121390 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187) 5 1 1 28858 32
163986 121133 6 15 1050 North Point St 1 Front Yard : Yard Tree 2     20 3x10   6005628 2121390 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187) 5 1 1 28858 32
178107 251661 6 9 3200X Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree 2       6x6   6005628 2121390 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187) 5 1 1 28858 32
31713 107635 6 7 1150 Lombard St 10 Front Yard : Yard Tree 2   10/01/2014 12:00:00 AM 3   Permit Number 773092 6006825.00646 2120436.80144 37.8027004912885 -122.420576003873 (37.8027004912885, -122.420576003873) 5 1 1 28858 32
15016 261205 6 36 2301 Leavenworth St 2 Side Yard : Yard Tree 2       3x3   6007514 2120271 37.8022840477627 -122.418179969724 (37.8022840477627, -122.418179969724) 5 1 1 28858 32
83898 112482 6 36 1275 Columbus Ave 2 Front Yard : Yard Tree 2   08/03/2015 12:00:00 AM       6007539.6 2121483.9 37.8056158049656 -122.418177422209 (37.8056158049656, -122.418177422209) 5 1 1 308 32
103238 121134 6 15 1050 North Point St 2 Front Yard : Yard Tree 2       3x10   6005628 2121390 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187) 5 1 1 28858 32
143771 251658 6 9 1050 North Point St 2 Sidewalk: Curb side : Cutout Tree 2       6x6   6005628 2121390 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187) 5 1 1 28858 32
171699 121206 6 14 930 Chestnut St 2 Sidewalk: Curb side : Cutout Tree 2   11/22/2016 12:00:00 AM 3 3x3 Permit Number 778903 6007356.48577 2120579.52821 37.8031223210123 -122.418746939923 (37.8031223210123, -122.418746939923) 5 1 1 28858 32
8743 261207 6 326 2301 Leavenworth St 3 Side Yard : Yard Tree 2       3x3   6007514 2120271 37.8022840477627 -122.418179969724 (37.8022840477627, -122.418179969724) 5 1 1 28858 32
93101 251659 6 9 1050 North Point St 3 Sidewalk: Curb side : Cutout Tree 2       6x6   6005628 2121390 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187) 5 1 1 28858 32
123789 112483 6 36 1275 Columbus Ave 3 Front Yard : Yard Tree 2   08/03/2015 12:00:00 AM       6007539.6 2121483.9 37.8056158049656 -122.418177422209 (37.8056158049656, -122.418177422209) 5 1 1 308 32
32951 112484 6 52 1275 Columbus Ave 4 Front Yard : Yard Tree 2   08/03/2015 12:00:00 AM       6007539.6 2121483.9 37.8056158049656 -122.418177422209 (37.8056158049656, -122.418177422209) 5 1 1 308 32
51973 106945 6 11 1150 LOMBARD ST 4 Front Yard : Yard Tree 2     13   Permit Number 773092 6006825 2120436.8 37.8027004869705 -122.420576026126 (37.8027004869705, -122.420576026126) 5 1 1 28858 32
157788 251660 6 15 1050 North Point St 4 Sidewalk: Curb side : Cutout Tree 2       6x6   6005628 2121390 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187) 5 1 1 28858 32
115879 112485 6 52 1275 Columbus Ave 5 Front Yard : Yard Tree 2   08/03/2015 12:00:00 AM       6007539.6 2121483.9 37.8056158049656 -122.418177422209 (37.8056158049656, -122.418177422209) 5 1 1 308 32
167115 112487 6 52 1275 Columbus Ave 7 Front Yard : Yard Tree 2           6007539.6 2121483.9 37.8056158049656 -122.418177422209 (37.8056158049656, -122.418177422209) 5 1 1 308 32
157517 112488 6 52 1275 Columbus Ave 8 Front Yard : Yard Tree 2           6007539.6 2121483.9 37.8056158049656 -122.418177422209 (37.8056158049656, -122.418177422209) 5 1 1 308 32