sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
23186 17762 3 36 1700 Pine St 2 1 1 2     23     6005688.226009999 2115553.43335 37.7892278664309 -122.424162343438 (37.7892278664309, -122.424162343438)
25340 199360 2 36 1451 Rhode Island St 2 2 1 1     19     6012046.6036 2101626.2388 37.7513439035983 -122.401183943899 (37.7513439035983, -122.401183943899)
25829 218789 2 36 380 Monterey Blvd 1 9 1 1     30     5999445.613919999 2094740.51345 37.7317263020196 -122.44426470386101 (37.7317263020196, -122.444264703861)
27571 224007 2 36 1000 San Jose Ave 28 7 1 1     16     6005150.44635 2097206.47879 37.7388211148085 -122.42471728718 (37.7388211148085, -122.42471728718)
28308 67884 1 36 5X Lisbon St 1 1 1 1   03/03/1993 12:00:00 AM 15   Permit Number 31577 6003921.69231 2093425.09481 37.72836881267121 -122.428696258429 (37.7283688126712, -122.428696258429)
28860 51570 1 36 227 24th Ave 1 1 1 1 1 02/04/2005 12:00:00 AM 17   Permit Number 47867 5988337.51894 2114460.53389 37.7852321378524 -122.48411277430401 (37.7852321378524, -122.484112774304)
29174 224014 2 36 1000 San Jose Ave 87 7 1 1     16     6005008.4122 2096950.18798 37.7381093751439 -122.425190143511 (37.7381093751439, -122.425190143511)
29793 247852 2 36 80 Bradford St 1 17 1 1     27     6009577.25002 2098193.0016099997 37.741778919360705 -122.409481010838 (37.7417789193607, -122.409481010838)
30472 247853 2 36 80 Bradford St 2 17 1 1     25     6009574.28658 2098178.5899099996 37.7417391819242 -122.40949024059401 (37.7417391819242, -122.409490240594)
31630 199351 2 36 875 Vermont St 8 2 1 1     19     6011310.4458099995 2104289.7069599996 37.7586161031593 -122.403917085224 (37.7586161031593, -122.403917085224)
38019 224020 2 36 1300 San Jose Ave 19 7 1 1     12     6003561.5892199995 2095667.7300200001 37.7345061963941 -122.430101069605 (37.7345061963941, -122.430101069605)
39216 224006 2 36 1000 San Jose Ave 27 7 1 1     18     6005147.55847 2097214.3851400004 37.738842660756795 -122.42472783442601 (37.7388426607568, -122.424727834426)
39572 247122 2 36 2301 Castro St 4 9 1 1     16     6002767.913930001 2098805.6060200003 37.743077097036796 -122.433069184902 (37.7430770970368, -122.433069184902)
40659 62578 1 36 739 Vermont St 1 1 1 1 1 03/01/1986 12:00:00 AM 9   Permit Number 22783 6011302.7424099995 2104925.74778 37.7603620991639 -122.403988486898 (37.7603620991639, -122.403988486898)
41851 224024 2 36 1300 San Jose Ave 31 7 1 1     11     6003500.27869 2095632.3533400001 37.7344055874315 -122.43031051723801 (37.7344055874315, -122.430310517238)
47085 218783 2 36 230 Edna St 3 17 1 1     9     5998795.47023 2095343.3571900001 37.7333444548841 -122.44655572948099 (37.7333444548841, -122.446555729481)
49495 224027 2 36 1350 Noe St 1 9 1 1     24     6003197.19524 2100390.33495 37.7474527349542 -122.431697967013 (37.7474527349542, -122.431697967013)
50076 58511 1 36 1430 Waller St 1 1 1 1   03/30/1979 12:00:00 AM     Permit Number 17687 5998871.25967783 2108358.36156462 37.7690847998305 -122.447230081169 (37.7690847998305, -122.447230081169)
52044 199349 2 36 1501 25th St 26 2 1 1     13     6014246.130480001 2101970.67081 37.752412103042104 -122.39360177230199 (37.7524121030421, -122.393601772302)
52746 224009 2 36 1000 San Jose Ave 30 7 1 1     23     6005155.305240001 2097189.65421 37.738775192731296 -122.42469929085199 (37.7387751927313, -122.424699290852)
55714 107425 2 36 1600X Waller St 1 1 1 1           5997832.17799 2108247.26578 37.7687203321672 -122.450816174345 (37.7687203321672, -122.450816174345)
56034 247100 2 36 2301 Castro St 18 7 1 1     24     6002747.30855 2098672.19693 37.7427096178655 -122.433130902689 (37.7427096178655, -122.433130902689)
56985 224016 2 36 1000 San Jose Ave 90 7 1 1     25     6005001.85234 2096930.1779200002 37.7380540614461 -122.425211400785 (37.7380540614461, -122.425211400785)
57543 224011 2 36 1000 San Jose Ave 84 7 1 1     32     6005029.023080001 2096988.2407799999 37.738215023894 -122.42512158818701 (37.738215023894, -122.425121588187)
57547 38224 1 36 1099 Mississippi St 1 1 1 1 1 10/05/2002 12:00:00 AM 14   Permit Number 40351 6014264.59569 2102044.43409 37.7526156672934 -122.39354307806101 (37.7526156672934, -122.393543078061)
58504 247099 2 36 2301 Castro St 17 7 1 1     22     6002747.27026 2098651.7988 37.742653607170894 -122.433129577966 (37.7426536071709, -122.433129577966)
59093 199361 2 36 1433 Rhode Island St 2 2 1 1     17     6012042.82381 2101683.55055 37.7515010583383 -122.40120104178999 (37.7515010583383, -122.40120104179)
60423 224005 2 36 900 San Bruno Ave 1 2 1 1     15     6011012.17375 2104008.2643 37.7578266557966 -122.40492883511999 (37.7578266557966, -122.40492883512)
62464 62579 1 36 741 Vermont St 1 1 1 1 1 03/01/1986 12:00:00 AM 10   Permit Number 22784 6011303.77085 2104898.93824 37.7602885436105 -122.40398304329399 (37.7602885436105, -122.403983043294)
70104 247076 2 36 2401 Castro St 12 7 1 1     18     6002768.97997 2098508.28835 37.742260792292704 -122.43304426108 (37.7422607922927, -122.43304426108)
70451 176394 2 36 148 Milton St 1 17 1 1     21     6003833.54644 2094691.18415 37.731840220943205 -122.42909121820801 (37.7318402209432, -122.429091218208)
74211 247098 2 36 2301 Castro St 16 7 1 1     27     6002743.01525 2098640.44771 37.7426221983472 -122.433143479687 (37.7426221983472, -122.433143479687)
78284 36808 1 36 1290 Egbert Ave 1 1 1 1 1 05/26/1998 12:00:00 AM     Permit Number 39532 6014916.278192299 2090716.3266444001 37.721547191141205 -122.39049795372 (37.7215471911412, -122.39049795372)
78413 51528 1 36 2900 Hawes St 2 1 1 1   01/14/2005 12:00:00 AM     Permit Number 47830 6014679.41969777 2089453.24857655 37.7180658851091 -122.39122846992599 (37.7180658851091, -122.391228469926)
78803 105667 2 36 301X DORADO TER 1 19 1 1           5994306.4 2092922.0 37.726438562961896 -122.461900058607 (37.7264385629619, -122.461900058607)
81696 51527 1 36 2900 Hawes St 1 1 1 1   01/14/2005 12:00:00 AM     Permit Number 47830 6014679.41969777 2089453.24857655 37.7180658851091 -122.39122846992599 (37.7180658851091, -122.391228469926)
82185 111319 2 36 200x PENINSULA AVE 2 14 1 1           6012569.0 2087626.0 37.71293127807179 -122.398395185538 (37.7129312780718, -122.398395185538)
83073 109202 2 36 2401x CASTRO ST 6 3 1 2           6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
83231 36833 1 36 2715 Ingalls St 1 1 1 1 1 05/26/1998 12:00:00 AM     Permit Number 39537 6015005.69395491 2090908.83002417 37.7220807273762 -122.390202307194 (37.7220807273762, -122.390202307194)
83393 92053 6 36 1001 Potrero Ave   5 1 1         Permit Number 52180 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674)
84093 247077 2 36 2401 Castro St 13 7 1 1     16     6002764.89351 2098516.6039400003 37.7422833931736 -122.433058984778 (37.7422833931736, -122.433058984778)
84347 106497 1 36 1890 Page St 2 1 1 1         Permit Number 772114 5997541.6 2108881.8 37.770445962098705 -122.451867038975 (37.7704459620987, -122.451867038975)
85276 105668 2 36 301X DORADO TER 2 19 1 1     12     5994306.4 2092922.0 37.726438562961896 -122.461900058607 (37.7264385629619, -122.461900058607)
85810 109204 2 36 2401x CASTRO ST 8 3 1 2           6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
86474 109199 2 36 2401x CASTRO ST 7 3 1 2           6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
87976 111318 2 36 200x PENINSULA AVE 1 14 1 1           6012569.0 2087626.0 37.71293127807179 -122.398395185538 (37.7129312780718, -122.398395185538)
89868 36789 1 36 1314 Donner Ave 2 1 1 1 1 05/26/1998 12:00:00 AM     Permit Number 39526 6015468.42166203 2090653.62366449 37.7214056358126 -122.388584951991 (37.7214056358126, -122.388584951991)
94007 112375 6 36 801 ULLOA ST 1 1 1 6     42     5993401.0 2098089.0 37.7405736985828 -122.46540514019699 (37.7405736985828, -122.465405140197)
95397 105511 1 36 400X Steiner St 1 1 1 1         Permit Number 772834 6003196.1616 2109801.36502 37.7732931051579 -122.432373588443 (37.7732931051579, -122.432373588443)
95666 36809 1 36 1290 Egbert Ave 2 1 1 1 1 05/26/1998 12:00:00 AM     Permit Number 39532 6014916.278192299 2090716.3266444001 37.721547191141205 -122.39049795372 (37.7215471911412, -122.39049795372)
96253 41569 1 36 63 Ruth St 1 1 1 1   05/05/2000 12:00:00 AM     Permit Number 42084 6001453.1346338 2091658.26221962 37.723377473003104 -122.437103713844 (37.7233774730031, -122.437103713844)
96793 224018 2 36 1300 San Jose Ave 10 7 1 1     27     6003591.19163 2095672.05268 37.734519741983 -122.42999903253299 (37.734519741983, -122.429999032533)
97104 50378 1 36 1620 Montgomery St 2 1 1 1   10/01/2003 12:00:00 AM     Permit Number 47039 6011351.83248495 2120835.88186523 37.804050345434 -122.404938924734 (37.804050345434, -122.404938924734)
100565 176384 2 36 199 Peninsula Ave 2 7 1 1     10     6012519.05604 2087598.31836 37.712852487431796 -122.398565868123 (37.7128524874318, -122.398565868123)
100592 116998 6 36 880x MCALLISTER ST 1 8 1 1           6005306.0 2112177.0 37.779935428414 -122.42524444144199 (37.779935428414, -122.425244441442)
102078 117000 6 36 880x MCALLISTER ST 3 8 1 1           6005306.0 2112177.0 37.779935428414 -122.42524444144199 (37.779935428414, -122.425244441442)
102914 112377 7 36 801 ULLOA ST 3 1 1 6     36     5993401.0 2098089.0 37.7405736985828 -122.46540514019699 (37.7405736985828, -122.465405140197)
104633 99112 2 36 80X Bradford St 1 14 1 1           6009564.7 2098208.3 37.741820222197596 -122.40952548431801 (37.7418202221976, -122.409525484318)
105675 109208 2 36 2401x CASTRO ST 1 3 1 2           6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
106969 99110 2 36 94 Bernal Heights Blvd 1 14 1 1           6009548.4 2098143.7 37.741641931317396 -122.409577286243 (37.7416419313174, -122.409577286243)
107199 112376 6 36 801 ULLOA ST 2 1 1 6     24     5993401.0 2098089.0 37.7405736985828 -122.46540514019699 (37.7405736985828, -122.465405140197)
110332 109200 2 36 2401x CASTRO ST 7 14 1 2           6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
116970 34459 1 36 1960 Jones St 1 1 1 1 1 12/21/2015 12:00:00 AM     Permit Number 42077 6008233.26269903 2119182.7725058 37.7993365057546 -122.415613869084 (37.7993365057546, -122.415613869084)
117616 36790 1 36 1314 Donner Ave 1 1 1 1 1 05/26/1998 12:00:00 AM     Permit Number 39526 6015468.42166203 2090653.62366449 37.7214056358126 -122.388584951991 (37.7214056358126, -122.388584951991)
118269 109197 2 36 2401x CASTRO ST 3 3 1 2     12     6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
118995 97217 3 36 300X Claremont Blvd 4 16 1 10     18     5993486.0 2098110.3 37.7406370848463 -122.465112792055 (37.7406370848463, -122.465112792055)
122748 111320 2 36 200x PENINSULA AVE 3 14 1 1           6012569.0 2087626.0 37.71293127807179 -122.398395185538 (37.7129312780718, -122.398395185538)
123251 92054 6 36 1001 Potrero Ave   5 1 1         Permit Number 52180 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674)
123260 109205 2 36 2401x CASTRO ST 9 3 1 2           6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
123401 109201 2 36 2401x CASTRO ST 4 3 1 2           6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
123678 97297 1 36 450 06th Ave 1 1 1 1           5994062.8 2112448.2 37.7800384821655 -122.46415907596202 (37.7800384821655, -122.464159075962)
124001 99698 6 36 1750 Divisadero St 1 8 1 1           6001124.0 2114376.0 37.7857361748448 -122.439869519979 (37.7857361748448, -122.439869519979)
124008 106918 2 36 274 PUTNAM ST 1 1 1 1           6009044.8 2096077.1 37.7359392652864 -122.41117262558201 (37.7359392652864, -122.411172625582)
124370 116999 6 36 880x MCALLISTER ST 2 8 1 1           6005306.0 2112177.0 37.779935428414 -122.42524444144199 (37.779935428414, -122.425244441442)
125797 109198 2 36 2401x CASTRO ST 2 3 1 2           6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
128009 109203 2 36 2401x CASTRO ST 9 3 1 2           6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
128144 50377 1 36 1620 Montgomery St 1 1 1 1   10/01/2003 12:00:00 AM     Permit Number 47039 6011351.83248495 2120835.88186523 37.804050345434 -122.404938924734 (37.804050345434, -122.404938924734)
128360 106364 6 36 155 BORICA ST 1 7 1 1           5992696.0 2092292.5 37.724617268406604 -122.467421338179 (37.7246172684066, -122.467421338179)
131355 247086 2 36 2301 Castro St 4 7 1 1     21     6002759.04691 2098591.69247 37.7424892371899 -122.43308456422501 (37.7424892371899, -122.433084564225)
133301 218784 2 36 230 Edna St 4 17 1 1     6     5998790.64503 2095351.5410200001 37.733366650131295 -122.446573000066 (37.7333666501313, -122.446573000066)
133793 206299 2 36 231 Edna St 1 17 1 1     21     5998763.35609 2095379.2875599999 37.733441276780205 -122.446669340837 (37.7334412767802, -122.446669340837)
134377 224017 2 36 1000 San Jose Ave 91 7 1 1     28     6004994.74234 2096924.0742900001 37.7380369005842 -122.425235549407 (37.7380369005842, -122.425235549407)
134530 218787 2 36 230 Edna St 7 17 1 1     14     5998781.19291 2095377.439 37.733437219949 -122.44660754120702 (37.733437219949, -122.446607541207)
140716 99699 6 36 1750 Divisadero St 2 8 1 1           6001124.0 2114376.0 37.7857361748448 -122.439869519979 (37.7857361748448, -122.439869519979)
143072 97216 3 36 300X Claremont Blvd 3 16 1 10           5993486.0 2098110.3 37.7406370848463 -122.465112792055 (37.7406370848463, -122.465112792055)
146060 106499 1 36 420X Shrader St 2 1 1 1           5997462.73555 2109001.92463 37.770771276139705 -122.452148498658 (37.7707712761397, -122.452148498658)
146328 36834 1 36 2715 Ingalls St 2 1 1 1 1 05/26/1998 12:00:00 AM     Permit Number 39537 6015005.69395491 2090908.83002417 37.7220807273762 -122.390202307194 (37.7220807273762, -122.390202307194)
148918 62209 1 36 227 24th Ave 1 1 1 1 1 10/12/1985 12:00:00 AM 16   Permit Number 22331 5988338.57879 2114482.10714 37.7852914335725 -122.48411069019699 (37.7852914335725, -122.484110690197)
152132 218786 2 36 230 Edna St 6 17 1 1     11     5998782.33461 2095362.2846400002 37.733395674875005 -122.44660250410101 (37.733395674875, -122.446602504101)
152279 224022 2 36 1300 San Jose Ave 21 7 1 1     25     6003540.82213 2095652.97051 37.7344644939234 -122.43017181569999 (37.7344644939234, -122.4301718157)
152285 199383 3 36 400x Cargo Way 6 3 1 2     10     6017000.482369999 2098965.68052 37.7443136810333 -122.38386746011801 (37.7443136810333, -122.383867460118)
153494 199348 2 36 1501 25th St 23 2 1 1     5     6014219.92848 2101970.08813 37.7524090471553 -122.393692343051 (37.7524090471553, -122.393692343051)
153777 224008 2 36 1000 San Jose Ave 29 7 1 1     17     6005152.83634 2097199.08838 37.7388009573938 -122.42470849810499 (37.7388009573938, -122.424708498105)
158262 176380 2 36 229 Hester Ave 1 7 1 1     38     6012521.81555 2087619.26728 37.7129101627473 -122.398557799413 (37.7129101627473, -122.398557799413)
162867 224012 2 36 1000 San Jose Ave 85 7 1 1     26     6005023.67021 2096975.18783 37.738178881048704 -122.425139167258 (37.7381788810487, -122.425139167258)
165042 218785 2 36 230 Edna St 5 17 1 1     8     5998782.76063 2095352.74135 37.733369495591795 -122.446600344857 (37.7333694955918, -122.446600344857)
168669 247078 2 36 2401 Castro St 14 7 1 1     25     6002758.90176 2098529.69857 37.7423190081102 -122.433080637766 (37.7423190081102, -122.433080637766)
169441 224010 2 36 1000 San Jose Ave 31 7 1 1     18     6005156.6976 2097181.32171 37.738752392204205 -122.424693884126 (37.7387523922042, -122.424693884126)
169526 247073 2 36 2401 Castro St 9 7 1 1     24     6002776.09275 2098476.71227 37.742174495166395 -122.433017411837 (37.7421744951664, -122.433017411837)
169973 61914 1 36 801 Cesar Chavez St 1 1 1 1   03/27/1985 12:00:00 AM 12   Permit Number 21965 6016347.85341 2101137.90293 37.75024205603879 -122.386275546874 (37.7502420560388, -122.386275546874)
170634 38226 1 36 1099 Mississippi St 3 1 1 1   07/21/1998 12:00:00 AM 11   Permit Number 40351 6014262.677019999 2102083.6302 37.752723184838295 -122.393552456191 (37.7527231848383, -122.393552456191)
Powered by Datasette · Query took 8.489ms · Data source: data.sfgov.org