sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
158597 120329 2 19 1 22nd Ave 1 2 1 1     12 Width 3ft   5988944.22714 2115048.40717 37.7868815758996 -122.48205685669 (37.7868815758996, -122.48205685669)
38919 201349 2 19 1 Bitting Ave 11 9 1 1     6 Width 8ft   6012827.9931 2092586.2696 37.7265656062986 -122.39784774058998 (37.7265656062986, -122.39784774059)
44637 201345 2 19 1 Bitting Ave 7 9 1 1     5 Width 8ft   6012754.450780001 2092609.0590599999 37.726624085606396 -122.398103573427 (37.7266240856064, -122.398103573427)
131124 201347 2 19 1 Bitting Ave 9 9 1 1     3 Width 8ft   6012791.8631 2092596.6146799999 37.7265919996064 -122.397973366875 (37.7265919996064, -122.397973366875)
131673 201354 2 19 1 Bitting Ave 16 9 1 1     6 Width 10ft   6012921.134769999 2092559.31371 37.726496777601795 -122.39752386145099 (37.7264967776018, -122.397523861451)
135032 201351 2 19 1 Bitting Ave 13 9 1 1     5 Width 8ft   6012866.15074 2092573.2448900002 37.7265319680523 -122.397714917004 (37.7265319680523, -122.397714917004)
149516 201350 2 19 1 Bitting Ave 12 9 1 1     4 Width 8ft   6012847.3383 2092578.90387 37.726546458834896 -122.397780348078 (37.7265464588349, -122.397780348078)
154484 201353 2 19 1 Bitting Ave 15 9 1 1     6 Width 8ft   6012904.00238 2092563.8073 37.7265081621175 -122.39758340285101 (37.7265081621175, -122.397583402851)
166848 201346 2 19 1 Bitting Ave 8 9 1 1     3 Width 8ft   6012773.9855 2092601.68911 37.7266049372574 -122.39803552533199 (37.7266049372574, -122.398035525332)
168356 201352 2 19 1 Bitting Ave 14 9 1 1     6 Width 8ft   6012884.58431 2092567.5936099999 37.7265174772786 -122.397650796243 (37.7265174772786, -122.397650796243)
173712 201343 2 19 1 Bitting Ave 5 9 1 1     5     6012739.9825 2092614.2530099999 37.72663754126479 -122.39815395433399 (37.7266375412648, -122.398153954334)
177390 201348 2 19 1 Bitting Ave 10 9 1 1     4 Width 8ft   6012808.60563 2092591.5632900002 37.7265790619707 -122.397915133977 (37.7265790619707, -122.397915133977)
26975 129323 2 19 1 Florence St 1 9 1 1     7     6008475.1891 2118345.56468 37.7970513368976 -122.414717435764 (37.7970513368976, -122.414717435764)
61376 43140 1 19 1 Gambier St 3 1 1 1   07/11/2000 12:00:00 AM 3   Permit Number 42953 6005716.6320400005 2093488.3927799999 37.7286440375939 -122.42249555614299 (37.7286440375939, -122.422495556143)
63937 176847 2 19 1 Gambier St 5 9 1 1     3 Width 4ft   6005714.45632 2093496.12065 37.7286651338862 -122.422503626641 (37.7286651338862, -122.422503626641)
130258 176848 2 19 1 Gambier St 6 9 1 1     3 Width 4ft   6005711.542330001 2093506.49571 37.728693457131 -122.422514437416 (37.728693457131, -122.422514437416)
174196 176849 2 19 1 Gambier St 7 9 1 1     3 Width 4ft   6005708.05423 2093517.46622 37.7287233829612 -122.422527275231 (37.7287233829612, -122.422527275231)
74388 226884 2 19 1 Hidalgo Ter 1 9 1 1     18 Width 2ft   6005071.43074 2107486.3006599997 37.7670426518224 -122.425721963013 (37.7670426518224, -122.425721963013)
93609 124569 2 19 1 Jordan Ave 1 9 1 1     6 Width 3ft   5996154.91779 2114511.96286 37.785825384071394 -122.457070865676 (37.7858253840714, -122.457070865676)
37 226924 2 19 1 Newburg St 1 6 1 1     11 Width 4ft   6002558.65829 2099967.6575700003 37.7462559468486 -122.433875776072 (37.7462559468486, -122.433875776072)
44 226925 2 19 1 Newburg St 2 6 1 1     19 Width 4ft   6002565.841680001 2099976.66752 37.746281093695 -122.433851580699 (37.746281093695, -122.433851580699)
65 226926 2 19 1 Newburg St 3 6 1 1     15 Width 4ft   6002574.76935 2099983.89995 37.7463014588644 -122.433821226777 (37.7463014588644, -122.433821226777)
39701 129113 2 19 10 Hastings Ter 3 9 1 1     2     6007329.70066 2119282.266 37.7995588581063 -122.418747576633 (37.7995588581063, -122.418747576633)
183882 129112 2 19 10 Hastings Ter 2 9 1 1     3     6007339.93679 2119283.26863 37.799562187397704 -122.41871222699801 (37.7995621873977, -122.418712226998)
45644 218230 2 19 100 Claremont Blvd 6 9 1 1     11 Width 8ft   5993788.79546 2098675.54917 37.7422065730654 -122.46410687336001 (37.7422065730654, -122.46410687336)
62797 218228 2 19 100 Claremont Blvd 4 9 1 1     33 Width 8ft   5993822.95601 2098779.1266900003 37.742492939687 -122.463996274721 (37.742492939687, -122.463996274721)
169741 218229 2 19 100 Claremont Blvd 5 9 1 1     10 Width 8ft   5993803.00449 2098718.65979 37.7423257629199 -122.464060872135 (37.7423257629199, -122.464060872135)
186117 218231 2 19 100 Claremont Blvd 7 9 1 1     11 Width 8ft   5993773.53157 2098636.1244900003 37.7420974430581 -122.464156789307 (37.7420974430581, -122.464156789307)
188348 218225 2 19 100 Claremont Blvd 1 9 1 1     22 Width 8ft   5993843.55646 2098914.16079 37.7428648966005 -122.463934844718 (37.7428648966005, -122.463934844718)
188677 218227 2 19 100 Claremont Blvd 3 9 1 1     13 Width 8ft   5993831.45355 2098825.44748 37.742620614658 -122.463970254628 (37.742620614658, -122.463970254628)
188774 218226 2 19 100 Claremont Blvd 2 9 1 1     25 Width 8ft   5993838.37632 2098869.25868 37.7427413081634 -122.46394949738199 (37.7427413081634, -122.463949497382)
30510 30812 1 19 100 Joost Ave 1 1 1 1 1 02/06/1995 12:00:00 AM 5   Permit Number 34674 6001381.93618 2094967.05294 37.7324586091634 -122.43758667648001 (37.7324586091634, -122.43758667648)
153807 219373 2 19 100 Joost Ave 3 9 1 1     6 Width 6ft   6001373.71026 2094967.00776 37.7324580174085 -122.437615112141 (37.7324580174085, -122.437615112141)
62283 219329 2 19 100 Miramar Ave 1 9 1 1     6 Width 4ft   5995365.77553 2090599.7710099998 37.7201232084876 -122.45806987824699 (37.7201232084876, -122.458069878247)
14648 19819 3 19 100 STAIRWAY25 3 1 1 2     12 100ST            
5604 19964 3 19 100 STAIRWAY41 2 1 1 2     6 25ST            
8096 19962 3 19 100 STAIRWAY41 -2 1 1 2     6 25ST            
9264 19963 3 19 100 STAIRWAY41 1 1 1 2     6 25ST            
16920 19979 3 19 100 STAIRWAY45 6 1 1 2     3 30ST            
104404 106685 2 19 100 Yukon St   8 1 1         Permit Number 772768 6000197.4 2104288.0 37.757984281634 -122.44235080136299 (37.757984281634, -122.442350801363)
62666 129281 2 19 1009 Green St 4 9 1 1     6 Width 2ft   6008192.28376 2118905.24878 37.798572191203704 -122.415736009712 (37.7985721912037, -122.415736009712)
72385 129282 2 19 1009 Green St 5 9 1 1     7 Width 2ft   6008205.81975 2118906.85431 37.798577360503394 -122.415689284536 (37.7985773605034, -122.415689284536)
155651 129280 2 19 1009 Green St 2 9 1 1     6 Width 2ft   6008177.93776 2118903.66017 37.798567022807795 -122.41578553897699 (37.7985670228078, -122.415785538977)
97319 88347 1 19 100x Vienna St   1 1 1   07/10/2008 12:00:00 AM   3x3 Permit Number 51332 6004738.0 2092796.0 37.7266876232591 -122.425829482771 (37.7266876232591, -122.425829482771)
133819 120070 2 19 101 26th Ave 1 9 1 1     16 Width 2ft   5987678.122930001 2115272.13774 37.7874221569894 -122.48645366177401 (37.7874221569894, -122.486453661774)
28909 176778 2 19 101 Colby St 1 9 1 1     24 Width 3ft   6008224.08958 2093491.7864599999 37.728794492350396 -122.41382733896499 (37.7287944923504, -122.413827338965)
33950 176781 2 19 101 Dartmouth St 16 9 1 1     8 Width 5ft   6008506.492819999 2093591.6358299998 37.7290845129336 -122.41285810544399 (37.7290845129336, -122.412858105444)
71131 176782 2 19 101 Dartmouth St 17 9 1 1     9 Width 5ft   6008503.6919 2093600.7846099997 37.7291094763057 -122.412868435047 (37.7291094763057, -122.412868435047)
129996 176779 2 19 101 Dartmouth St 12 9 1 1     7 Width 5ft   6008512.5516 2093571.34607 37.729029141679895 -122.412835725785 (37.7290291416799, -122.412835725785)
147527 176780 2 19 101 Dartmouth St 14 9 1 1     7 Width 5ft   6008510.60068 2093581.4689 37.729056827298 -122.412843185683 (37.729056827298, -122.412843185683)
87429 108624 7 19 101 GENEBERN WAY 1 7 1 1           6005050.2 2095237.8 37.733409902631 -122.42492386614401 (37.733409902631, -122.424923866144)
171560 219327 2 19 101 Miramar Ave 2 9 1 1     10 Width 4ft   5995301.64396 2090617.7903200001 37.720169000171296 -122.458292861552 (37.7201690001713, -122.458292861552)
172065 219328 2 19 101 Miramar Ave 3 9 1 1     8 Width 4ft   5995301.79244 2090610.0663299998 37.720147800462996 -122.458291789543 (37.720147800463, -122.458291789543)
187057 219326 2 19 101 Miramar Ave 1 9 1 1     10 Width 4ft   5995302.40607 2090624.5686700002 37.7201876557032 -122.45829071756701 (37.7201876557032, -122.458290717567)
61159 129163 2 19 101 Parker Ave 1 9 1 1     18 Width 2ft   5996819.747219999 2113790.05212 37.783881366273704 -122.45471857981701 (37.7838813662737, -122.454718579817)
41916 176824 2 19 102 Bowdoin St 6 9 1 1     6 Width 6ft   6008431.82226 2094483.21435 37.7315284044084 -122.413179268628 (37.7315284044084, -122.413179268628)
42361 176822 2 19 102 Bowdoin St 4 9 1 1     8 Width 6ft   6008425.8217 2094514.9756099998 37.7316152771105 -122.413202258904 (37.7316152771105, -122.413202258904)
58648 176823 2 19 102 Bowdoin St 5 9 1 1     7 Width 6ft   6008429.95223 2094500.1756400003 37.731574871472795 -122.41318693263901 (37.7315748714728, -122.413186932639)
136126 176806 2 19 102 Bowdoin St 2 9 1 1     6 Width 6ft   6008418.41029 2094548.1649200001 37.7317059917167 -122.413230227789 (37.7317059917167, -122.413230227789)
24248 219332 2 19 1025 Junipero Serra Blvd 22 9 1 1     7 Width 3ft   5991262.77441 2090479.13965 37.719555381949206 -122.47224364333 (37.7195553819492, -122.47224364333)
173591 219330 2 19 1025 Junipero Serra Blvd 19 9 1 1     4 Width 3ft   5991259.76279 2090425.50198 37.7194079318084 -122.472250145444 (37.7194079318084, -122.472250145444)
188529 219331 2 19 1025 Junipero Serra Blvd 21 9 1 1     8 Width 3ft   5991262.34027 2090458.54246 37.7194988020073 -122.472243643342 (37.7194988020073, -122.472243643342)
100221 5821 3 19 1027 Duncan St 1 1 1 2     75 3X3   5999811.0829915 2099731.7400522 37.745451872839 -122.443359584044 (37.745451872839, -122.443359584044)
48158 176798 2 19 103 Bowdoin St 3 9 1 1     4 Width 6ft   6008483.53327 2094510.3324 37.7316057676803 -122.41300240975401 (37.7316057676803, -122.413002409754)
56312 176800 2 19 103 Bowdoin St 5 9 1 1     5 Width 6ft   6008479.14615 2094525.5991 37.731647440478 -122.413018655999 (37.731647440478, -122.413018655999)
77062 176799 2 19 103 Bowdoin St 4 9 1 1     10 Width 6ft   6008480.51195 2094517.85625 37.7316262569493 -122.413013386875 (37.7316262569493, -122.413013386875)
168649 176802 2 19 103 Bowdoin St 8 9 1 1     6 Width 6ft   6008473.4395 2094550.88435 37.731716547980206 -122.41304017228201 (37.7317165479802, -122.413040172282)
174736 176801 2 19 103 Bowdoin St 6 9 1 1     7 Width 6ft   6008476.7673 2094533.48941 37.7316689720313 -122.413027437877 (37.7316689720313, -122.413027437877)
186709 176797 2 19 103 Bowdoin St 2 9 1 1     10 Width 6ft   6008485.14768 2094502.3312900001 37.731583888980104 -122.412996262887 (37.7315838889801, -122.412996262887)
187619 176803 2 19 103 Bowdoin St 9 9 1 1     10 Width 6ft   6008471.3844800005 2094562.18285 37.731747455866 -122.41304807552099 (37.731747455866, -122.413048075521)
189128 176796 2 19 103 Bowdoin St 1 9 1 1     6 Width 6ft   6008486.43054 2094496.74036 37.7315686095034 -122.41299143261001 (37.7315686095034, -122.41299143261)
132381 226897 2 19 1035 Duncan St 1 1 1 1     16 Width 2ft   5999804.0569 2099745.02655 37.745487953702 -122.443384833249 (37.745487953702, -122.443384833249)
26630 206935 2 19 105 Flood Ave 3 9 1 1     16 Width 8ft   6000034.8522 2094044.21533 37.7298480292542 -122.442177629193 (37.7298480292542, -122.442177629193)
38096 206933 2 19 105 Flood Ave 1 9 1 1     20 Width 8ft   6000003.13616 2094038.3079799998 37.7298300014536 -122.44228685095301 (37.7298300014536, -122.442286850953)
147711 206936 2 19 105 Flood Ave 4 9 1 1     12 Width 8ft   6000038.50963 2094035.1117 37.7298232412405 -122.44216433183998 (37.7298232412405, -122.44216433184)
170335 206934 2 19 105 Flood Ave 2 9 1 1     19 Width 8ft   6000030.26557 2094035.00933 37.7298224903164 -122.442192825064 (37.7298224903164, -122.442192825064)
35782 190765 2 19 1050 26th St 1 1 1 1     10 Width 3ft   6015259.20985 2101616.65669 37.751496295539106 -122.39007361861601 (37.7514962955391, -122.390073618616)
90274 97299 1 19 1051 Portola Dr 2 9 1 1           5995688.7 2098126.6 37.7408086112536 -122.457497926865 (37.7408086112536, -122.457497926865)
25548 71937 2 19 1053 Montgomery St 1 1 1 1 1 10/21/1995 12:00:00 AM 4     6011562.24883 2118965.23166 37.7989257551836 -122.404079031531 (37.7989257551836, -122.404079031531)
49793 53948 1 19 106 Gaven St 1 1 1 1   08/15/2012 12:00:00 AM 10   Permit Number 769123 6009998.5111 2095243.6282 37.733704169294 -122.407816497929 (37.733704169294, -122.407816497929)
175494 176807 2 19 106 Gaven St 2 9 1 1     13 Width 2ft   6009983.095919999 2095237.75517 37.7336871802039 -122.407869378985 (37.7336871802039, -122.407869378985)
181075 176777 2 19 107 Colby St 1 9 1 1     10 Width 3ft   6008230.80526 2093471.1524 37.7287382127949 -122.413802663375 (37.7287382127949, -122.413802663375)
63947 129335 2 19 1074 Union St 2 9 1 1     3 Width 2ft   6007834.34596 2119269.05545 37.799550985448604 -122.41700038098101 (37.7995509854486, -122.417000380981)
168244 129334 2 19 1074 Union St 1 9 1 1     3 Width 2ft   6007844.96731 2119270.12506 37.799554519795606 -122.416963703016 (37.7995545197956, -122.416963703016)
34986 129263 2 19 1075 Pacific Ave 3 9 1 1     3 Width 1ft   6009008.56152 2117982.3464099998 37.796083982049 -122.41284613813299 (37.796083982049, -122.412846138133)
56672 96034 1 19 1075 Pacific Ave 1 1 1 1 1 09/02/2011 12:00:00 AM 3 3x3 Permit Number 767673 6008986.730930001 2117980.65751 37.7960781193685 -122.41292155709999 (37.7960781193685, -122.4129215571)
35741 129306 2 19 1081 Francisco St 2 9 1 1     4 Width 10ft   6006156.05151 2120698.06699 37.8033801368411 -122.42290950959101 (37.8033801368411, -122.422909509591)
52974 129305 2 19 1081 Francisco St 1 9 1 1     5 Width 10ft   6006148.36265 2120696.43143 37.8033752121629 -122.422936000907 (37.8033752121629, -122.422936000907)
108014 113985 2 19 109 MADRONE AVE 1 5 1 1       3x10   5992778.0 2098364.0 37.74129282931111 -122.46757920887899 (37.7412928293111, -122.467579208879)
32089 219321 2 19 1090 Capitol Ave 7 9 1 1     7 Width 1ft   5995079.2109 2091143.91965 37.7216008413857 -122.45909980971201 (37.7216008413857, -122.459099809712)
32651 219322 2 19 1090 Capitol Ave 8 9 1 1     7 Width 1ft   5995079.87033 2091157.1990200002 37.7216373412734 -122.459098491322 (37.7216373412734, -122.459098491322)
37643 219320 2 19 1090 Capitol Ave 6 9 1 1     5 Width 1ft   5995079.65544 2091128.71847 37.7215591281313 -122.459097172915 (37.7215591281313, -122.459097172915)
42679 219324 2 19 1090 Capitol Ave 10 9 1 1     7 Width 1ft   5995080.31545 2091178.4589099998 37.721695741442396 -122.459098491311 (37.7216957414424, -122.459098491311)
134794 219325 2 19 1090 Capitol Ave 11 9 1 1     6 Width 1ft   5995080.6810800005 2091195.9220900002 37.721743712182395 -122.459098491296 (37.7217437121824, -122.459098491296)
147745 219323 2 19 1090 Capitol Ave 9 9 1 1     7 Width 1ft   5995079.72755 2091168.59616 37.7216686268896 -122.459099809715 (37.7216686268896, -122.459099809715)
134612 190772 2 19 1099 Tennessee St 2 1 1 1     6 Width 1ft   6015576.75199 2103999.13742 37.7580556897494 -122.389141847222 (37.7580556897494, -122.389141847222)
48931 129211 2 19 11 Normandie Ter 10 9 1 1     6 Width 3ft   6000911.6199199995 2117290.07743 37.793725383184295 -122.440813405326 (37.7937253831843, -122.440813405326)
60802 129210 2 19 11 Normandie Ter 9 9 1 1     4 Width 3ft   6000912.13744 2117299.9912900003 37.793752633522104 -122.440812326154 (37.7937526335221, -122.440812326154)
133508 129212 2 19 11 Normandie Ter 11 9 1 1     5 Width 3ft   6000913.33947 2117282.2310599997 37.793703937035104 -122.440806892437 (37.7937039370351, -122.440806892437)
152129 129208 2 19 11 Normandie Ter 7 9 1 1     5 Width 3ft   6000907.377069999 2117323.47168 37.7938168334195 -122.44083048255399 (37.7938168334195, -122.440830482554)
175786 129207 2 19 11 Normandie Ter 6 9 1 1     6 Width 3ft   6000907.81607 2117333.5843599997 37.7938446251929 -122.440829689342 (37.7938446251929, -122.440829689342)
Powered by Datasette · Query took 8.726ms · Data source: data.sfgov.org