sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
20 251179 4 13 1043 Minna St 2 5 1 1       3x3   6007668.0 2109797.0 37.7735336727503 -122.41690453761002 (37.7735336727503, -122.41690453761)
21 251178 4 13 1043 Minna St 1 5 1 1       3x3   6007668.0 2109797.0 37.7735336727503 -122.41690453761002 (37.7735336727503, -122.41690453761)
2232 122753 3 13 693 Vermont St 5 1 1 4 2   15     6011277.810190001 2105311.62173 37.7614202297665 -122.404101873421 (37.7614202297665, -122.404101873421)
3237 139408 3 13 1500 GEARY BLVD 8 1 1 2   02/12/1999 12:00:00 AM 3 Width 0ft   6004238.7982 2114043.3981 37.7849997446788 -122.429069479335 (37.7849997446788, -122.429069479335)
3250 139411 3 13 1500 GEARY BLVD 11 1 1 2     8 Width 0ft   6004146.842 2114032.4365 37.784964441153 -122.429386836551 (37.784964441153, -122.429386836551)
3994 159208 2 13 210 Foote Ave 1 1 1 1   10/05/2017 08:54:00 AM 3 Width 0ft   5998556.96811 2088452.2606799998 37.714409480083496 -122.446884596259 (37.7144094800835, -122.446884596259)
3999 181035 2 13 170 Rolph St 1 2 1 1   10/05/2017 04:20:00 PM 3 Width 4ft   6000927.8060099995 2088408.3131900001 37.7144239699579 -122.438686909772 (37.7144239699579, -122.438686909772)
4055 251746 2 13 700 Rolph St 1 1 1 1   10/05/2017 10:33:00 AM 3 3x3   6002943.0 2087289.0 37.711465016812205 -122.431641737098 (37.7114650168122, -122.431641737098)
4078 253099 2 13 210 Foote Ave 2 1 1 1   10/05/2017 08:59:00 AM 3 Width 0ft   5998556.96811 2088452.2606799998 37.714409480083496 -122.446884596259 (37.7144094800835, -122.446884596259)
4083 181036 2 13 170 Rolph St 2 2 1 1   10/05/2017 04:16:00 PM 3 Width 4ft   6000944.46471 2088397.62402 37.7143955675655 -122.438628565353 (37.7143955675655, -122.438628565353)
4157 216804 2 13 297 Lobos St 1 1 1 1   10/06/2017 02:14:00 PM 3 Width 2ft   5994075.3134 2088701.73413 37.7148374215779 -122.462392942697 (37.7148374215779, -122.462392942697)
4229 252890 2 13 301x Howth St 3 1 1 1   10/10/2017 03:50:00 PM 3 3x3   5997131.0 2090234.0 37.7192201544045 -122.451941749186 (37.7192201544045, -122.451941749186)
4261 252888 2 13 301x Howth St 1 1 1 1   10/10/2017 04:03:00 PM 3 3x3   5997131.0 2090234.0 37.7192201544045 -122.451941749186 (37.7192201544045, -122.451941749186)
4284 175543 2 13 187 Seville St 1 2 1 1   10/10/2017 09:37:00 AM 3 Width 6ft   6001178.343719999 2087386.3168 37.7116320444605 -122.43774780171302 (37.7116320444605, -122.437747801713)
4627 160610 2 13 750X France Ave 3 1 1 1   10/18/2017 04:01:00 PM 3 Width 0ft   6002805.02204 2089330.87742 37.717063742780496 -122.432264357312 (37.7170637427805, -122.432264357312)
4644 160608 2 13 750X France Ave 1 1 1 1 1 10/18/2017 03:37:00 PM 3 Width 0ft   6002772.883169999 2089351.94517 37.717119767831505 -122.43237694973499 (37.7171197678315, -122.432376949735)
4671 160609 2 13 750X France Ave 2 1 1 1   10/18/2017 03:56:00 PM 3 Width 0ft   6002789.45595 2089340.3546099998 37.71708888243629 -122.432318838255 (37.7170888824363, -122.432318838255)
4686 160611 2 13 750X France Ave 4 1 1 1 1 10/18/2017 04:11:00 PM 3 Width 0ft   6002821.1864599995 2089320.8920099998 37.717037241564 -122.432207771993 (37.717037241564, -122.432207771993)
13290 187642 6 13 2526 Polk St 1 1 1 1       3x3   6006264.0 2119500.0 37.8000966404513 -122.42245076966002 (37.8000966404513, -122.42245076966)
19097 10252 1 13 124 Haight St 1 1 1 1     9 3X3   6005490.6368 2109629.255 37.7729503696302 -122.424424432873 (37.7729503696302, -122.424424432873)
19318 10251 1 13 120 Haight St 1 1 1 1     11 3X3   6005509.0088 2109632.4226 37.7729601045446 -122.42436110718201 (37.7729601045446, -122.424361107182)
21131 16956 3 13 673 Oak St 1 1 1 2   01/14/1992 12:00:00 AM 6 3X3   6003823.5744 2110036.1086 37.773973209785 -122.43022003270201 (37.773973209785, -122.430220032702)
24689 244218 2 13 1949 Page St 1 1 1 1     8 Width 0ft   5997251.0447 2108771.6628 37.7701269078181 -122.452864114834 (37.7701269078181, -122.452864114834)
24939 143093 2 13 487 Greenwich St 2 2 1 1     16 Width 0ft   6010518.569 2120277.0289 37.8024692600192 -122.407783074103 (37.8024692600192, -122.407783074103)
26201 212832 2 13 1201 Funston Ave 1 9 1 1     1 Width 5ft   5992025.01275 2107217.63828 37.765559111278 -122.47082751866999 (37.765559111278, -122.47082751867)
26751 186196 2 13 1701 Sunset Blvd 5 9 1 1     1 Width 0ft   5984756.9045 2103549.1285 37.7550634017723 -122.495695286455 (37.7550634017723, -122.495695286455)
27591 139137 2 13 1750 Geary Blvd 1 1 1 1     7 Width 0ft   6003531.4353 2113968.7391 37.7847546833549 -122.431511396859 (37.7847546833549, -122.431511396859)
27653 186191 2 13 1701 Sunset Blvd 2 9 1 1     1 Width 0ft   5984752.6191 2103570.02 37.7551205130891 -122.49571164730499 (37.7551205130891, -122.495711647305)
30906 212833 2 13 468 Lansdale Ave 1 1 1 1     1 Width 2ft   5996396.78511 2096388.5906 37.7360771087699 -122.454924099162 (37.7360771087699, -122.454924099162)
31901 200087 2 13 2260 Keith St 1 1 1 1     2 Width 0ft   6014672.5559 2092688.6734 37.7269493390436 -122.391478260518 (37.7269493390436, -122.391478260518)
34640 139142 2 13 1730 GEARY BLVD 6 1 1 1     8 Width 0ft   6003354.1342 2113941.3148 37.784669332502105 -122.432122840709 (37.7846693325021, -122.432122840709)
35328 200091 2 13 2230 Keith St 1 1 1 1     2 Width 0ft   6014724.5498 2092764.8713 37.7271614489349 -122.39130384140199 (37.7271614489349, -122.391303841402)
36043 200090 2 13 2250 Keith St 1 1 1 1     2 Width 0ft   6014714.6889 2092749.6317 37.7271190567752 -122.391336865844 (37.7271190567752, -122.391336865844)
36445 106365 2 13 1970 47th Ave 1 1 1 1 1   1 4x2   5981684.7966 2101671.2426 37.7497268716349 -122.506180099858 (37.7497268716349, -122.506180099858)
37888 116710 2 13 1400 BAKER ST 2 1 1 1     0 3x3   6000422.0 2113928.0 37.7844660975886 -122.442266061376 (37.7844660975886, -122.442266061376)
38506 185519 2 13 2201 Sunset Blvd 3 9 1 1     1 Width 0ft   5984858.6139 2100160.4269 37.7457649124522 -122.495093683302 (37.7457649124522, -122.495093683302)
39799 116709 2 13 1400 BAKER ST 1 1 1 1     0 3x3   6000422.0 2113928.0 37.7844660975886 -122.442266061376 (37.7844660975886, -122.442266061376)
39842 183135 2 13 2315 37th Ave 1 1 1 1     1 Width 0ft   5984823.141 2099420.9741 37.7437324991665 -122.49516182260099 (37.7437324991665, -122.495161822601)
39960 186401 2 13 1801 Sunset Blvd 68 9 1 1     2 Width 0ft   5984842.4701 2102334.3496 37.7517329643959 -122.495309798203 (37.7517329643959, -122.495309798203)
40066 184721 2 13 1630 44th Ave 1 1 1 1     1 Width 0ft   5982537.7064 2103994.8819 37.7561571061486 -122.503402789254 (37.7561571061486, -122.503402789254)
40595 185530 2 13 2201 Sunset Blvd 14 9 1 1     1 Width 0ft   5984911.0151 2100096.2189 37.7455916823633 -122.49490775682699 (37.7455916823633, -122.494907756827)
41633 185634 2 13 2100 Sunset Blvd 14 9 1 1     1 Width 0ft   5985067.4201 2100372.3359 37.746358979048296 -122.49438729000201 (37.7463589790483, -122.494387290002)
41813 112844 2 13 2200 KEITH ST 1 1 1 1       3x3   6014766.0 2092880.0 37.7274798696224 -122.391168591224 (37.7274798696224, -122.391168591224)
42113 200095 2 13 2220 Keith St 4 1 1 1     2 Width 0ft   6014767.5792 2092826.7261 37.727333677806 -122.391159409685 (37.727333677806, -122.391159409685)
47763 186107 2 13 1901 Sunset Blvd 53 9 1 1     1 Width 0ft   5984859.3561 2101642.6122 37.7498346320289 -122.495200398918 (37.7498346320289, -122.495200398918)
49901 187069 2 13 2600 Sunset Blvd 5 9 1 1     1 Width 0ft   5985177.211 2096899.8078 37.7368307770453 -122.49375180463001 (37.7368307770453, -122.49375180463)
52707 200089 2 13 2260 Keith St 3 1 1 1     2 Width 0ft   6014698.5528 2092729.0135 37.7270615477685 -122.39139120786301 (37.7270615477685, -122.391391207863)
54294 187072 2 13 2600 Sunset Blvd 8 9 1 1     1 Width 0ft   5985184.617000001 2096917.4415 37.7368796277559 -122.493727498225 (37.7368796277559, -122.493727498225)
55490 139136 2 13 1825 POST ST 7 1 1 1     8 Width 0ft   6003489.3422 2114155.6067 37.785265388892 -122.431670371199 (37.785265388892, -122.431670371199)
59017 200092 2 13 2220 Keith St 1 1 1 1     2 Width 0ft   6014736.2036 2092780.1109 37.727203940586904 -122.391264618831 (37.7272039405869, -122.391264618831)
59641 182398 2 13 1539 23rd Ave 1 1 1 1     2 Width 0ft   5988985.656 2104841.7909999997 37.7588594394433 -122.481165865952 (37.7588594394433, -122.481165865952)
63369 73417 2 13 1501 44th Ave 1 1 1 1 1 05/14/1994 12:00:00 AM 5     5982464.5527 2104844.8944 37.7584866992539 -122.503718723326 (37.7584866992539, -122.503718723326)
66718 143220 2 13 55 BELLAIR PL 2 1 1 1     8 Width 0ft   6010031.3343 2121212.8177 37.8050114159252 -122.409535239424 (37.8050114159252, -122.409535239424)
68940 234843 2 13 141 Albion St 3 9 1 1     1 Width 2ft   6005925.31783 2106426.47013 37.764180822918796 -122.422693171361 (37.7641808229188, -122.422693171361)
69400 140757 2 13 2303 O'Farrell St 1 1 1 1     1 Width 0ft   6000331.3271 2112998.0313 37.7819074748635 -122.442512966292 (37.7819074748635, -122.442512966292)
69983 200088 2 13 2260 Keith St 2 1 1 1     2 Width 0ft   6014685.1061 2092710.1881 37.72700911067479 -122.39143637779101 (37.7270091106748, -122.391436377791)
71923 183061 2 13 2595 43rd Ave 2 1 1 1     1 Width 0ft   5983026.5279 2097492.8315 37.7383329997375 -122.50123139183 (37.7383329997375, -122.50123139183)
72838 234841 2 13 141 Albion St 1 9 1 1     1 Width 2ft   6005926.24374 2106419.53529 37.76416183372571 -122.42268947605 (37.7641618337257, -122.42268947605)
75956 183684 2 13 1323 41st Ave 1 1 1 1     1 Width 0ft   5983353.1911 2106127.4738 37.762060508953205 -122.50074030741501 (37.7620605089532, -122.500740307415)
77026 200233 2 13 2897 Hawes St 1 1 1 1     6 Width 0ft   6014759.7839 2089478.3596 37.718139294663 -122.390952437444 (37.718139294663, -122.390952437444)
78718 113143 2 13 1375 NORIEGA ST 1 1 1 1     2 3x3   5989767.0 2103093.0 37.7541031181361 -122.478335773286 (37.7541031181361, -122.478335773286)
80684 120653 2 13 4000x 25th St 2 1 1 1     10 3x3   6003791.0 2101344.0 37.750104917900295 -122.42971263777001 (37.7501049179003, -122.42971263777)
81290 112852 2 13 2200 KEITH ST 17 1 1 1       3x3   6014766.0 2092880.0 37.7274798696224 -122.391168591224 (37.7274798696224, -122.391168591224)
81726 112845 2 13 2200 KEITH ST 10 1 1 1       3x3   6014766.0 2092880.0 37.7274798696224 -122.391168591224 (37.7274798696224, -122.391168591224)
85183 122398 2 13 1 Marne Ave 1 5 1 1       3x3   5995245.0 2097844.0 37.7400071651049 -122.45901160777099 (37.7400071651049, -122.459011607771)
92645 120652 2 13 4000x 25th St 1 1 1 1     6 3x3   6003791.0 2101344.0 37.750104917900295 -122.42971263777001 (37.7501049179003, -122.42971263777)
98270 107984 6 13 2401x SCOTT ST 2 1 1 1       3x3   6001096.0 2116670.0 37.792033311180504 -122.440130949989 (37.7920333111805, -122.440130949989)
98582 122401 2 13 1 Marne Ave 4 5 1 1       3x3   5995245.0 2097844.0 37.7400071651049 -122.45901160777099 (37.7400071651049, -122.459011607771)
101452 112847 2 13 2200 KEITH ST 12 1 1 1       3x3   6014766.0 2092880.0 37.7274798696224 -122.391168591224 (37.7274798696224, -122.391168591224)
101472 106058 6 13 301 FILBERT ST 1 7 1 1     10     6011273.0 2120044.0 37.8018716248897 -122.40515593659401 (37.8018716248897, -122.405155936594)
102270 112846 2 13 2200 KEITH ST 11 1 1 1       3x3   6014766.0 2092880.0 37.7274798696224 -122.391168591224 (37.7274798696224, -122.391168591224)
103330 112848 2 13 2200 KEITH ST 13 1 1 1       3x3   6014766.0 2092880.0 37.7274798696224 -122.391168591224 (37.7274798696224, -122.391168591224)
103509 112850 2 13 2200 KEITH ST 15 1 1 1       3x3   6014766.0 2092880.0 37.7274798696224 -122.391168591224 (37.7274798696224, -122.391168591224)
104278 117387 2 13 1601 POLK ST 6 10 1 1           6006595.0 2116425.0 37.791672128860505 -122.42108692021401 (37.7916721288605, -122.421086920214)
104727 121218 2 13 441 Linden St 1 1 1 1       3x3   6005284.0 2110767.0 37.776062670273205 -122.425220189207 (37.7760626702732, -122.425220189207)
108949 117383 2 13 1601 POLK ST 2 10 1 1           6006595.0 2116425.0 37.791672128860505 -122.42108692021401 (37.7916721288605, -122.421086920214)
109602 116421 2 13 621 STOCKTON ST 1 7 1 1           6010507.0 2116333.0 37.7916392690679 -122.407544875665 (37.7916392690679, -122.407544875665)
113235 122400 2 13 1 Marne Ave 3 5 1 1       3x3   5995245.0 2097844.0 37.7400071651049 -122.45901160777099 (37.7400071651049, -122.459011607771)
113644 117385 2 13 1601 POLK ST 4 10 1 1           6006595.0 2116425.0 37.791672128860505 -122.42108692021401 (37.7916721288605, -122.421086920214)
116203 119609 2 13 228 17th Ave 1 1 1 1       3x3   5990599.0 2113870.0 37.7837421028695 -122.47624567750601 (37.7837421028695, -122.476245677506)
117100 117384 2 13 1601 POLK ST 3 10 1 1           6006595.0 2116425.0 37.791672128860505 -122.42108692021401 (37.7916721288605, -122.421086920214)
118970 122399 2 13 1 Marne Ave 2 5 1 1       3x3   5995245.0 2097844.0 37.7400071651049 -122.45901160777099 (37.7400071651049, -122.459011607771)
119725 117382 2 13 1601 POLK ST 1 10 1 1           6006595.0 2116425.0 37.791672128860505 -122.42108692021401 (37.7916721288605, -122.421086920214)
119907 109410 2 13 401 MOLIMO DR 1 1 1 1       3x3   5997363.9 2097040.1 37.737921427785395 -122.451627389441 (37.7379214277854, -122.451627389441)
120946 122898 5 13 198X San Jose Ave 1 1 1 1     6 3x3   6006160.0 2102149.0 37.752449123979794 -122.421577653162 (37.7524491239798, -122.421577653162)
121081 116711 2 13 1400 BAKER ST 3 1 1 1     0 3x3   6000422.0 2113928.0 37.7844660975886 -122.442266061376 (37.7844660975886, -122.442266061376)
121620 106908 2 13 250 EUCLID AVE 1 7 1 1     6     5998068.9 2114004.4 37.7845414798133 -122.45041245124901 (37.7845414798133, -122.450412451249)
121982 107985 6 13 2401x SCOTT ST 9 1 1 1       3x3   6001096.0 2116670.0 37.792033311180504 -122.440130949989 (37.7920333111805, -122.440130949989)
126600 117039 2 13 2220x SUTTER ST 7 1 1 1       3x3   6001781.0 2114465.0 37.786017922595605 -122.437602866759 (37.7860179225956, -122.437602866759)
128439 112851 2 13 2200 KEITH ST 16 1 1 1       3x3   6014766.0 2092880.0 37.7274798696224 -122.391168591224 (37.7274798696224, -122.391168591224)
135050 244933 2 13 276 Page St 2 10 1 1     14 Width 0ft   6005244.6732 2109942.1819 37.773795698453604 -122.425297523476 (37.7737956984536, -122.425297523476)
136316 244934 2 13 269 Lily St 1 1 1 1     6 Width 0ft   6005246.8004 2110075.5866 37.774162115578704 -122.42529966014901 (37.7741621155787, -122.425299660149)
137026 200094 2 13 2220 Keith St 3 1 1 1     2 Width 0ft   6014757.7183 2092808.7972 37.727283901408896 -122.391192246384 (37.7272839014089, -122.391192246384)
137863 138343 2 13 2250 Sutter St 7 1 1 1     1 Width 0ft   6001783.0488 2114314.9363 37.7856060025516 -122.437585027866 (37.7856060025516, -122.437585027866)
137997 139141 2 13 1730 GEARY BLVD 5 1 1 1     9 Width 0ft   6003375.8185 2113943.8659 37.7846775665641 -122.432048002548 (37.7846775665641, -122.432048002548)
139331 117386 2 13 1601 POLK ST 5 10 1 1           6006595.0 2116425.0 37.791672128860505 -122.42108692021401 (37.7916721288605, -122.421086920214)
142368 112849 2 13 2200 KEITH ST 14 1 1 1       3x3   6014766.0 2092880.0 37.7274798696224 -122.391168591224 (37.7274798696224, -122.391168591224)
143476 122686 4 13 3474 17th St 1 1 1 1     2 3x3   6005720.0 2106109.0 37.7632975389877 -122.423380737252 (37.7632975389877, -122.423380737252)
150237 183060 2 13 2595 43rd Ave 1 1 1 1     1 Width 0ft   5983027.0823 2097502.8119 37.738360435752604 -122.501230213026 (37.7383604357526, -122.501230213026)
150400 143092 2 13 487 Greenwich St 1 1 1 1     13 Width 0ft   6010505.1787 2120274.7202 37.80246217128 -122.40782924850299 (37.80246217128, -122.407829248503)
150525 143095 2 13 483 Greenwich St 2 2 1 1     12 Width 0ft   6010551.3522 2120281.1845 37.8024825054705 -122.407669920622 (37.8024825054705, -122.407669920622)
Powered by Datasette · Query took 2.578ms · Data source: data.sfgov.org