trees

Custom SQL query returning 85 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
640 222906 1 5 363 Page St 3 Sidewalk: Curb side : Cutout Tree 2     9 Width 4ft   6004761.72453 2109824.22026 37.7734445081828 -122.42695971791 (37.7734445081828, -122.42695971791) 7 9 11 28852 10
15625 27616 1 5 775 McAllister St 4 Sidewalk: Curb side : Cutout Tree 1     24 4x4   6005483.48508 2112000.60744 37.7794611228941 -122.424617889559 (37.7794611228941, -122.424617889559) 7 9 11 28852 41
16559 222925 1 5 1025 Clayton St 2 Sidewalk: Curb side : Cutout Tree 2     12 Width 4ft   5998825.08997 2106348.09575 37.7635624787486 -122.447245077795 (37.7635624787486, -122.447245077795) 15 5 11 29492 9
18217 222886 1 5 139 Webster St 1 : Tree 2     15 Width 3ft   6004216.91806 2109283.17336 37.7719281046318 -122.428805703247 (37.7719281046318, -122.428805703247) 7 9 11 29492 10
18852 222928 1 5 912 Clayton St 2 Sidewalk: Curb side : Cutout Tree 2     11 Width 4ft   5998758.16977 2106859.07637 37.7649616790718 -122.447513315894 (37.7649616790718, -122.447513315894) 15 5 11 29492 9
19336 247504 1 5 1398 Haight St 1 Sidewalk: Curb side : Cutout Tree 2     15 Width 0ft   5999483.6766 2108789.6708 37.7703040400286 -122.445142787454 (37.7703040400286, -122.445142787454) 15 5 11 29492 9
24686 20125 7 5 924X Fell St 5 Sidewalk: Curb side : Cutout Tree 2     18 3X3   6002999.41967 2110319.25168 37.7747039360019 -122.433091154251 (37.7747039360019, -122.433091154251) 15 5 11 29492 10
24753 140022 1 5 775 MCALLISTER ST 2 Sidewalk: Curb side : Cutout Tree 2     16 Width 0ft   6005467.685 2112000.1843 37.7794590687234 -122.424672518677 (37.7794590687234, -122.424672518677) 7 9 11 28852 41
25251 14688 1 5 775 McAllister St 3 Sidewalk: Curb side : Cutout Tree 1     26 4x4   6005346.74925 2111820.94662 37.7789600951073 -122.425078130411 (37.7789600951073, -122.425078130411) 7 9 11 28852 41
25898 225060 1 5 243 Parnassus Ave 2 Sidewalk: Curb side : Cutout Tree 2     10 Width 3ft   5997087.67897 2106671.87912 37.7643520771977 -122.453277577199 (37.7643520771977, -122.453277577199) 15 5 11 29492 12
26621 222916 1 5 92 Webster St 1 Sidewalk: Curb side : Cutout Tree 2     12 Width 4ft   6004301.92294 2109033.13825 37.7712463798496 -122.428493839936 (37.7712463798496, -122.428493839936) 7 9 11 28852 10
32299 222920 1 5 957 Cole St 1 Sidewalk: Curb side : Cutout Tree 2     13 Width 4ft   5998076.5165 2106905.97838 37.765051481758 -122.449874352843 (37.765051481758, -122.449874352843) 15 5 11 29492 9
35932 222922 1 5 848 Clayton St 1 Sidewalk: Curb side : Cutout Tree 2     15 Width 4ft   5998725.13711 2107078.63003 37.7655626303238 -122.44764337315 (37.7655626303238, -122.44764337315) 15 5 11 29492 9
36977 14687 1 5 775 McAllister St 2 Sidewalk: Curb side : Cutout Tree 1     24 4x4   6005346.74925 2111820.94662 37.7789600951073 -122.425078130411 (37.7789600951073, -122.425078130411) 7 9 11 28852 41
41601 222917 1 5 88 Webster St 1 Sidewalk: Curb side : Cutout Tree 2     16 Width 4ft   6004303.69708 2109018.65394 37.7712067098536 -122.428486670528 (37.7712067098536, -122.428486670528) 7 9 11 28852 10
47090 222910 1 5 363 Page St 7 Sidewalk: Curb side : Cutout Tree 2     10 Width 4ft   6004846.32395 2109834.20253 37.7734767003282 -122.426667787188 (37.7734767003282, -122.426667787188) 7 9 11 28852 10
49432 222887 1 5 123 Webster St 1 : Tree 2     13 Width 5ft   6004226.51196 2109212.81898 37.77173547164 -122.428767500918 (37.77173547164, -122.428767500918) 7 9 11 29492 10
55304 14686 1 5 775 McAllister St 1 Sidewalk: Curb side : Cutout Tree 1     16 4X4   6005447.7824 2111997.5051 37.7794505882327 -122.424741179621 (37.7794505882327, -122.424741179621) 7 9 11 28852 41
56518 237914 1 5 1001 Stanyan St 1 Sidewalk: Curb side : Cutout Tree 1     21 Width 4ft   5997227 2107052 37.7654037766697 -122.452823145368 (37.7654037766697, -122.452823145368) 15 5 11 29492 12
56818 139055 1 5 2693 SUTTER ST 1 Sidewalk: Curb side : Cutout Tree 2     9 Width 0ft   5999732.7035 2113978.0164 37.7845641202108 -122.444654378813 (37.7845641202108, -122.444654378813) 15 6 11 29490 31
57482 140579 1 5 949 FILLMORE ST 2 Sidewalk: Curb side : Cutout Tree 2     13 Width 0ft   6003399.7999 2111643.4846 37.7783626547096 -122.431800729752 (37.7783626547096, -122.431800729752) 15 9 11 29492 41
57765 225058 1 5 283 Carl St 1 Sidewalk: Curb side : Cutout Tree 2     5 Width 3ft   5996870.76469 2106986.93981 37.76520471814 -122.454050575073 (37.76520471814, -122.454050575073) 15 5 11 29492 12
61840 222914 1 5 108 Webster St 1 Sidewalk: Curb side : Cutout Tree 2     14 Width 2ft   6004276.58953 2109191.75922 37.7716804808011 -122.428592777936 (37.7716804808011, -122.428592777936) 7 9 11 28852 10
67065 222911 1 5 363 Page St 8 Sidewalk: Curb side : Cutout Tree 2     9 Width 4ft   6004864.94155 2109835.08183 37.7734801672159 -122.426603448797 (37.7734801672159, -122.426603448797) 7 9 11 28852 10
68805 225098 1 5 290 Waller St 3 Sidewalk: Curb side : Yard Tree 2     16 Width 3ft   6004313.03232 2109116.83696 37.7714768248189 -122.428461378912 (37.7714768248189, -122.428461378912) 7 9 11 28852 10
69905 222921 1 5 957 Cole St 2 Sidewalk: Curb side : Cutout Tree 2     20 Width 4ft   5998078.46928 2106885.24351 37.7649946607859 -122.449866104246 (37.7649946607859, -122.449866104246) 15 5 11 29492 9
72504 225095 1 5 231 Waller St 1 Sidewalk: Curb side : Cutout Tree 2     1 Width 3ft   6004583.37564 2109107.4182 37.7714662577942 -122.427525575841 (37.7714662577942, -122.427525575841) 7 9 11 28852 10
77005 140023 1 5 775 MCALLISTER ST 3 Sidewalk: Curb side : Cutout Tree 2     13 Width 0ft   6005484.9085 2112001.3325 37.7794631941198 -122.424613016933 (37.7794631941198, -122.424613016933) 7 9 11 28852 41
78514 222913 1 5 112 Webster St 1 Sidewalk: Curb side : Cutout Tree 2     13 Width 3ft   6004271.62218 2109232.31503 37.771791556066 -122.428612851729 (37.771791556066, -122.428612851729) 7 9 11 28852 10
85587 94581 7 5 1025 Clayton St 2 Sidewalk: Curb side : Cutout Tree 2       4x4   5998825 2106371 37.763625362932 -122.447247037522 (37.763625362932, -122.447247037522) 15 5 11 29492 9
95691 225059 1 5 245 Carl St 1 Sidewalk: Curb side : Cutout Tree 2     20 Width 4ft   5997024.32382 2107012.23049 37.7652829636624 -122.453521279988 (37.7652829636624, -122.453521279988) 15 5 11 29492 12
96630 222908 1 5 363 Page St 5 Sidewalk: Curb side : Cutout Tree 2     5 Width 4ft   6004803.10417 2109829.19919 37.773460518813 -122.426816934368 (37.773460518813, -122.426816934368) 7 9 11 28852 10
104673 222889 1 5 81 Webster St 1 Sidewalk: Curb side : Yard Tree 2     12 Width 4ft   6004268.74767 2108942.84192 37.7709965706599 -122.428602156987 (37.7709965706599, -122.428602156987) 7 9 11 29492 10
104983 244452 1 5 411 Fillmore St 1 Sidewalk: Curb side : Cutout Tree 2     9 Width 0ft   6003668.1352 2109738.0991 37.7731461435953 -122.430736452264 (37.7731461435953, -122.430736452264) 15 9 11 29492 10
106329 142100 1 5 904 Fell St 5 Sidewalk: Curb side : Cutout Tree 2     12 Width 0ft   6002972.7027 2110318.8393 37.7747012881718 -122.433183544102 (37.7747012881718, -122.433183544102) 15 5 11 29492 10
108228 225097 1 5 290 Waller St 2 Sidewalk: Curb side : Yard Tree 2     17 Width 3ft   6004333.63591 2109116.41234 37.7714768248196 -122.42839007974 (37.7714768248196, -122.42839007974) 7 9 11 28852 10
108294 140580 1 5 949 FILLMORE ST 3 Sidewalk: Curb side : Cutout Tree 2     13 Width 0ft   6003403.4849 2111618.6108 37.7782945663272 -122.43178620552 (37.7782945663272, -122.43178620552) 15 9 11 29492 41
110010 222924 1 5 1025 Clayton St 1 Sidewalk: Curb side : Cutout Tree 2     12 Width 4ft   5998822.08068 2106365.67219 37.763610567293 -122.447256751019 (37.763610567293, -122.447256751019) 15 5 11 29492 9
111120 225061 1 5 1289 Stanyan St 1 Sidewalk: Curb side : Cutout Tree 2     8 Width 6ft   5997502.5049 2105021.09629 37.7598432128005 -122.451723726786 (37.7598432128005, -122.451723726786) 15 5 11 29492 12
111387 222904 1 5 363 Page St 1 Sidewalk: Curb side : Cutout Tree 2     11 Width 4ft   6004715.38798 2109818.79814 37.7734270001802 -122.427119616485 (37.7734270001802, -122.427119616485) 7 9 11 28852 10
111478 139056 1 5 2693 SUTTER ST 2 Sidewalk: Curb side : Cutout Tree 2     8 Width 0ft   5999748.2433 2113980.0087 37.7845704772917 -122.444600759792 (37.7845704772917, -122.444600759792) 15 6 11 29490 31
111673 222927 1 5 912 Clayton St 1 Sidewalk: Curb side : Cutout Tree 2     8 Width 4ft   5998760.52748 2106841.60616 37.764913845009 -122.44750390358 (37.764913845009, -122.44750390358) 15 5 11 29492 9
115453 222918 1 5 140 Carl St 1 Sidewalk: Curb side : Cutout Tree 2     15 Width 3ft   5997702.83236 2107152.93734 37.7657081802151 -122.451184638974 (37.7657081802151, -122.451184638974) 15 5 11 29492 9
116588 222905 1 5 363 Page St 2 Sidewalk: Curb side : Cutout Tree 2     10 Width 4ft   6004739.78961 2109820.49268 37.7734330328342 -122.427035328438 (37.7734330328342, -122.427035328438) 7 9 11 28852 10
117059 222915 1 5 100 Webster St 1 Sidewalk: Curb side : Cutout Tree 2     18 Width 4ft   6004287.81752 2109130.32918 37.7715124442731 -122.42854956012 (37.7715124442731, -122.42854956012) 7 9 11 28852 10
118207 225062 1 5 139 Downey St 1 Sidewalk: Curb side : Cutout Tree 2     10 Width 3ft   5998883.5307 2107364.06639 37.7663554177878 -122.447116070946 (37.7663554177878, -122.447116070946) 15 5 11 29492 9
132144 222926 1 5 980 Clayton St 1 Sidewalk: Curb side : Cutout Tree 2     11 Width 4ft   5998842.04298 2106555.36385 37.7641325536076 -122.447201360861 (37.7641325536076, -122.447201360861) 15 5 11 29492 9
133710 222919 1 5 121 Carl St 1 Sidewalk: Curb side : Cutout Tree 2     9 Width 3ft   5997880.24105 2107132.61559 37.7656625378249 -122.450569558437 (37.7656625378249, -122.450569558437) 15 5 11 29492 9
139016 140578 1 5 949 FILLMORE ST 1 Sidewalk: Curb side : Cutout Tree 2     12 Width 0ft   6003397.0361 2111670.2009 37.7784358543561 -122.431812198827 (37.7784358543561, -122.431812198827) 15 9 11 29492 41
145445 222923 1 5 88 Parnassus Ave 2 Sidewalk: Curb side : Cutout Tree 2     14 Width 4ft   5998162.74598 2106870.63901 37.7649593821837 -122.449573561064 (37.7649593821837, -122.449573561064) 15 5 11 29492 9
147007 222888 1 5 109 Webster St 1 Sidewalk: Curb side : Cutout Tree 2     14 Width 4ft   6004218 2109157 37.7715817245566 -122.428792964354 (37.7715817245566, -122.428792964354) 7 9 11 29492 10
155575 222907 1 5 363 Page St 4 Sidewalk: Curb side : Cutout Tree 2     9 Width 4ft   6004783.41695 2109826.60113 37.7734522720333 -122.426884850272 (37.7734522720333, -122.426884850272) 7 9 11 28852 10
161658 225096 1 5 290 Waller St 1 Sidewalk: Curb side : Cutout Tree 2     13 Width 3ft   6004357.77926 2109121.04656 37.7714909154158 -122.428306896964 (37.7714909154158, -122.428306896964) 7 9 11 28852 10
168987 222912 1 5 363 Page St 9 Sidewalk: Curb side : Cutout Tree 2     11 Width 4ft   6004886.98291 2109837.99569 37.7734894140273 -122.42652741201 (37.7734894140273, -122.42652741201) 7 9 11 28852 10
169246 14640 1 5 600X McAllister St 3 Sidewalk: Curb side : Cutout Tree 1     18 4x4   6006169.26455 2112150.7692 37.779912136471 -122.422256155719 (37.779912136471, -122.422256155719) 7 9 11 28852 41
169680 225063 1 5 247 Downey St 1 Sidewalk: Curb side : Cutout Tree 2     4 Width 3ft   5998979.47876 2106681.18548 37.7644858801306 -122.44673506599 (37.7644858801306, -122.44673506599) 15 5 11 29492 9
170663 225064 1 5 253 Downey St 1 Sidewalk: Curb side : Cutout Tree 2     4 Width 3ft   5998981.07779 2106664.05961 37.7644389481338 -122.446728303069 (37.7644389481338, -122.446728303069) 15 5 11 29492 9
171993 225042 1 5 979 Ashbury St 2 Sidewalk: Curb side : Cutout Tree 2     10 Width 4ft   5999193.16537 2106656.55415 37.7644304531311 -122.445994213458 (37.7644304531311, -122.445994213458) 15 5 11 29492 9
176339 244469 1 5 665 Page St 1 Sidewalk: Curb side : Cutout Tree 2     11 Width 0ft   6003415.8306 2109638.093 37.7728572538387 -122.431602065027 (37.7728572538387, -122.431602065027) 15 9 11 29492 10
187922 10409 1 5 1398 HAIGHT ST 2 Sidewalk: Curb side : Cutout Tree 1     24 3x3   5999436 2108778 37.7702692735678 -122.445306860847 (37.7702692735678, -122.445306860847) 15 5 11 29492 9
192717 222909 1 5 363 Page St 6 Sidewalk: Curb side : Cutout Tree 2     2 Width 4ft   6004826.79581 2109830.90843 37.7734665514719 -122.426735103265 (37.7734665514719, -122.426735103265) 7 9 11 28852 10
107743 54886 7 5 140 Carl St 1 Sidewalk: Curb side : Cutout Tree 2   08/16/1972 12:00:00 AM   3x4 Permit Number 10751 5997750.13061777 2107162.33224107 37.7657366841835 -122.451021722872 (37.7657366841835, -122.451021722872) 15 5 11 29492 9
112170 56845 7 5 980 Clayton St 1 Sidewalk: Curb side : Cutout Tree 2   08/02/1974 12:00:00 AM   4x4 Permit Number 14078 5998833.42862215 2106621.08669964 37.7643125198309 -122.447235885769 (37.7643125198309, -122.447235885769) 15 5 11 29492 9
53679 56848 7 5 1025 Clayton St 1 Sidewalk: Curb side : Cutout Tree 2   08/02/1974 12:00:00 AM   6x5 Permit Number 14082 5998817.86133668 2106377.94605096 37.7636440271414 -122.447272227776 (37.7636440271414, -122.447272227776) 15 5 11 29492 9
16205 222929 1 5 979 Ashbury St 1 Sidewalk: Curb side : Cutout Tree 2   03/21/1979 12:00:00 AM 10 Width 4ft Permit Number 17592 5999199.8898 2106672.6396 37.7644750037296 -122.445972112616 (37.7644750037296, -122.445972112616) 15 5 11 29492 9
36090 58566 7 5 119 Carl St 1 Sidewalk: Curb side : Cutout Tree 2   04/16/1979 12:00:00 AM   3x3 Permit Number 17756 5997901.33257876 2107130.89979942 37.7656590338964 -122.450496484092 (37.7656590338964, -122.450496484092) 15 5 11 29492 9
112903 62270 7 5 102 Webster St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/09/1985 12:00:00 AM     Permit Number 22404 6004290.78316217 2109110.18870614 37.7714573112605 -122.42853786595 (37.7714573112605, -122.42853786595) 7 9 11 28852 10
62864 62271 7 5 108 Webster St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/09/1985 12:00:00 AM     Permit Number 22405 6004283.36290773 2109163.56782991 37.7716034574246 -122.428567338549 (37.7716034574246, -122.428567338549) 7 9 11 28852 10
131347 62272 7 5 113 Webster St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/09/1985 12:00:00 AM     Permit Number 22406 6004233.40404883 2109145.28748516 37.7715504366717 -122.428738845772 (37.7715504366717, -122.428738845772) 7 9 11 29492 10
102569 62273 7 5 123 Webster St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/09/1985 12:00:00 AM     Permit Number 22409 6004226.44756002 2109195.3304156 37.7716874486567 -122.428766476737 (37.7716874486567, -122.428766476737) 7 9 11 29492 10
26541 62275 7 5 141 Webster St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/09/1985 12:00:00 AM     Permit Number 22411 6004215.98521889 2109270.59348358 37.771893510559 -122.428808033039 (37.771893510559, -122.428808033039) 7 9 11 29492 10
89492 63739 7 5 665 Page St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/22/1988 12:00:00 AM     Permit Number 24410 6003393.73641512 2109629.91106527 37.7728335359212 -122.431677907074 (37.7728335359212, -122.431677907074) 15 9 11 29492 10
71727 65411 7 5 81 Webster St 1 Sidewalk: Curb side : Cutout Tree 2   11/16/1989 12:00:00 AM     Permit Number 28262 6004263.16526256 2108931.19399052 37.7709642723528 -122.428620636268 (37.7709642723528, -122.428620636268) 7 9 11 29492 10
172639 56842 7 5 910 Clayton St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 04/29/1992 12:00:00 AM 3   Permit Number 30536 5998759.08975741 2106864.1829233 37.7649757529568 -122.447510501506 (37.7649757529568, -122.447510501506) 15 5 11 29492 9
69587 67184 7 5 912 Clayton St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 05/06/1992 12:00:00 AM     Permit Number 30631 5998760.11857013 2106856.81248154 37.7649555743728 -122.447506412542 (37.7649555743728, -122.447506412542) 15 5 11 29492 9
93446 67186 7 5 281 Carl St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 05/06/1992 12:00:00 AM     Permit Number 30634 5996869.12207945 2106987.0610707 37.7652049569046 -122.454056265196 (37.7652049569046, -122.454056265196) 15 5 11 29492 12
181866 68375 7 5 175 Alma St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 08/09/1993 12:00:00 AM     Permit Number 32198 5997884.42699251 2106160.35589629 37.7629931985038 -122.45048498279 (37.7629931985038, -122.45048498279) 15 5 11 29492 9
20659 59670 7 5 98X PARNASSUS AVE 3 Sidewalk: Curb side : Cutout Tree 2 FUF 08/09/1993 12:00:00 AM 15 3x3 Permit Number 32228 5998297 2106864 37.7649488326227 -122.449108733904 (37.7649488326227, -122.449108733904) 15 5 11 29492 9
29498 225099 1 5 109 Germania St 1 Sidewalk: Curb side : Cutout Tree 2   12/04/1996 12:00:00 AM 14 Width 3ft Permit Number 37779 6003663.75485 2108815.27117 37.7706120358534 -122.430685739554 (37.7706120358534, -122.430685739554) 15 9 11 29492 10
177869 33711 7 5 109 Germania St 1 Sidewalk: Curb side : Cutout Tree 2   12/04/1996 12:00:00 AM     Permit Number 37779 6003691.57039211 2108804.29883955 37.7705834843276 -122.430588742236 (37.7705834843276, -122.430588742236) 15 9 11 29492 10
56519 44334 7 5 57 Webster St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 03/06/2001 12:00:00 AM     Permit Number 43719 6004283.91720992 2108781.91004669 37.770555549309 -122.428538212023 (37.770555549309, -122.428538212023) 7 9 11 29492 10
35310 47061 7 5 114 Webster St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 05/02/2002 12:00:00 AM   3x3 Permit Number 45048 6004275.94265243 2109216.94695979 37.7717496035942 -122.428596811267 (37.7717496035942, -122.428596811267) 7 9 11 28852 10
164599 51670 7 5 848 Clayton St 1 Sidewalk: Curb side : Cutout Tree 2         Permit Number 47948 5998713.82301338 2107188.47532501 37.765863591183 -122.447690414133 (37.765863591183, -122.447690414133) 15 5 11 29492 9
50010 85052 7 5 355x Page St 2 Sidewalk: Curb side : Cutout Tree 5   06/27/2007 12:00:00 AM     Permit Number 49332 6004826.8 2109751.4 37.7732482408903 -122.426729425627 (37.7732482408903, -122.426729425627) 7 9 11 28852 10
138479 85051 7 5 355x Page St 1 Sidewalk: Curb side : Cutout Tree 5   06/27/2007 12:00:00 AM     Permit Number 49332 6004826.8 2109751.4 37.7732482408903 -122.426729425627 (37.7732482408903, -122.426729425627) 7 9 11 28852 10