trees

Custom SQL query returning 64 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
14266 104341 7 148 953 Indiana St 1 Sidewalk: Curb side : Cutout Tree 2   09/21/2013 12:00:00 AM   3x3 Permit Number 770725 6015057.1 2104275.7 37.7587862506702 -122.390958369803 (37.7587862506702, -122.390958369803) 10 3 8 28856 29
35185 103088 4 148 256 SHIPLEY ST   Sidewalk: Curb side : Cutout Tree 2     10 3x3   6011387 2111652 37.7788355638527 -122.404170475964 (37.7788355638527, -122.404170475964) 14 2 9 28856 34
49387 91787 1 148 974 Harrison St   Sidewalk: Curb side : Cutout Tree 1   03/07/2007 12:00:00 AM 3 3x3   6011579.201291 2111277.19318 37.7778171686355 -122.403479195946 (37.7778171686355, -122.403479195946) 14 2 9 28856 34
181552 91786 1 148 966 Harrison St   Sidewalk: Curb side : Cutout Tree 1   01/21/2010 12:00:00 AM 3 3x3   6011627.673411 2111323.517939 37.7779470730221 -122.403314772772 (37.7779470730221, -122.403314772772) 14 2 9 28856 34
920 91853 7 148 601x Harrison St 1 Sidewalk: Curb side : Cutout Tree 2   03/07/2007 12:00:00 AM 3 3x3   6014039.760938 2113573.418065 37.7842592071543 -122.395128082808 (37.7842592071543, -122.395128082808) 6 2 9 28856 6
19974 28151 1 148 100X King St 4 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6015580.6531721 2111966.262542 37.7799318892041 -122.38968480475 (37.7799318892041, -122.38968480475) 6 2 9 28856 20
28859 91843 7 148 855 HARRISON ST 2 Sidewalk: Curb side : Cutout Tree 2   03/07/2007 12:00:00 AM 9 3x3   6012443 2111954 37.7797237344479 -122.400538552021 (37.7797237344479, -122.400538552021) 6 2 9 28856 34
29692 91848 7 148 855 HARRISON ST 7 Sidewalk: Curb side : Cutout Tree 2   03/07/2007 12:00:00 AM 7 3x3   6012443 2111954 37.7797237344479 -122.400538552021 (37.7797237344479, -122.400538552021) 6 2 9 28856 34
31583 91851 7 148 855 HARRISON ST 10 Sidewalk: Curb side : Cutout Tree 2   03/07/2007 12:00:00 AM 6 3x3   6012443 2111954 37.7797237344479 -122.400538552021 (37.7797237344479, -122.400538552021) 6 2 9 28856 34
34463 28181 1 148 199X King St 17 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6014965.0656592 2111288.9310025 37.7780379351787 -122.391767040652 (37.7780379351787, -122.391767040652) 6 2 9 28856 20
35228 28154 1 148 100X King St 7 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6015580.6531721 2111966.262542 37.7799318892041 -122.38968480475 (37.7799318892041, -122.38968480475) 6 2 9 28856 20
36837 117955 7 148 855 HARRISON ST 11 Sidewalk: Curb side : Cutout Tree 2     6 3x3   6012443 2111954 37.7797237344479 -122.400538552021 (37.7797237344479, -122.400538552021) 6 2 9 28856 34
37977 91856 7 148 601x Harrison St 4 Sidewalk: Curb side : Cutout Tree 2   03/07/2007 12:00:00 AM 3 3x3   6014039.760938 2113573.418065 37.7842592071543 -122.395128082808 (37.7842592071543, -122.395128082808) 6 2 9 28856 6
38534 91845 7 148 855 HARRISON ST 4 Sidewalk: Curb side : Cutout Tree 2   03/07/2007 12:00:00 AM 9 3x3   6012443 2111954 37.7797237344479 -122.400538552021 (37.7797237344479, -122.400538552021) 6 2 9 28856 34
39391 28180 1 148 199X King St 16 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6014965.0656592 2111288.9310025 37.7780379351787 -122.391767040652 (37.7780379351787, -122.391767040652) 6 2 9 28856 20
39483 28169 1 148 199X King St 5 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6014965.0656592 2111288.9310025 37.7780379351787 -122.391767040652 (37.7780379351787, -122.391767040652) 6 2 9 28856 20
42580 28156 1 148 100X King St 9 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6015580.6531721 2111966.262542 37.7799318892041 -122.38968480475 (37.7799318892041, -122.38968480475) 6 2 9 28856 20
42673 28160 1 148 100X King St 13 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6015580.6531721 2111966.262542 37.7799318892041 -122.38968480475 (37.7799318892041, -122.38968480475) 6 2 9 28856 20
45913 28158 1 148 100X King St 11 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6015580.6531721 2111966.262542 37.7799318892041 -122.38968480475 (37.7799318892041, -122.38968480475) 6 2 9 28856 20
48060 91855 7 148 601x Harrison St 3 Sidewalk: Curb side : Cutout Tree 2   03/07/2007 12:00:00 AM 3 3x3   6014039.760938 2113573.418065 37.7842592071543 -122.395128082808 (37.7842592071543, -122.395128082808) 6 2 9 28856 6
53109 91850 7 148 855 HARRISON ST 9 Sidewalk: Curb side : Cutout Tree 2   03/07/2007 12:00:00 AM 7 3x3   6012443 2111954 37.7797237344479 -122.400538552021 (37.7797237344479, -122.400538552021) 6 2 9 28856 34
55209 28153 1 148 100X King St 6 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6015580.6531721 2111966.262542 37.7799318892041 -122.38968480475 (37.7799318892041, -122.38968480475) 6 2 9 28856 20
55995 28163 1 148 100X King St 16 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6015580.6531721 2111966.262542 37.7799318892041 -122.38968480475 (37.7799318892041, -122.38968480475) 6 2 9 28856 20
60140 28161 1 148 100X King St 14 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6015580.6531721 2111966.262542 37.7799318892041 -122.38968480475 (37.7799318892041, -122.38968480475) 6 2 9 28856 20
64239 28155 1 148 100X King St 8 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6015580.6531721 2111966.262542 37.7799318892041 -122.38968480475 (37.7799318892041, -122.38968480475) 6 2 9 28856 20
68393 117958 7 148 851X HARRISON ST 2 Sidewalk: Curb side : Cutout Tree 2     6 3x3   6012435 2111995 37.7798358648386 -122.400569108585 (37.7798358648386, -122.400569108585) 6 2 9 28856 34
71285 28167 1 148 199X King St 3 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6014965.0656592 2111288.9310025 37.7780379351787 -122.391767040652 (37.7780379351787, -122.391767040652) 6 2 9 28856 20
73894 91794 7 148 700x Harrison St 1 Sidewalk: Curb side : Cutout Tree 2   03/07/2007 12:00:00 AM 3 3x3   6013352.664153 2112972.090127 37.7825698655965 -122.397463025411 (37.7825698655965, -122.397463025411) 6 2 9 28856 34
96005 28164 1 148 100X King St 17 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6015580.6531721 2111966.262542 37.7799318892041 -122.38968480475 (37.7799318892041, -122.38968480475) 6 2 9 28856 20
96202 28166 1 148 199X King St 2 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6014965.0656592 2111288.9310025 37.7780379351787 -122.391767040652 (37.7780379351787, -122.391767040652) 6 2 9 28856 20
101235 28171 1 148 199X King St 7 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6014965.0656592 2111288.9310025 37.7780379351787 -122.391767040652 (37.7780379351787, -122.391767040652) 6 2 9 28856 20
102046 28170 1 148 199X King St 6 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6014965.0656592 2111288.9310025 37.7780379351787 -122.391767040652 (37.7780379351787, -122.391767040652) 6 2 9 28856 20
102329 91788 1 148 830X Harrison St 8 Sidewalk: Curb side : Cutout Tree 4   03/07/2007 12:00:00 AM 3 3x3   6012494.965717 2112152.388469 37.7802713613915 -122.400372717325 (37.7802713613915, -122.400372717325) 6 2 9 28856 34
102486 91854 7 148 601x Harrison St 2 Sidewalk: Curb side : Cutout Tree 2   03/07/2007 12:00:00 AM 3 3x3   6014039.760938 2113573.418065 37.7842592071543 -122.395128082808 (37.7842592071543, -122.395128082808) 6 2 9 28856 6
104372 28148 1 148 100X King St 1 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6015580.6531721 2111966.262542 37.7799318892041 -122.38968480475 (37.7799318892041, -122.38968480475) 6 2 9 28856 20
105963 28174 1 148 199X King St 10 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6014965.0656592 2111288.9310025 37.7780379351787 -122.391767040652 (37.7780379351787, -122.391767040652) 6 2 9 28856 20
106049 28162 1 148 100X King St 15 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6015580.6531721 2111966.262542 37.7799318892041 -122.38968480475 (37.7799318892041, -122.38968480475) 6 2 9 28856 20
107246 91840 1 148 895x Harrison St   Sidewalk: Curb side : Cutout Tree 1   03/07/2007 12:00:00 AM 3 3x3   6012119.593271 2111738.315629 37.7791134735728 -122.401642199835 (37.7791134735728, -122.401642199835) 6 2 9 28856 34
114306 28159 1 148 100X King St 12 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6015580.6531721 2111966.262542 37.7799318892041 -122.38968480475 (37.7799318892041, -122.38968480475) 6 2 9 28856 20
115901 91849 7 148 855 HARRISON ST 8 Sidewalk: Curb side : Cutout Tree 2   03/07/2007 12:00:00 AM 8 3x3   6012443 2111954 37.7797237344479 -122.400538552021 (37.7797237344479, -122.400538552021) 6 2 9 28856 34
121480 91847 7 148 855 HARRISON ST 6 Sidewalk: Curb side : Cutout Tree 2   03/07/2007 12:00:00 AM 6 3x3   6012443 2111954 37.7797237344479 -122.400538552021 (37.7797237344479, -122.400538552021) 6 2 9 28856 34
125080 28176 1 148 199X King St 12 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6014965.0656592 2111288.9310025 37.7780379351787 -122.391767040652 (37.7780379351787, -122.391767040652) 6 2 9 28856 20
127194 91844 7 148 855 HARRISON ST 3 Sidewalk: Curb side : Cutout Tree 2   03/07/2007 12:00:00 AM 6 3x3   6012443 2111954 37.7797237344479 -122.400538552021 (37.7797237344479, -122.400538552021) 6 2 9 28856 34
128110 28149 1 148 100X King St 2 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6015580.6531721 2111966.262542 37.7799318892041 -122.38968480475 (37.7799318892041, -122.38968480475) 6 2 9 28856 20
131734 91846 7 148 855 HARRISON ST 5 Sidewalk: Curb side : Cutout Tree 2   03/07/2007 12:00:00 AM 6 3x3   6012443 2111954 37.7797237344479 -122.400538552021 (37.7797237344479, -122.400538552021) 6 2 9 28856 34
132236 91790 7 148 850 Harrison St 2 Sidewalk: Curb side : Cutout Tree 2   03/07/2007 12:00:00 AM 12 3x3   6012369.025423 2112032.027439 37.7799338540171 -122.400799947263 (37.7799338540171, -122.400799947263) 6 2 9 28856 34
133379 28173 1 148 199X King St 9 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6014965.0656592 2111288.9310025 37.7780379351787 -122.391767040652 (37.7780379351787, -122.391767040652) 6 2 9 28856 20
135328 91841 1 148 861X HARRISON ST 1 Sidewalk: Curb side : Cutout Tree 1   03/07/2007 12:00:00 AM 10 3x3   6012389 2112023 37.7799101808503 -122.400730211489 (37.7799101808503, -122.400730211489) 6 2 9 28856 34
137227 28179 1 148 199X King St 15 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6014965.0656592 2111288.9310025 37.7780379351787 -122.391767040652 (37.7780379351787, -122.391767040652) 6 2 9 28856 20
139441 28175 1 148 199X King St 11 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6014965.0656592 2111288.9310025 37.7780379351787 -122.391767040652 (37.7780379351787, -122.391767040652) 6 2 9 28856 20
139466 28152 1 148 100X King St 5 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6015580.6531721 2111966.262542 37.7799318892041 -122.38968480475 (37.7799318892041, -122.38968480475) 6 2 9 28856 20
139771 28165 1 148 199X King St 1 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6014965.0656592 2111288.9310025 37.7780379351787 -122.391767040652 (37.7780379351787, -122.391767040652) 6 2 9 28856 20
144049 91791 7 148 850 Harrison St 3 Sidewalk: Curb side : Cutout Tree 2   03/07/2007 12:00:00 AM 3 3x3   6012369.025423 2112032.027439 37.7799338540171 -122.400799947263 (37.7799338540171, -122.400799947263) 6 2 9 28856 34
146903 28150 1 148 100X King St 3 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6015580.6531721 2111966.262542 37.7799318892041 -122.38968480475 (37.7799318892041, -122.38968480475) 6 2 9 28856 20
153578 117959 7 148 851X HARRISON ST 3 Sidewalk: Curb side : Cutout Tree 2     7 3x3   6012435 2111995 37.7798358648386 -122.400569108585 (37.7798358648386, -122.400569108585) 6 2 9 28856 34
158393 91842 1 148 855 HARRISON ST 1 Sidewalk: Curb side : Cutout Tree 1   03/07/2007 12:00:00 AM 10 3x3   6012443 2111954 37.7797237344479 -122.400538552021 (37.7797237344479, -122.400538552021) 6 2 9 28856 34
159971 28168 1 148 199X King St 4 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6014965.0656592 2111288.9310025 37.7780379351787 -122.391767040652 (37.7780379351787, -122.391767040652) 6 2 9 28856 20
165481 91792 1 148 880 Harrison St 1 Sidewalk: Curb side : Cutout Tree 1   03/07/2007 12:00:00 AM 3 3x3   6012180.114989 2111851.485898 37.7794275900263 -122.401440784868 (37.7794275900263, -122.401440784868) 6 2 9 28856 34
166547 91852 1 148 699X Harrison St 1 Sidewalk: Curb side : Cutout Tree 1   03/07/2007 12:00:00 AM 3 3x3   6013398.68241 2112960.74002 37.78254126295 -122.397303024799 (37.78254126295, -122.397303024799) 6 2 9 28856 6
184248 28172 1 148 199X King St 8 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6014965.0656592 2111288.9310025 37.7780379351787 -122.391767040652 (37.7780379351787, -122.391767040652) 6 2 9 28856 20
185510 28177 1 148 199X King St 13 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6014965.0656592 2111288.9310025 37.7780379351787 -122.391767040652 (37.7780379351787, -122.391767040652) 6 2 9 28856 20
185588 28157 1 148 100X King St 10 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6015580.6531721 2111966.262542 37.7799318892041 -122.38968480475 (37.7799318892041, -122.38968480475) 6 2 9 28856 20
188561 28178 1 148 199X King St 14 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6014965.0656592 2111288.9310025 37.7780379351787 -122.391767040652 (37.7780379351787, -122.391767040652) 6 2 9 28856 20
191802 28182 1 148 199X King St 18 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6014965.0656592 2111288.9310025 37.7780379351787 -122.391767040652 (37.7780379351787, -122.391767040652) 6 2 9 28856 20