trees

Custom SQL query returning 39 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
102892 190064 1 90 601 Amador St 16 : Tree 2     8 Width 3ft   6017258.18862 2099519.42487 37.745848392995 -122.383014889341 (37.745848392995, -122.383014889341) 10 3 8 58 1
111498 190040 1 90 1201 Indiana St 5 Sidewalk: Curb side : Cutout Tree 2     3 Width 6ft   6015068.4816 2102927.9251 37.7550861804851 -122.390824816018 (37.7550861804851, -122.390824816018) 10 3 8 28856 29
111522 245133 1 90 247 Central Ave 1 Sidewalk: Curb side : Cutout Tree 2     11 Width 0ft   5999815.2651 2109384.2736 37.7719555899544 -122.444038557826 (37.7719555899544, -122.444038557826) 15 5 11 29492 9
116824 247477 1 90 864 Page St 1 Sidewalk: Curb side : Yard Tree 2     14 Width 0ft   6002445.2342 2109547.3008 37.7725528991659 -122.434952972157 (37.7725528991659, -122.434952972157) 15 5 11 29492 9
117355 182966 1 90 2430 21st Ave 1 Sidewalk: Curb side : Yard Tree 2     9 Width 0ft   5989858.6972 2098819.7917 37.7423753326027 -122.477706327536 (37.7423753326027, -122.477706327536) 1 8 3 29491 35
117384 190060 1 90 601 Amador St 12 : Tree 2     8 Width 3ft   6017170.02722 2099514.29978 37.7458294487638 -122.383319385391 (37.7458294487638, -122.383319385391) 10 3 8 58 1
119365 126032 1 90 3301 Laguna St 18 Sidewalk: Property side : Yard Tree 2     5     6003673.24864 2120099.6794 37.8015967146776 -122.431458596234 (37.8015967146776, -122.431458596234) 13 9 1 57 17
123830 126026 1 90 2234 Chestnut St 1 Sidewalk: Curb side : Cutout Tree 2     9 Width 3ft   6001191.25301 2119719.01341 37.8004105241718 -122.44002009897 (37.8004105241718, -122.44002009897) 13 9 1 57 17
124549 126025 1 90 2250 Chestnut St 1 Sidewalk: Curb side : Cutout Tree 2     8 Width 3ft   6001053.38932 2119700.48084 37.8003517894721 -122.440495831328 (37.8003517894721, -122.440495831328) 13 9 1 57 17
133175 162236 1 90 403 Leland Ave 2 Sidewalk: Curb side : Cutout Tree 2     0 Width 0ft   6008707.08373 2087980.38348 37.7136884504429 -122.411768311455 (37.7136884504429, -122.411768311455) 9 7 8 309 39
133875 142911 1 90 478 GREEN ST 2 Sidewalk: Curb side : Cutout Tree 2     6 Width 0ft   6010646.636 2119298.6482 37.7997900351201 -122.407270886324 (37.7997900351201, -122.407270886324) 3 1 10 308 23
134260 117268 1 90 2215 Chestnut St 1 Sidewalk: Curb side : Cutout Tree 2     12 3x3   6001232.85704 2119672.58039 37.8002853996977 -122.439872801684 (37.8002853996977, -122.439872801684) 13 9 1 57 17
136970 245134 1 90 245 Central Ave 1 Sidewalk: Curb side : Cutout Tree 2     9 Width 0ft   5999817.9241 2109365.3279 37.7719037215376 -122.444027998646 (37.7719037215376, -122.444027998646) 15 5 11 29492 9
142339 22373 1 90 5506 03rd St 1 Sidewalk: Curb side : Cutout Tree 1     12 3X3   6014104.4995 2092933.9505 37.7275912748343 -122.393459193349 (37.7275912748343, -122.393459193349) 10 3 8 58 1
142681 190058 1 90 601 Amador St 10 : Tree 2     7 Width 3ft   6017131.10054 2099512.41263 37.7458221157047 -122.383453858321 (37.7458221157047, -122.383453858321) 10 3 8 58 1
143612 141065 1 90 193 Cook St 1 Sidewalk: Curb side : Cutout Tree 2     2 Width 0ft   5997591.6366 2112595.3291 37.7806452152507 -122.451961919026 (37.7806452152507, -122.451961919026) 15 6 2 54 16
143925 175849 1 90 986 Athens St 2 Sidewalk: Curb side : Cutout Tree 2     10 Width 2ft   6002153.04681 2088139.00774 37.713754143201 -122.434432752284 (37.713754143201, -122.434432752284) 9 7 6 28861 5
146118 245157 1 90 241 Central Ave 1 Sidewalk: Curb side : Cutout Tree 2     10 Width 0ft   5999819.9184 2109349.706 37.771860941516 -122.444019977581 (37.771860941516, -122.444019977581) 15 5 11 29492 9
151144 126028 1 90 3436 Clay St 1 Sidewalk: Curb side : Cutout Tree 2     12 Width 4ft   5998376.70601 2115562.57298 37.7888374239642 -122.449459861577 (37.7888374239642, -122.449459861577) 13 6 1 54 31
162350 112679 4 90 490x GREEN ST 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6010628 2119373 37.7999931439643 -122.40734061853 (37.7999931439643, -122.40734061853) 3 1 10 308 23
162557 106931 4 90 340 SHOTWELL ST 2 Sidewalk: Curb side : Cutout Tree 2     15 10x8   6007766.2 2105923.3 37.7629029238803 -122.41629043085 (37.7629029238803, -122.41629043085) 8 4 7 28859 19
163569 99182 1 90 3124 Baker St 1 Sidewalk: Curb side : Cutout Tree 2     20 3x7   5999415.83241 2119586.98668 37.7999467842805 -122.446154238844 (37.7999467842805, -122.446154238844) 13 9 1 57 17
168307 27382 1 90 2540 Hyde St 4 Sidewalk: Curb side : Cutout Tree 1     3 2X3   6006997.1662849 2121079.7808347 37.8044756501735 -122.420025898607 (37.8044756501735, -122.420025898607) 5 1 1 28858 32
169329 102245 1 90 386 Connecticut St 1 Sidewalk: Curb side : Cutout Tree 2     15 6x9   6013188.2401 2105269.20055 37.761410308446 -122.397491470547 (37.761410308446, -122.397491470547) 10 3 8 28856 29
169563 179265 1 90 63 Princeton St 1 Sidewalk: Curb side : Cutout Tree 2     8 Width 2ft   6007545.37116 2093646.36987 37.729180805142 -122.41618466351 (37.729180805142, -122.41618466351) 9 3 7 309 28
171914 126030 1 90 3301 Laguna St 16 Sidewalk: Property side : Yard Tree 2     2     6003671.03027 2120119.72439 37.8016516272786 -122.431467704597 (37.8016516272786, -122.431467704597) 13 9 1 57 17
172064 101679 4 90 257 Central Ave 3 Sidewalk: Curb side : Cutout Tree 2       3x3   5999766.4 2109434.7 37.7720912604321 -122.444211209505 (37.7720912604321, -122.444211209505) 15 5 11 29492 9
173744 190045 1 90 1200 Minnesota St 5 Sidewalk: Curb side : Cutout Tree 2     8 Width 3ft   6015294.5345 2102879.3666 37.754965388969 -122.390039661115 (37.754965388969, -122.390039661115) 10 3 8 28856 29
176161 190056 1 90 601 Amador St 8 : Tree 2     6 Width 3ft   6017097.53579 2099510.4176 37.7458147826396 -122.383569782742 (37.7458147826396, -122.383569782742) 10 3 8 58 1
176631 132056 1 90 1337 Greenwich St 1 Sidewalk: Curb side : Cutout Tree 2     19 Width 4ft   6006485.23006 2119708.64012 37.8006819908322 -122.421700054519 (37.8006819908322, -122.421700054519) 13 9 1 28858 32
177683 190046 1 90 1200 Minnesota St 6 Sidewalk: Curb side : Cutout Tree 2     8 Width 3ft   6015297.13041 2102859.28878 37.7549104035112 -122.390029281149 (37.7549104035112, -122.390029281149) 10 3 8 28856 29
178416 190043 1 90 1200 Minnesota St 3 Sidewalk: Curb side : Cutout Tree 2     8 Width 3ft   6015293.71026 2102912.85823 37.7550573041579 -122.390044851106 (37.7550573041579, -122.390044851106) 10 3 8 28856 29
179452 225216 1 90 42 Kronquist Ct 1 Sidewalk: Curb side : Cutout Tree 2     11 Width 3ft   6002223.67361 2100098.01608 37.7465948653766 -122.435043432425 (37.7465948653766, -122.435043432425) 2 7 5 63 22
183065 117531 4 90 257 Central Ave 5 Sidewalk: Curb side : Cutout Tree 2       3x3   5999766.4 2109434.7 37.7720912604321 -122.444211209505 (37.7720912604321, -122.444211209505) 15 5 11 29492 9
185003 126029 1 90 3301 Laguna St 15 Sidewalk: Property side : Yard Tree 2     20     6003669.97171 2120132.26195 37.8016859921622 -122.431472263247 (37.8016859921622, -122.431472263247) 13 9 1 57 17
185374 190057 1 90 601 Amador St 9 : Tree 2     6 Width 3ft   6017114.32264 2099511.63741 37.7458190598104 -122.383511820533 (37.7458190598104, -122.383511820533) 10 3 8 58 1
188098 175851 1 90 401 Leland Ave 2 Sidewalk: Curb side : Cutout Tree 2     18 Width 3ft   6008594.06768 2088021.58529 37.7137952413274 -122.41216184759 (37.7137952413274, -122.41216184759) 9 7 8 309 39
191408 175848 1 90 900 Vienna St 1 Sidewalk: Curb side : Cutout Tree 2     17 Width 4ft   6002108.06583 2088596.52311 37.7150078260217 -122.434620917447 (37.7150078260217, -122.434620917447) 9 7 6 28861 5
192812 190042 1 90 1200 Minnesota St 2 Sidewalk: Curb side : Cutout Tree 2     7 Width 3ft   6015293.33964 2102924.2234 37.7550884899453 -122.390046926728 (37.7550884899453, -122.390046926728) 10 3 8 28856 29