trees

Custom SQL query returning 46 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
172437 114814 4 76 425 MIRAMAR AVE 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5995324 2092533 37.725428993141 -122.458354138636 (37.725428993141, -122.458354138636) 9 7 4 28861 40
122522 104229 1 76 1407 Shafter Ave 1 Sidewalk: Curb side : Cutout Tree 2     13 3x3   6015911.2715 2093397.2059 37.7289635043811 -122.387245408097 (37.7289635043811, -122.387245408097) 10 3 8 58 1
35258 86973 7 76 3274 26th St 3 Sidewalk: Curb side : Cutout Tree 2   11/27/2007 12:00:00 AM   3x3 Permit Number 49936 6007899 2100950 37.7492548435872 -122.415479005477 (37.7492548435872, -122.415479005477) 2 4 7 28859 19
82297 86981 7 76 3274 26th St 11 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 49936 6007899 2100950 37.7492548435872 -122.415479005477 (37.7492548435872, -122.415479005477) 2 4 7 28859 19
91269 86980 7 76 3274 26th St 10 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 49936 6007899 2100950 37.7492548435872 -122.415479005477 (37.7492548435872, -122.415479005477) 2 4 7 28859 19
93594 86971 7 76 3274 26th St 1 Sidewalk: Curb side : Cutout Tree 2   11/27/2007 12:00:00 AM   3x3 Permit Number 49936 6007899 2100950 37.7492548435872 -122.415479005477 (37.7492548435872, -122.415479005477) 2 4 7 28859 19
98436 86979 7 76 3274 26th St 9 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 49936 6007899 2100950 37.7492548435872 -122.415479005477 (37.7492548435872, -122.415479005477) 2 4 7 28859 19
113375 86975 7 76 3274 26th St 5 Sidewalk: Curb side : Cutout Tree 2   11/27/2007 12:00:00 AM   3x3 Permit Number 49936 6007899 2100950 37.7492548435872 -122.415479005477 (37.7492548435872, -122.415479005477) 2 4 7 28859 19
143123 86974 7 76 3274 26th St 4 Sidewalk: Curb side : Cutout Tree 2   11/27/2007 12:00:00 AM   3x3 Permit Number 49936 6007899 2100950 37.7492548435872 -122.415479005477 (37.7492548435872, -122.415479005477) 2 4 7 28859 19
145078 86977 7 76 3274 26th St 7 Sidewalk: Curb side : Cutout Tree 2   11/27/2007 12:00:00 AM   3x3 Permit Number 49936 6007899 2100950 37.7492548435872 -122.415479005477 (37.7492548435872, -122.415479005477) 2 4 7 28859 19
151319 86978 7 76 3274 26th St 8 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 49936 6007899 2100950 37.7492548435872 -122.415479005477 (37.7492548435872, -122.415479005477) 2 4 7 28859 19
157552 86976 7 76 3274 26th St 6 Sidewalk: Curb side : Cutout Tree 2   11/27/2007 12:00:00 AM   3x3 Permit Number 49936 6007899 2100950 37.7492548435872 -122.415479005477 (37.7492548435872, -122.415479005477) 2 4 7 28859 19
193431 86972 7 76 3274 26th St 2 Sidewalk: Curb side : Cutout Tree 2   11/27/2007 12:00:00 AM   3x3 Permit Number 49936 6007899 2100950 37.7492548435872 -122.415479005477 (37.7492548435872, -122.415479005477) 2 4 7 28859 19
68076 115541 4 76 780 DOUGLASS ST 1 Sidewalk: Property side : Yard Tree 5     24 3x3   6001139 2101871 37.7514014062737 -122.438921147793 (37.7514014062737, -122.438921147793) 2 4 5 28862 22
73983 115542 4 76 780 DOUGLASS ST 2 Sidewalk: Property side : Yard Tree 5       3x3   6001139 2101871 37.7514014062737 -122.438921147793 (37.7514014062737, -122.438921147793) 2 4 5 28862 22
105860 115545 4 76 780 DOUGLASS ST 5 Sidewalk: Property side : Yard Tree 5       3x3   6001139 2101871 37.7514014062737 -122.438921147793 (37.7514014062737, -122.438921147793) 2 4 5 28862 22
116358 115543 4 76 780 DOUGLASS ST 3 Sidewalk: Property side : Yard Tree 5       3x3   6001139 2101871 37.7514014062737 -122.438921147793 (37.7514014062737, -122.438921147793) 2 4 5 28862 22
126223 115546 4 76 780 DOUGLASS ST 6 Sidewalk: Property side : Yard Tree 5       3x3   6001139 2101871 37.7514014062737 -122.438921147793 (37.7514014062737, -122.438921147793) 2 4 5 28862 22
183770 115544 4 76 780 DOUGLASS ST 4 Sidewalk: Property side : Yard Tree 5       3x3   6001139 2101871 37.7514014062737 -122.438921147793 (37.7514014062737, -122.438921147793) 2 4 5 28862 22
191751 115547 4 76 780 DOUGLASS ST 7 Sidewalk: Property side : Yard Tree 5       3x3   6001139 2101871 37.7514014062737 -122.438921147793 (37.7514014062737, -122.438921147793) 2 4 5 28862 22
476 102238 4 76 1104 York St 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6009987 2102770 37.7543693005663 -122.408386989199 (37.7543693005663, -122.408386989199) 2 4 7 28859 19
29342 102237 4 76 1104 York St 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6009987 2102770 37.7543693005663 -122.408386989199 (37.7543693005663, -122.408386989199) 2 4 7 28859 19
94627 102236 4 76 1104 York St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6009987 2102770 37.7543693005663 -122.408386989199 (37.7543693005663, -122.408386989199) 2 4 7 28859 19
122488 102241 4 76 1104 York St 6 Sidewalk: Curb side : Cutout Tree 2       3x3   6009987 2102770 37.7543693005663 -122.408386989199 (37.7543693005663, -122.408386989199) 2 4 7 28859 19
175648 102239 4 76 1104 York St 5 Sidewalk: Curb side : Cutout Tree 2       3x3   6009987 2102770 37.7543693005663 -122.408386989199 (37.7543693005663, -122.408386989199) 2 4 7 28859 19
26694 102243 4 76 2819X 23rd St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6009900.7 2102774.7 37.7543773725694 -122.408685769544 (37.7543773725694, -122.408685769544) 2 4 7 28859 19
92752 102244 4 76 2819X 23rd St 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6009900.7 2102774.7 37.7543773725694 -122.408685769544 (37.7543773725694, -122.408685769544) 2 4 7 28859 19
172440 102242 4 76 2819 23RD ST 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6009900.7 2102774.7 37.7543773725694 -122.408685769544 (37.7543773725694, -122.408685769544) 2 4 7 28859 19
107936 87243 7 76 4596 17th St   Sidewalk: Curb side : Cutout Tree 2   02/19/2008 12:00:00 AM   3x3 Permit Number 50272 5998987.2 2105752.4 37.7619361087935 -122.446641530352 (37.7619361087935, -122.446641530352) 15 5 5 29492 9
172555 120560 6 76 17X Castro St 1 Back Yard : Yard Tree 2       3x3   6002113 2108564 37.7698341292575 -122.436031827668 (37.7698341292575, -122.436031827668) 15 5 5 29492 9
191800 108007 1 76 520 Hayes St 5 Sidewalk: Curb side : Cutout Tree 2     18 3x3   6005276.0229 2110986.1475 37.7766639452468 -122.425263382021 (37.7766639452468, -122.425263382021) 7 9 11 28852 10
47310 255326 4 76 1003x Turk St 1 Sidewalk: Property side : Cutout Tree 1       3x3   6005211 2112640 37.7812013451486 -122.425606050794 (37.7812013451486, -122.425606050794) 7 9 11 28852 41
65197 255327 4 76 1003x Turk St 2 Sidewalk: Property side : Cutout Tree 1       3x3   6005211 2112640 37.7812013451486 -122.425606050794 (37.7812013451486, -122.425606050794) 7 9 11 28852 41
136152 255328 4 76 1003x Turk St 3 Sidewalk: Property side : Cutout Tree 1       3x3   6005211 2112640 37.7812013451486 -122.425606050794 (37.7812013451486, -122.425606050794) 7 9 11 28852 41
1232 264776 4 76 90x Guy Pl 10 Sidewalk: Curb side : Cutout Tree 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
3022 264768 4 76 90x Guy Pl 2 Sidewalk: Curb side : Cutout Tree 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
4382 264774 4 76 90x Guy Pl 8 Sidewalk: Curb side : Cutout Tree 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
7713 264772 4 76 90x Guy Pl 6 Sidewalk: Curb side : Cutout Tree 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
7972 264777 4 76 90x Guy Pl 11 Sidewalk: Curb side : Cutout Tree 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
9425 264770 4 76 90x Guy Pl 4 Sidewalk: Curb side : Cutout Tree 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
10663 264778 4 76 90x Guy Pl 12 Sidewalk: Curb side : Cutout Tree 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
11719 264769 4 76 90x Guy Pl 3 Sidewalk: Curb side : Cutout Tree 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
11739 264780 4 76 90x Guy Pl 14 Sidewalk: Curb side : Cutout Tree 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
12931 264773 4 76 90x Guy Pl 7 Sidewalk: Curb side : Cutout Tree 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
15616 264771 4 76 90x Guy Pl 5 Sidewalk: Curb side : Cutout Tree 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
17999 264779 4 76 90x Guy Pl 13 Sidewalk: Curb side : Cutout Tree 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6