trees

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
61438 107905 4 27 2650 Mason St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6008717 2122501 37.8084747060674 -122.414174852603 (37.8084747060674, -122.414174852603) 3 1 10 308 23
88031 107908 4 27 2650 Mason St 4 Sidewalk: Curb side : Cutout Tree 2           6008717 2122501 37.8084747060674 -122.414174852603 (37.8084747060674, -122.414174852603) 3 1 10 308 23
147498 107906 4 27 2650 Mason St 2 Sidewalk: Curb side : Cutout Tree 2           6008717 2122501 37.8084747060674 -122.414174852603 (37.8084747060674, -122.414174852603) 3 1 10 308 23
175877 107907 4 27 2650 Mason St 3 Sidewalk: Curb side : Cutout Tree 2           6008717 2122501 37.8084747060674 -122.414174852603 (37.8084747060674, -122.414174852603) 3 1 10 308 23
47604 104262 4 16 199X Jefferson St 1 Sidewalk: Curb side : Cutout Tree 2           6008482.28692 2122448.56477 37.8083175458446 -122.41498343065 (37.8083175458446, -122.41498343065) 3 1 10 308 23
66899 104263 4 16 199X Jefferson St 2 Sidewalk: Curb side : Cutout Tree 2           6008482.28692 2122448.56477 37.8083175458446 -122.41498343065 (37.8083175458446, -122.41498343065) 3 1 10 308 23
94320 104266 4 16 199X Jefferson St 5 Sidewalk: Curb side : Cutout Tree 2           6008482.28692 2122448.56477 37.8083175458446 -122.41498343065 (37.8083175458446, -122.41498343065) 3 1 10 308 23
108485 104265 4 16 199X Jefferson St 4 Sidewalk: Curb side : Cutout Tree 2           6008482.28692 2122448.56477 37.8083175458446 -122.41498343065 (37.8083175458446, -122.41498343065) 3 1 10 308 23
178487 104264 4 16 199X Jefferson St 3 Sidewalk: Curb side : Cutout Tree 2           6008482.28692 2122448.56477 37.8083175458446 -122.41498343065 (37.8083175458446, -122.41498343065) 3 1 10 308 23
63531 99175 4 97 300x BEACH ST 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6008712 2122248 37.8077797512209 -122.414174245084 (37.8077797512209, -122.414174245084) 3 1 10 308 23
125218 99176 4 97 300x BEACH ST 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6008712 2122248 37.8077797512209 -122.414174245084 (37.8077797512209, -122.414174245084) 3 1 10 308 23
26574 100103 4 95 461 Jefferson St 1 Sidewalk: Curb side : Cutout Tree 2           6007004.8 2122229.7 37.8076334645768 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
48222 100107 4 53 461 Jefferson St 5 Sidewalk: Curb side : Cutout Tree 2           6007004.8 2122229.7 37.8076334645768 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
114077 100108 4 53 461 Jefferson St 6 Sidewalk: Curb side : Cutout Tree 2           6007004.8 2122229.7 37.8076334645768 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
122731 100106 4 53 461 Jefferson St 4 Sidewalk: Curb side : Cutout Tree 2           6007004.8 2122229.7 37.8076334645768 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
145774 100105 4 95 461 Jefferson St 3 Sidewalk: Curb side : Cutout Tree 2           6007004.8 2122229.7 37.8076334645768 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
181687 100104 4 95 461 Jefferson St 2 Sidewalk: Curb side : Cutout Tree 2           6007004.8 2122229.7 37.8076334645768 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
94746 100102 4 341 495@ Beach Jefferson St 2 Sidewalk: Curb side : Cutout Tree 2           6006848.2 2122207.6 37.8075639592102 -122.42062152066 (37.8075639592102, -122.42062152066) 5 1 1 28858 32
3804 117402 4 53 75x BEACH ST 5 Sidewalk: Curb side : Cutout Tree 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
12765 117400 4 53 75x BEACH ST 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
56447 117399 4 53 75x BEACH ST 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
150414 117403 4 53 75x BEACH ST 6 Sidewalk: Curb side : Cutout Tree 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
158673 117398 4 53 75x BEACH ST 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
185775 117401 4 53 75x BEACH ST 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
30487 99178 4 97 330 Beach St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6008617 2122137 37.807469636787 -122.41449515712 (37.807469636787, -122.41449515712) 3 1 10 308 23
59862 120620 4 36 2 North Point St 14 Sidewalk: Curb side : Cutout Tree 2       3x3   6010405 2122056 37.8073475155142 -122.408301628949 (37.8073475155142, -122.408301628949) 3 1 10 308 23
1444 256097 4 36 2 North Point St 15 Sidewalk: Curb side : Cutout Tree 2   01/17/2020 12:12:00 PM 3 3x3   6010298.36751 2122029.07931 37.8072676263732 -122.408668755752 (37.8072676263732, -122.408668755752) 3 1 10 308 23
102285 256096 4 36 2 North Point St 14 Sidewalk: Curb side : Cutout Tree 2       3x3   6010298.36751 2122029.07931 37.8072676263732 -122.408668755752 (37.8072676263732, -122.408668755752) 3 1 10 308 23
51202 100114 4 11 333 Jefferson St 6 Sidewalk: Curb side : Cutout Tree 2           6007662 2121967 37.8069491634687 -122.417788103441 (37.8069491634687, -122.417788103441) 5 1 10 308 23
61684 100109 4 11 333 Jefferson St 1 Sidewalk: Curb side : Cutout Tree 2           6007662 2121967 37.8069491634687 -122.417788103441 (37.8069491634687, -122.417788103441) 5 1 10 308 23
67021 100113 4 11 333 Jefferson St 5 Sidewalk: Curb side : Cutout Tree 2           6007662 2121967 37.8069491634687 -122.417788103441 (37.8069491634687, -122.417788103441) 5 1 10 308 23
67964 100110 4 11 333 Jefferson St 2 Sidewalk: Curb side : Cutout Tree 2           6007662 2121967 37.8069491634687 -122.417788103441 (37.8069491634687, -122.417788103441) 5 1 10 308 23
68742 100119 4 11 333 Jefferson St 11 Sidewalk: Curb side : Cutout Tree 2           6007662 2121967 37.8069491634687 -122.417788103441 (37.8069491634687, -122.417788103441) 5 1 10 308 23
81579 100111 4 11 333 Jefferson St 3 Sidewalk: Curb side : Cutout Tree 2           6007662 2121967 37.8069491634687 -122.417788103441 (37.8069491634687, -122.417788103441) 5 1 10 308 23
93715 100117 4 11 333 Jefferson St 9 Sidewalk: Curb side : Cutout Tree 2           6007662 2121967 37.8069491634687 -122.417788103441 (37.8069491634687, -122.417788103441) 5 1 10 308 23
97575 100112 4 11 333 Jefferson St 4 Sidewalk: Curb side : Cutout Tree 2           6007662 2121967 37.8069491634687 -122.417788103441 (37.8069491634687, -122.417788103441) 5 1 10 308 23
135501 100115 4 11 333 Jefferson St 7 Sidewalk: Curb side : Cutout Tree 2           6007662 2121967 37.8069491634687 -122.417788103441 (37.8069491634687, -122.417788103441) 5 1 10 308 23
149669 100116 4 11 333 Jefferson St 8 Sidewalk: Curb side : Cutout Tree 2           6007662 2121967 37.8069491634687 -122.417788103441 (37.8069491634687, -122.417788103441) 5 1 10 308 23
162104 100120 4 11 333 Jefferson St 12 Sidewalk: Curb side : Cutout Tree 2           6007662 2121967 37.8069491634687 -122.417788103441 (37.8069491634687, -122.417788103441) 5 1 10 308 23
181201 100118 4 11 333 Jefferson St 10 Sidewalk: Curb side : Cutout Tree 2           6007662 2121967 37.8069491634687 -122.417788103441 (37.8069491634687, -122.417788103441) 5 1 10 308 23
53543 115711 4 11 550 NORTH POINT ST 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6008089 2121871 37.806709591959 -122.416303574578 (37.806709591959, -122.416303574578) 5 1 10 308 23
94303 115712 4 11 550 NORTH POINT ST 4 Sidewalk: Curb side : Cutout Tree 2   03/04/2016 12:00:00 AM 3 3x3   6008089 2121871 37.806709591959 -122.416303574578 (37.806709591959, -122.416303574578) 5 1 10 308 23
94711 115709 4 11 550 NORTH POINT ST 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6008089 2121871 37.806709591959 -122.416303574578 (37.806709591959, -122.416303574578) 5 1 10 308 23
133248 115710 4 11 550 NORTH POINT ST 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6008089 2121871 37.806709591959 -122.416303574578 (37.806709591959, -122.416303574578) 5 1 10 308 23
153385 115713 4 11 550 NORTH POINT ST 5 Sidewalk: Curb side : Cutout Tree 2       3x3   6008089 2121871 37.806709591959 -122.416303574578 (37.806709591959, -122.416303574578) 5 1 10 308 23
37319 105121 4 45 721 BEACH ST   Sidewalk: Curb side : Cutout Tree 2     9     6006739.7 2121813.5 37.8064757462399 -122.420969011396 (37.8064757462399, -122.420969011396) 5 1 1 28858 32
231 116978 4 76 111 BAY ST 4 Front Yard : Yard Tree 2           6010550 2121704 37.8063891294227 -122.407774985143 (37.8063891294227, -122.407774985143) 3 1 10 308 23
81381 111709 4 76 111 BAY ST 2 Front Yard : Yard Tree 2           6010550 2121704 37.8063891294227 -122.407774985143 (37.8063891294227, -122.407774985143) 3 1 10 308 23
1376 263620 4 59 900 Beach St 3 Side Yard : Yard Tree 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
10225 263619 4 59 900 Beach St 2 Side Yard : Yard Tree 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
10567 263621 4 59 900 Beach St 4 Side Yard : Yard Tree 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
11694 263618 4 59 900 Beach St 1 Side Yard : Yard Tree 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
56112 112489 4 70 2690x Leavenworth St 1 Sidewalk: Curb side : Cutout Tree 2   08/03/2015 12:00:00 AM   3x3   6007377.71104 2121658.59908 37.8060863706979 -122.418750060411 (37.8060863706979, -122.418750060411) 5 1 1 308 32
20469 114842 4 70 2670 LEAVENWORTH ST 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6007398 2121652 37.8060693936166 -122.418679378695 (37.8060693936166, -122.418679378695) 5 1 1 308 23
86140 114841 4 70 2670 LEAVENWORTH ST 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6007398 2121652 37.8060693936166 -122.418679378695 (37.8060693936166, -122.418679378695) 5 1 1 308 23
42643 258040 4 28 1288 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6007535 2121589 37.8059041239352 -122.418200797252 (37.8059041239352, -122.418200797252) 5 1 10 308 23
130948 258043 4 28 1288 Columbus Ave 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6007535 2121589 37.8059041239352 -122.418200797252 (37.8059041239352, -122.418200797252) 5 1 10 308 23
135347 258042 4 28 1288 Columbus Ave 3 Sidewalk: Curb side : Cutout Tree 2   05/13/2019 12:00:00 AM 3 3x3   6007535 2121589 37.8059041239352 -122.418200797252 (37.8059041239352, -122.418200797252) 5 1 10 308 23
157647 258041 4 11 1288 Columbus Ave 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6007535 2121589 37.8059041239352 -122.418200797252 (37.8059041239352, -122.418200797252) 5 1 10 308 23
166089 258044 4 28 1288 Columbus Ave 5 Sidewalk: Curb side : Cutout Tree 2       3x3   6007535 2121589 37.8059041239352 -122.418200797252 (37.8059041239352, -122.418200797252) 5 1 10 308 23
11053 116828 4 27 111 BAY ST 15 Front Yard : Yard Tree 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
13714 116827 4 27 111 BAY ST 14 Front Yard : Yard Tree 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
22667 116824 4 27 111 BAY ST 11 Front Yard : Yard Tree 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
35001 116817 4 27 111 BAY ST 4 Front Yard : Yard Tree 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
53972 116826 4 27 111 BAY ST 13 Front Yard : Yard Tree 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
57984 116822 4 27 111 BAY ST 9 Front Yard : Yard Tree 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
81034 116831 4 27 111 BAY ST 18 Front Yard : Yard Tree 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
81049 116820 4 27 111 BAY ST 7 Front Yard : Yard Tree 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
90664 116825 4 27 111 BAY ST 12 Front Yard : Yard Tree 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
103044 116823 4 27 111 BAY ST 10 Front Yard : Yard Tree 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
126220 116830 4 27 111 BAY ST 17 Front Yard : Yard Tree 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
133362 116818 4 27 111 BAY ST 5 Front Yard : Yard Tree 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
149148 116809 4 27 111 BAY ST 1 Front Yard : Yard Tree 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
180453 116829 4 27 111 BAY ST 16 Front Yard : Yard Tree 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
191989 116816 4 27 111 BAY ST 3 Front Yard : Yard Tree 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
192724 116815 4 27 111 BAY ST 2 Front Yard : Yard Tree 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
122556 98759 4 70 143 - 147 RETIRO WAY 1 Sidewalk: Curb side : Cutout Tree 2           6001834.3 2121687.2 37.805851229479 -122.437935958007 (37.805851229479, -122.437935958007) 13 9 1 57 17
58111 258045 4 53 1250 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree 2   05/13/2019 12:00:00 AM 3 3x3   6007719 2121534 37.805763462997 -122.417560134413 (37.805763462997, -122.417560134413) 5 1 10 308 23
97771 258048 4 11 1250 Columbus Ave 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6007719 2121534 37.805763462997 -122.417560134413 (37.805763462997, -122.417560134413) 5 1 10 308 23
150358 258047 4 53 1250 Columbus Ave 3 Sidewalk: Curb side : Cutout Tree 2   05/13/2019 12:00:00 AM 3 3x3   6007719 2121534 37.805763462997 -122.417560134413 (37.805763462997, -122.417560134413) 5 1 10 308 23
168220 258046 4 53 1250 Columbus Ave 2 Sidewalk: Curb side : Cutout Tree 2   05/13/2019 12:00:00 AM 3 3x3   6007719 2121534 37.805763462997 -122.417560134413 (37.805763462997, -122.417560134413) 5 1 10 308 23
30032 121066 4 27 3199x Polk St 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6005931 2121567 37.8057533025265 -122.423750130533 (37.8057533025265, -122.423750130533) 5 1 1 28858 32
111525 121067 4 27 3199x Polk St 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6005931 2121567 37.8057533025265 -122.423750130533 (37.8057533025265, -122.423750130533) 5 1 1 28858 32
146631 121064 4 27 3199x Polk St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6005931 2121567 37.8057533025265 -122.423750130533 (37.8057533025265, -122.423750130533) 5 1 1 28858 32
153918 121065 4 27 3199x Polk St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6005931 2121567 37.8057533025265 -122.423750130533 (37.8057533025265, -122.423750130533) 5 1 1 28858 32
119534 103297 4 11 50 Francisco St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6011114.9 2121460 37.805750773231 -122.405802839637 (37.805750773231, -122.405802839637) 3 1 10 308 23
153770 103287 4 71 50 Francisco St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6011114.9 2121460 37.805750773231 -122.405802839637 (37.805750773231, -122.405802839637) 3 1 10 308 23
139146 96365 4 17 2017 Grant Ave 1 Median : Cutout Tree 2   06/07/2011 12:00:00 AM 12 3x3 Permit Number 767883 6010284.4 2121422.5 37.8056013282128 -122.408674274121 (37.8056013282128, -122.408674274121) 3 1 10 308 23
73472 103296 4 11 80 Francisco St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6010792 2121375 37.80549932132 -122.406914293894 (37.80549932132, -122.406914293894) 3 1 10 308 23
183626 142645 4 1 2380 Mason St 4 Sidewalk: Curb side : Cutout Tree 2           6008890.0639 2121379.5977 37.805405337199 -122.41349655223 (37.805405337199, -122.41349655223) 3 1 10 308 23
117475 97938 4 53 2133 Stockton St 5 Sidewalk: Curb side : Cutout Tree 2       3x3   6009831.3 2121360.2 37.8054048804892 -122.410237896013 (37.8054048804892, -122.410237896013) 3 1 10 308 23
28490 111716 4 1 2390x MASON ST 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6008938 2121373 37.8053899130211 -122.413330195558 (37.8053899130211, -122.413330195558) 3 1 10 308 23
43856 111715 4 70 2390x MASON ST 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6008938 2121373 37.8053899130211 -122.413330195558 (37.8053899130211, -122.413330195558) 3 1 10 308 23
115497 111718 4 1 2390x MASON ST 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6008938 2121373 37.8053899130211 -122.413330195558 (37.8053899130211, -122.413330195558) 3 1 10 308 23
152945 111717 4 1 2390x MASON ST 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6008938 2121373 37.8053899130211 -122.413330195558 (37.8053899130211, -122.413330195558) 3 1 10 308 23
170611 104729 4 53 250-252 FRANCISCO ST   Sidewalk: Curb side : Cutout Tree 2     22 5x5   6010061.3 2121325.4 37.805322217951 -122.409439489572 (37.805322217951, -122.409439489572) 3 1 10 308 23
92681 115442 4 70 99x Vandewater St 3 Sidewalk: Curb side : Cutout Tree 2       2.5X3   6009122.65313 2121320.70167 37.8052566803806 -122.412687477249 (37.8052566803806, -122.412687477249) 3 1 10 308 23
137554 115443 4 70 99x Vandewater St 4 Sidewalk: Curb side : Cutout Tree 2       2.5X3   6009122.65313 2121320.70167 37.8052566803806 -122.412687477249 (37.8052566803806, -122.412687477249) 3 1 10 308 23
150284 115440 4 70 99x Vandewater St 1 Sidewalk: Curb side : Cutout Tree 2       2.5X3   6009122.65313 2121320.70167 37.8052566803806 -122.412687477249 (37.8052566803806, -122.412687477249) 3 1 10 308 23
179845 116832 4 27 2 Midway St 7 Front Yard : Yard Tree 8           6010125.275107 2121295.55695439 37.8052438606833 -122.409215987298 (37.8052438606833, -122.409215987298) 3 1 10 308 23
188310 112373 4 201 15 VANDEWATER ST 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6009208 2121303 37.8052128657777 -122.412390870606 (37.8052128657777, -122.412390870606) 3 1 10 308 23