trees

Custom SQL query returning 16 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
5158 116663 1 287 199x Esmeralda Ave 16 Unaccepted Street : Yard Tree 1           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452) 2 7 7 28859 2
21308 186403 1 287 1801 Sunset Blvd 70 Sidewalk: Property side : Yard Tree 2     3 Width 0ft   5984820.922 2102312.2628 37.7516710584533 -122.495382684544 (37.7516710584533, -122.495382684544) 1 8 3 56 35
32221 186190 1 287 1701 Sunset Blvd 1 Sidewalk: Property side : Yard Tree 2     3 Width 0ft   5984778.3318 2103573.7698 37.7551323147484 -122.495623003209 (37.7551323147484, -122.495623003209) 1 8 3 56 35
48197 76514 7 287 1000 Tompkins Ave 4 Sidewalk: Curb side : Cutout Tree 2   06/13/2016 12:00:00 AM 3 3x3 Permit Number 778440 6009284.86795875 2096393.41418024 37.7368212561993 -122.41036493916 (37.7368212561993, -122.41036493916) 10 7 7 28859 2
58962 185390 1 287 2300 Sunset Blvd 1 unknown : Yard Tree 2     2 Width 0ft   5985092.6382 2098924.4627 37.7423849872747 -122.4941933909 (37.7423849872747, -122.4941933909) 1 8 3 29491 35
68469 116068 1 287 4150X CLEMENT ST 2 Front Yard : Yard Tree 1     3 3x3   5983115 2113126 37.7812624555251 -122.502082001527 (37.7812624555251, -122.502082001527) 11 6 2 55 15
73855 20774 1 287 1701X Sunset Blvd 1 Sidewalk: Curb side : Cutout Tree 1     2     5984888.092725 2103630.7874996 37.7552952964732 -122.49524762816 (37.7552952964732, -122.49524762816) 1 8 3 56 35
102814 186044 1 287 1900 Sunset Blvd 39 Sidewalk: Property side : Yard Tree 2     2 Width 0ft   5985010.438 2102178.2104 37.7513140820988 -122.494717441079 (37.7513140820988, -122.494717441079) 1 8 3 29491 35
122345 184886 1 287 1201 Sunset Blvd 76 Sidewalk: Property side : Yard Tree 2     1 Width 0ft   5984683.9949 2106763.6802 37.7638853936031 -122.496184581552 (37.7638853936031, -122.496184581552) 1 8 3 56 35
126481 186563 1 287 1501 Sunset Blvd 34 unknown : Yard Tree 2     1 Width 0ft   5984717.9132 2104705.2165 37.7582354149831 -122.495915407531 (37.7582354149831, -122.495915407531) 1 8 3 56 35
127295 186116 1 287 1700 Sunset Blvd 1 Sidewalk: Property side : Yard Tree 2     2 Width 0ft   5984983.194 2103006.193 37.7535858999024 -122.49487269449 (37.7535858999024, -122.49487269449) 1 8 3 56 35
134258 186323 1 287 1800 Sunset Blvd 61 Sidewalk: Property side : Yard Tree 2     2 Width 0ft   5984977.2414 2102887.891 37.7532607267541 -122.4948845576 (37.7532607267541, -122.4948845576) 1 8 3 56 35
135022 185581 1 287 2201 Sunset Blvd 65 Sidewalk: Property side : Yard Tree 2     2 Width 0ft   5984892.0445 2099593.3004 37.7442096942241 -122.494936277947 (37.7442096942241, -122.494936277947) 1 8 3 29491 35
161602 124181 1 287 18 Almaden Ct 6 Sidewalk: Property side : Yard Tree 2     2 Width 9ft   5995866.53824 2112606.84156 37.7805778644243 -122.457930655785 (37.7805778644243, -122.457930655785) 11 6 2 54 16
167399 186264 1 287 1800 Sunset Blvd 2 Sidewalk: Property side : Yard Tree 2     2 Width 0ft   5985008.2513 2102330.1154 37.751731043534 -122.49473620106 (37.751731043534, -122.49473620106) 1 8 3 56 35
173974 251394 6 287 203 Corbett Ave 1 Front Yard : Yard Tree 2   05/30/2017 12:00:00 AM 3 3x3 Permit Number 779803 6000094 2105620 37.7616357315689 -122.442804047122 (37.7616357315689, -122.442804047122) 15 5 5 28862 3