sf-trees

Data source: data.sfgov.org

Custom SQL query returning 39 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1905 251810 2 11 2 Hangah St 3 20 1 10 7     3x3   6010544.0 2117119.0 37.7937995065594 -122.40747229387699 (37.7937995065594, -122.407472293877)
1912 251809 2 11 2 Hangah St 2 20 1 10 7     3x3   6010544.0 2117119.0 37.7937995065594 -122.40747229387699 (37.7937995065594, -122.407472293877)
1919 251807 2 160 2 Hangah St 1 20 1 10 7     3x3   6010544.0 2117119.0 37.7937995065594 -122.40747229387699 (37.7937995065594, -122.407472293877)
1921 251811 2 11 2 Hangah St 4 20 1 10 7     3x3   6010544.0 2117119.0 37.7937995065594 -122.40747229387699 (37.7937995065594, -122.407472293877)
1923 251813 2 160 2 Hangah St 6 20 1 10 7     3x3   6010544.0 2117119.0 37.7937995065594 -122.40747229387699 (37.7937995065594, -122.407472293877)
8534 96176 1 251     20 1 1   04/04/2011 12:00:00 AM   3x3 Permit Number 767809          
9585 96180 1 251     20 1 1   04/04/2011 12:00:00 AM   3x3 Permit Number 767812          
11086 96178 1 268     20 1 1   04/04/2011 12:00:00 AM   3x3 Permit Number 767810          
13429 96174 1 281     20 1 1   04/04/2011 12:00:00 AM   3x3 Permit Number 767807          
14101 96173 1 116     20 1 1   04/04/2011 12:00:00 AM   3x3 Permit Number 767806          
15678 96177 1 293     20 1 1   04/04/2011 12:00:00 AM   3x3 Permit Number 767810          
15720 96179 1 251     20 1 1       3x3 Permit Number 767811          
16511 96175 1 281     20 1 1   04/04/2011 12:00:00 AM   3x3 Permit Number 767808          
43267 121204 2 103 44 MacOndray Ln 1 20 1 1     52     6008473.20212 2119153.5676 37.799269800719294 -122.41478152415002 (37.7992698007193, -122.41478152415)
44576 110632 2 17 1051X Mandalay Ln 1 20 1 1           5991736.200759999 2101819.33429 37.7507200830769 -122.47143306251002 (37.7507200830769, -122.47143306251)
51671 112792 2 28 23x Joice St 3 20 1 1     5     6010303.89255 2116225.84414 37.7913336739481 -122.40824006785101 (37.7913336739481, -122.408240067851)
52401 112793 2 28 23x Joice St 4 20 1 1     8     6010304.6147 2116218.08658 37.7913124139936 -122.40823702184099 (37.7913124139936, -122.408237021841)
56387 112791 2 28 23x Joice St 2 20 1 1     7     6010302.18584 2116235.66689 37.791360549286104 -122.408246666156 (37.7913605492861, -122.408246666156)
77831 117475 2 86 1200x MONTGOMERY ST 2 20 1 1           6011580.0 2119440.0 37.800230345698 -122.404051036068 (37.800230345698, -122.404051036068)
81560 117474 2 86 1200x MONTGOMERY ST 1 20 1 1           6011580.0 2119440.0 37.800230345698 -122.404051036068 (37.800230345698, -122.404051036068)
89059 111914 2 3 60 LOWER TER 1 20 1 1     28 3x3   6000264.0 2106046.0 37.7628151124003 -122.442246670025 (37.7628151124003, -122.442246670025)
92551 110323 2 17 1501x SHOTWELL ST 2 20 1 1   05/15/2015 12:00:00 AM 3 3x3 Permit Number 775301 6008079.0 2099374.0 37.7449376155386 -122.41474504111099 (37.7449376155386, -122.414745041111)
99382 110322 2 17 1501x SHOTWELL ST 1 20 1 1   05/15/2015 12:00:00 AM 3 3x3 Permit Number 775301 6008079.0 2099374.0 37.7449376155386 -122.41474504111099 (37.7449376155386, -122.414745041111)
100244 114271 2 164 49x ESMERALDA AVE 1 20 1 1     27 3x3   6006783.0 2099038.0 37.7439421324692 -122.41920255172501 (37.7439421324692, -122.419202551725)
101001 117071 2 191 10 JOY ST 1 20 1 1       3x3   6010420.0 2098909.0 37.7437920807055 -122.406617489968 (37.7437920807055, -122.406617489968)
101181 117473 2 86 1201x MONTGOMERY ST 1 20 1 1           6011733.0 2119731.0 37.8010379082809 -122.403542078239 (37.8010379082809, -122.403542078239)
101847 117472 2 86 1201x MONTGOMERY ST 2 20 1 1           6011733.0 2119731.0 37.8010379082809 -122.403542078239 (37.8010379082809, -122.403542078239)
102685 110629 2 3 1000X MANDALAY LN 1 20 1 1           5991616.0 2101838.0 37.75076437998511 -122.47185008331101 (37.7507643799851, -122.471850083311)
103512 114768 2 3 155X Bronte St 1 20 1 1     12     6009330.8 2096609.5 37.737417155901 -122.410221383029 (37.737417155901, -122.410221383029)
103822 117063 2 338 229 MONTCALM ST 1 20 1 1       3x3   6009811.0 2099554.0 37.7455290185947 -122.40876877231001 (37.7455290185947, -122.40876877231)
105857 110647 2 128 300x NAGLEE AVE 1 20 1 1     12 3x3   5997872.0 2088397.0 37.7142185912398 -122.449248128432 (37.7142185912398, -122.449248128432)
108720 120968 2 36 79x Bradford St 1 20 1 1     30 3x3   6009615.0 2098188.0 37.7417673011584 -122.409350130422 (37.7417673011584, -122.409350130422)
109009 121792 2 3 2556 Broderick St 1 20 1 1       3x3   6000243.0 2117343.0 37.7938325936105 -122.443130684772 (37.7938325936105, -122.443130684772)
120690 110630 2 46 1050X MANDALAY LN 1 20 1 1           5991857.0 2101850.0 37.7508112705894 -122.47101756601101 (37.7508112705894, -122.471017566011)
128888 110631 2 17 1001X Mandalay Ln   20 1 1           5991736.200759999 2101819.33429 37.7507200830769 -122.47143306251002 (37.7507200830769, -122.47143306251)
134118 112789 2 28 23x Joice St 1 20 1 1     8 3x3   6010300.14411 2116243.45137 37.7913818092657 -122.408254279811 (37.7913818092657, -122.408254279811)
138700 116778 2 3 398x GAVEN ST 1 20 1 1     30 3x3   6008462.0 2094745.0 37.732248905538704 -122.41309344179899 (37.7322489055387, -122.413093441799)
142909 112794 2 28 21x JOICE ST 5 20 1 1           6010276.0 2116206.0 37.7912776248382 -122.40833517558599 (37.7912776248382, -122.408335175586)
153057 112790 2 88 20 Joice St 1 20 1 1     11 3x3   6010307.8181300005 2116296.03331 37.791526616311295 -122.40823143793502 (37.7915266163113, -122.408231437935)
Powered by Datasette · Query took 2.241ms · Data source: data.sfgov.org