sf-trees

Data source: data.sfgov.org

Custom SQL query returning 36 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
27161 197088 2 82 1098 Pennsylvania Ave 6 9 1 1     5 Width 5ft   6014473.69906 2102184.6927400003 37.753012404101 -122.39282976818998 (37.753012404101, -122.39282976819)
30381 197107 2 82 1468 25th St 6 9 1 1     6 Width 5ft   6014386.38736 2102037.52751 37.7526034697945 -122.393121414743 (37.7526034697945, -122.393121414743)
30856 197169 2 82 2 Baldwin Ct 6 9 1 1     11 Width 4ft   6017690.0216 2093651.3665 37.7297597257339 -122.38111373781 (37.7297597257339, -122.38111373781)
36178 197095 2 82 1098 Pennsylvania Ave 13 9 1 1     4 Width 5ft   6014479.30677 2102077.89395 37.7527194688438 -122.39280290452601 (37.7527194688438, -122.392802904526)
36783 136264 2 82 1600 Montgomery St 4 9 1 1     10 Width 3ft   6011327.59811 2121029.0502400002 37.804579383680895 -122.40503639942601 (37.8045793836809, -122.405036399426)
40908 197109 2 82 600 De Haro St 2 9 1 1     9     6012049.36164 2105557.39202 37.7621381396801 -122.401450654931 (37.7621381396801, -122.401450654931)
41596 197086 2 82 1098 Pennsylvania Ave 4 9 1 1     6 Width 5ft   6014471.44073 2102209.38753 37.7530800852958 -122.39283930551599 (37.7530800852958, -122.392839305516)
45418 197094 2 82 1098 Pennsylvania Ave 12 9 1 1     5 Width 5ft   6014478.47867 2102089.9100099998 37.7527524163908 -122.392806608832 (37.7527524163908, -122.392806608832)
45516 117917 2 82 767 41st Ave 2 9 1 1     6 Width 4ft   5983194.46177 2110567.54263 37.7742423451733 -122.501617774429 (37.7742423451733, -122.501617774429)
55248 197103 2 82 1468 25th St 2 9 1 1     6 Width 5ft   6014438.05571 2102040.91433 37.7526156394141 -122.392942972153 (37.7526156394141, -122.392942972153)
57011 136263 2 82 1600 Montgomery St 3 9 1 1     10 Width 3ft   6011331.32037 2121003.20622 37.804508630427 -122.40502169731 (37.804508630427, -122.40502169731)
62833 197084 2 82 1098 Pennsylvania Ave 2 9 1 1     6 Width 5ft   6014468.76337 2102245.03022 37.753177803814 -122.39285105782801 (37.753177803814, -122.392851057828)
65149 197108 2 82 600 De Haro St 1 9 1 1     5     6012056.73956 2105565.85317 37.762161783771205 -122.401425732033 (37.7621617837712, -122.401425732033)
69725 124089 2 82 601 Funston Ave 4 9 1 1     8     5991892.74244 2111106.03462 37.7762279504105 -122.47156838077 (37.7762279504105, -122.47156838077)
70424 124324 2 82 109 Jordan Ave 2 9 1 1     9 Width 3ft   5996182.48161 2113700.3553299997 37.7835985094544 -122.45691677945 (37.7835985094544, -122.45691677945)
73613 136261 2 82 15 MacOndray Ln 1 9 1 1     7     6008598.0245 2119155.01738 37.7992807940363 -122.414349696679 (37.7992807940363, -122.414349696679)
76745 197102 2 82 1468 25th St 1 9 1 1     6 Width 5ft   6014466.67746 2102042.06403 37.752620386043205 -122.392844072804 (37.7526203860432, -122.392844072804)
121744 107696 1 82 2401 MORAGA ST 4 9 1 1     3     5986802.4 2103641.7 37.7554371523715 -122.488628271884 (37.7554371523715, -122.488628271884)
134067 197110 2 82 600 De Haro St 3 9 1 1     11     6012050.80748 2105527.2247200003 37.7620553876595 -122.40144353408701 (37.7620553876595, -122.401443534087)
134469 197089 2 82 1098 Pennsylvania Ave 7 9 1 1     7 Width 5ft   6014473.51573 2102162.27258 37.7529508329366 -122.39282883379101 (37.7529508329366, -122.392828833791)
136568 136260 2 82 740 Francisco St 1 9 1 1     10 Width 3ft   6007759.94756 2120993.00482 37.8042803312301 -122.417380065732 (37.8042803312301, -122.417380065732)
137657 197111 2 82 600 De Haro St 4 9 1 1     10     6012057.756469999 2105514.57714 37.762021047941204 -122.401418611192 (37.7620210479412, -122.401418611192)
149097 197092 2 82 1098 Pennsylvania Ave 10 9 1 1     5 Width 5ft   6014476.97343 2102121.40509 37.752838811567 -122.392814017467 (37.752838811567, -122.392814017467)
150842 136205 2 82 201 Locust St 2 9 1 1     6 Width 3ft   5997542.32225 2115652.46545 37.78903647900739 -122.452353187461 (37.7890364790074, -122.452353187461)
157085 197085 2 82 1098 Pennsylvania Ave 3 9 1 1     7 Width 5ft   6014468.858580001 2102236.49554 37.7531543746906 -122.392850131521 (37.7531543746906, -122.392850131521)
157309 197105 2 82 1468 25th St 4 9 1 1     5 Width 5ft   6014414.64892 2102038.8947099997 37.752608793773796 -122.393023776248 (37.7526087937738, -122.393023776248)
160169 197087 2 82 1098 Pennsylvania Ave 5 9 1 1     5 Width 5ft   6014472.10243 2102198.29911 37.753049675611 -122.39283624152 (37.753049675611, -122.39283624152)
168763 213992 2 82 20 Mangels Ave 2 9 1 1     3 Width 5ft   6001188.39506 2095218.69175 37.733138545197704 -122.43827381338801 (37.7331385451977, -122.438273813388)
170402 197083 2 82 1098 Pennsylvania Ave 1 9 1 1     6 Width 5ft   6014468.24915 2102256.69833 37.7532098133945 -122.392853652369 (37.7532098133945, -122.392853652369)
171068 197090 2 82 1098 Pennsylvania Ave 8 9 1 1     7 Width 5ft   6014474.311480001 2102148.65752 37.752913493081294 -122.39282512948 (37.7529134930813, -122.39282512948)
172109 213994 2 82 132 Melrose Ave 1 9 1 1     6 Width 10ft   5999171.152980001 2095530.50421 37.7338797682181 -122.445270345553 (37.7338797682181, -122.445270345553)
176731 197101 2 82 37 Arkansas St 1 9 1 1     13 Width 3ft   6012884.97292 2106850.1929599997 37.7657344728051 -122.398651302829 (37.7657344728051, -122.398651302829)
178466 197104 2 82 1468 25th St 3 9 1 1     6 Width 5ft   6014428.85484 2102039.8538900004 37.752612216591004 -122.392974716426 (37.752612216591, -122.392974716426)
178725 197106 2 82 1468 25th St 5 9 1 1     7 Width 5ft   6014394.04215 2102037.78794 37.752604610114005 -122.393094961165 (37.752604610114, -122.393094961165)
181135 197093 2 82 1098 Pennsylvania Ave 11 9 1 1     6 Width 5ft   6014477.98301 2102105.11898 37.7527941494528 -122.392809386851 (37.7527941494528, -122.392809386851)
181973 197091 2 82 1098 Pennsylvania Ave 9 9 1 1     7 Width 5ft   6014475.63706 2102134.7648099996 37.7528754202862 -122.39281957348601 (37.7528754202862, -122.392819573486)
Powered by Datasette · Query took 44.888ms · Data source: data.sfgov.org