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)
20275 190041 1 90 1200 Minnesota St 1 Sidewalk: Curb side : Cutout Tree 2     9 Width 3ft   6015290.94111 2102939.21597 37.7551295233308 -122.390056268902 (37.7551295233308, -122.390056268902) 10 3 8 28856 29
29042 120762 1 90 1914 Clement St 1 Sidewalk: Curb side : Cutout Tree 2     7 Width 3ft   5989545.85022 2113375.8297 37.7823241210205 -122.479852964119 (37.7823241210205, -122.479852964119) 11 6 2 55 26
39715 190059 1 90 601 Amador St 11 : Tree 2     8 Width 3ft   6017151.01986 2099513.79213 37.7458270044148 -122.38338507547 (37.7458270044148, -122.38338507547) 10 3 8 58 1
40306 190053 1 90 601 Amador St 5 : Tree 2     6 Width 3ft   6017016.77225 2099506.19742 37.7457987306274 -122.383848760518 (37.7457987306274, -122.383848760518) 10 3 8 58 1
50084 190054 1 90 601 Amador St 6 : Tree 2     7 Width 3ft   6017061.37299 2099508.36453 37.7458071464869 -122.383694686874 (37.7458071464869, -122.383694686874) 10 3 8 58 1
51642 190052 1 90 601 Amador St 3 : Tree 2     4 Width 3ft   6016980.30458 2099504.54298 37.7457921718812 -122.383974746555 (37.7457921718812, -122.383974746555) 10 3 8 58 1
52231 225219 1 90 671 Church St 8 Front Yard : Yard Tree 2     12 Width 3ft   6004323.55223 2104918.32345 37.7599493112276 -122.428125733914 (37.7599493112276, -122.428125733914) 2 4 5 28862 3
53664 190061 1 90 601 Amador St 13 : Tree 2     8 Width 3ft   6017204.27586 2099516.94897 37.7458386155648 -122.383201141629 (37.7458386155648, -122.383201141629) 10 3 8 58 1
53721 123351 1 90 622 04th Ave 1 Sidewalk: Curb side : Cutout Tree 2     7 Width 3ft   5994733.36441 2111254.23547 37.7767987999792 -122.46175271245 (37.7767987999792, -122.46175271245) 11 6 2 54 11
60547 190065 1 90 601 Amador St 17 : Tree 2     6 Width 3ft   6017276.55288 2099521.28087 37.7458545038983 -122.382951516825 (37.7458545038983, -122.382951516825) 10 3 8 58 1
68860 190048 1 90 1076 Rhode Island St 1 : Tree 2     13 Width 3ft   6011890.64536 2103381.59659 37.7561550301571 -122.401846646232 (37.7561550301571, -122.401846646232) 10 3 8 28856 29
87261 225215 1 90 786 Cole St 2 Sidewalk: Curb side : Cutout Tree 2     12 Width 3ft   5998022.25403 2107604.08202 37.7669651923219 -122.450112353917 (37.7669651923219, -122.450112353917) 15 5 11 29492 9
90993 190047 1 90 1200 Minnesota St 7 Sidewalk: Curb side : Cutout Tree 2     9 Width 3ft   6015298.6738 2102816.81589 37.7547938675707 -122.390020976783 (37.7547938675707, -122.390020976783) 10 3 8 28856 29
99106 190063 1 90 601 Amador St 15 : Tree 2     7 Width 3ft   6017242.9879 2099519.28566 37.7458471708204 -122.383067442128 (37.7458471708204, -122.383067442128) 10 3 8 58 1
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
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
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
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
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
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
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
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
30245 190066 1 90 501 Amador St 7 : Tree 2     9 Width 4ft   6017535.35299 2099535.58015 37.7459080630153 -122.382057607783 (37.7459080630153, -122.382057607783) 10 3 8 58 1
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
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
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
8672 175850 1 90 44 Curtis St 1 Sidewalk: Curb side : Cutout Tree 2     18 Width 5ft   6000539.62692 2088348.79811 37.7142384641087 -122.440024342845 (37.7142384641087, -122.440024342845) 9 7 6 28861 5
50651 225217 1 90 134 Collingwood St 4 Sidewalk: Curb side : Cutout Tree 2     19 Width 5ft   6002027.4215 2104870.25922 37.7596871588433 -122.436063485734 (37.7596871588433, -122.436063485734) 2 4 5 28862 3
102035 225218 1 90 134 Collingwood St 5 Sidewalk: Curb side : Cutout Tree 2     18 Width 5ft   6002031.63852 2104811.49602 37.7595260489014 -122.436044696201 (37.7595260489014, -122.436044696201) 2 4 5 28862 3
6594 190037 1 90 1201 Indiana St 2 Sidewalk: Curb side : Cutout Tree 2     9 Width 6ft   6015070.33914 2102891.81593 37.7549871354551 -122.390815868666 (37.7549871354551, -122.390815868666) 10 3 8 28856 29
27195 190038 1 90 1201 Indiana St 3 Sidewalk: Curb side : Cutout Tree 2     7 Width 6ft   6015070.04888 2102904.88853 37.7550230139273 -122.390817786018 (37.7550230139273, -122.390817786018) 10 3 8 28856 29
63673 190036 1 90 1201 Indiana St 1 Sidewalk: Curb side : Cutout Tree 2     9 Width 6ft   6015071.83606 2102865.28409 37.7549143677243 -122.390808837753 (37.7549143677243, -122.390808837753) 10 3 8 28856 29
76755 190039 1 90 1201 Indiana St 4 Sidewalk: Curb side : Cutout Tree 2     8 Width 6ft   6015070.25334 2102915.00665 37.7550508074752 -122.390817786007 (37.7550508074752, -122.390817786007) 10 3 8 28856 29
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