sf-trees

Data source: data.sfgov.org

Custom SQL query returning 34 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
10119 173856 3 103 118 Saint Mary's Ave 2 9 1 2       Width 3ft   6003956.18287 2095944.61673 37.735288805319904 -122.42875656067 (37.7352888053199, -122.42875656067)
22892 251144 6 103 200X Clarendon Ave 1 9 1 1       3x3   5996559.0 2104265.0 37.7577130831875 -122.454932197022 (37.7577130831875, -122.454932197022)
22896 251145 6 103 200X Clarendon Ave 1 9 1 1       3x3   5996559.0 2104265.0 37.7577130831875 -122.454932197022 (37.7577130831875, -122.454932197022)
26913 224258 2 103 355 Buena Vista Ave East 14 9 1 1     21 Width 3ft   6001075.26018 2107893.8305599997 37.7679350014146 -122.439573286101 (37.7679350014146, -122.439573286101)
32543 176345 2 103 450 Raymond Ave 3 9 1 1     34     6008420.88631 2088405.51015 37.7148397004654 -122.412787554496 (37.7148397004654, -122.412787554496)
32753 224251 2 103 177 Powhattan Ave 3 9 1 1     21 Width 3ft   6008204.54136 2098121.72815 37.741506207147005 -122.414222358085 (37.741506207147, -122.414222358085)
35751 224259 2 103 355 Buena Vista Ave East 15 9 1 1     19 Width 3ft   6001093.91519 2107903.0746400002 37.767961445086605 -122.43950942341999 (37.7679614450866, -122.43950942342)
37470 176346 2 103 40 Teddy Ave 1 9 1 1     18     6011228.44814 2087808.7969 37.7133584325151 -122.40304144861 (37.7133584325151, -122.40304144861)
39683 191728 2 103 1790 23rd St 5 9 1 1     21     6013472.8835 2102915.30193 37.754962860065 -122.39634201017999 (37.754962860065, -122.39634201018)
43564 207757 2 103 95 Kirkham St 8 9 1 1     24     5994806.26925 2105291.62903 37.760431240817795 -122.46106822873399 (37.7604312408178, -122.461068228734)
46778 209043 2 103 690 Mangels Ave 5 9 1 1     54 Width 10ft   5996832.93686 2095303.5906200001 37.7331229707542 -122.453337845278 (37.7331229707542, -122.453337845278)
61025 224257 2 103 355 Buena Vista Ave East 13 9 1 1     14 Width 3ft   6001064.07525 2107884.43165 37.767908557750204 -122.439611299541 (37.7679085577502, -122.439611299541)
71482 176344 2 103 450 Raymond Ave 2 9 1 1     8     6008453.924319999 2088393.6006200002 37.714808853708604 -122.41267251952299 (37.7148088537086, -122.412672519523)
74562 209046 2 103 301 Joost Ave 1 9 1 1     55 Width 10ft   5999983.24986 2094934.98428 37.732290932375605 -122.442419949729 (37.7322909323756, -122.442419949729)
76683 185931 2 103 2000 Sunset Blvd 74 9 1 1     2 Width 0ft   5985001.315 2101504.3546 37.749463324703996 -122.494699314147 (37.749463324704, -122.494699314147)
77244 185929 2 103 2000 Sunset Blvd 72 9 1 1     99 Width 0ft   5985012.7201 2101493.4926 37.7494341681805 -122.494659074897 (37.7494341681805, -122.494659074897)
90816 119631 2 103 265 Fowler Ave 1 9 1 1     15 3x5   5997384.0 2099137.0 37.7436801569324 -122.451709113802 (37.7436801569324, -122.451709113802)
102861 112189 3 103 301x CORBETT AVE 1 9 1 2     12 3x3   5999677.0 2105220.0 37.760513648972996 -122.444217531177 (37.760513648973, -122.444217531177)
102986 112188 3 103 301x CORBETT AVE 2 9 1 2     45 3x3   5999677.0 2105220.0 37.760513648972996 -122.444217531177 (37.760513648973, -122.444217531177)
103018 104402 2 103 301 Joost Ave 1 9 1 1           6000011.7 2094912.1 37.7322297190532 -122.44231994912901 (37.7322297190532, -122.442319949129)
130593 191727 2 103 1790 23rd St 1 9 1 1     21     6013509.42079 2102917.94191 37.7549721419751 -122.396215837988 (37.7549721419751, -122.396215837988)
134672 207755 2 103 95 Kirkham St 6 9 1 1     43     5994788.04604 2105291.71815 37.7604304368423 -122.46113126040702 (37.7604304368423, -122.461131260407)
137374 224256 2 103 355 Buena Vista Ave East 12 9 1 1     24 Width 3ft   6001050.217680001 2107873.3371599996 37.7678773063135 -122.439658435714 (37.7678773063135, -122.439658435714)
138334 207756 2 103 95 Kirkham St 7 9 1 1     49     5994800.39892 2105292.04488 37.7604320448233 -122.461088561491 (37.7604320448233, -122.461088561491)
151150 126581 2 103 556 Pine St 2 9 1 1     20 Width 5ft   6011285.65956 2116338.25251 37.7916972455684 -122.404851076143 (37.7916972455684, -122.404851076143)
158274 176343 2 103 450 Raymond Ave 1 9 1 1     76     6008484.74111 2088383.4213400001 37.714782633086294 -122.412565284366 (37.7147826330863, -122.412565284366)
159737 224252 2 103 177 Powhattan Ave 4 9 1 1     35 Width 3ft   6008209.41115 2098117.01266 37.741493532991 -122.41420518642299 (37.741493532991, -122.414205186423)
161658 209044 2 103 690 Mangels Ave 8 9 1 1     30 Width 10ft   5996811.85436 2095301.80777 37.7331168670328 -122.453410604043 (37.7331168670328, -122.453410604043)
168122 169607 3 103 118 Saint Mary's Ave 1 9 1 2     0 Width 3ft   6003956.18287 2095944.61673 37.735288805319904 -122.42875656067 (37.7352888053199, -122.42875656067)
171861 224261 2 103 355 Buena Vista Ave East 18 9 1 1     17 Width 3ft   6001117.5941 2107921.40745 37.768013130033204 -122.439428835199 (37.7680131300332, -122.439428835199)
174806 185917 2 103 2000 Sunset Blvd 60 9 1 1     16 Width 0ft   5985004.5736 2101420.7172 37.749233870008794 -122.494681880668 (37.7492338700088, -122.494681880668)
175102 224260 2 103 355 Buena Vista Ave East 16 9 1 1     23 Width 3ft   6001102.84855 2107909.89342 37.7679806761809 -122.43947901285401 (37.7679806761809, -122.439479012854)
179355 207758 2 103 95 Kirkham St 9 9 1 1     45     5994815.677630001 2105291.72467 37.7604320448236 -122.461035696659 (37.7604320448236, -122.461035696659)
183396 176347 2 103 40 Teddy Ave 2 9 1 1     29     6011214.18105 2087815.3375799998 37.7133755951756 -122.403091220704 (37.7133755951756, -122.403091220704)
Powered by Datasette · Query took 39.602ms · Data source: data.sfgov.org