sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
123320 109532   116 818 Goettingen St 1 13 1 1           6010847.3 2090865.3 37.7217296747854 -122.404573864697 (37.7217296747854, -122.404573864697)
28419 108850 1 58 250x MONTCALM ST 1 13 1 1   02/09/2015 12:00:00 AM 3   Permit Number 774524 6009909.2 2099657.1 37.745817608401104 -122.40843648152 (37.7458176084011, -122.40843648152)
82422 113192 1 58 150X Museum Way 1 13 1 1   09/11/2015 12:00:00 AM     Permit Number 774288 6001029.7 2106463.5 37.7640050744287 -122.439628320832 (37.7640050744287, -122.439628320832)
84714 92484 1 17 155 Greenwich St 15 13 1 1   07/30/2009 12:00:00 AM   3x3 Permit Number 52856 6012015.0 2120477.0 37.803101990704896 -122.402618721555 (37.8031019907049, -122.402618721555)
85249 92475 1 17 155 Greenwich St 5 13 1 1   07/30/2009 12:00:00 AM   3x3 Permit Number 52856 6012015.0 2120477.0 37.803101990704896 -122.402618721555 (37.8031019907049, -122.402618721555)
85668 92476 1 17 155 Greenwich St 6 13 1 1   07/30/2009 12:00:00 AM   3x3 Permit Number 52856 6012015.0 2120477.0 37.803101990704896 -122.402618721555 (37.8031019907049, -122.402618721555)
88491 92474 1 17 155 Greenwich St 4 13 1 1   07/30/2009 12:00:00 AM   3x3 Permit Number 52856 6012015.0 2120477.0 37.803101990704896 -122.402618721555 (37.8031019907049, -122.402618721555)
88950 86946 1 3 495 Pacheco St 1 13 1 1   11/20/2007 12:00:00 AM   3x3 Permit Number 51051 5993544.7 2101797.8 37.750765410178 -122.465177603148 (37.750765410178, -122.465177603148)
91344 87564 1 17 155 Greenwich St 3 13 1 1   07/30/2009 12:00:00 AM   3x3 Permit Number 52856 6012015.0 2120477.0 37.803101990704896 -122.402618721555 (37.8031019907049, -122.402618721555)
96761 87388 1 175 201 Topeka Ave 2 13 1 1   04/24/2008 12:00:00 AM     Permit Number 50366 6012955.9 2095077.8 37.7334139596128 -122.39758023766399 (37.7334139596128, -122.397580237664)
99282 87387 1 175 201 Topeka Ave   13 1 1   04/24/2008 12:00:00 AM     Permit Number 50366 6012955.9 2095077.8 37.7334139596128 -122.39758023766399 (37.7334139596128, -122.397580237664)
104140 92480 1 17 155 Greenwich St 10 13 1 1   07/30/2009 12:00:00 AM   3x3 Permit Number 52856 6012015.0 2120477.0 37.803101990704896 -122.402618721555 (37.8031019907049, -122.402618721555)
110484 87389 1 175 201 Topeka Ave 3 13 1 1   04/24/2008 12:00:00 AM     Permit Number 50366 6012955.9 2095077.8 37.7334139596128 -122.39758023766399 (37.7334139596128, -122.397580237664)
113154 87562 1 17 155 Greenwich St 1 13 1 1   07/30/2009 12:00:00 AM   3x3 Permit Number 52856 6012015.0 2120477.0 37.803101990704896 -122.402618721555 (37.8031019907049, -122.402618721555)
114899 88028 1 17 495 Pacheco St 1 13 1 1   06/23/2008 12:00:00 AM     Permit Number 51051 5993544.7 2101797.8 37.750765410178 -122.465177603148 (37.750765410178, -122.465177603148)
128270 92481 1 17 155 Greenwich St 12 13 1 1   07/30/2009 12:00:00 AM   3x3 Permit Number 52856 6012015.0 2120477.0 37.803101990704896 -122.402618721555 (37.8031019907049, -122.402618721555)
140175 87563 1 17 155 Greenwich St 2 13 1 1   07/30/2009 12:00:00 AM   3x3 Permit Number 52856 6012015.0 2120477.0 37.803101990704896 -122.402618721555 (37.8031019907049, -122.402618721555)
145573 92485 1 17 155 Greenwich St 11 13 1 1   07/30/2009 12:00:00 AM   3x3 Permit Number 52856 6012015.0 2120477.0 37.803101990704896 -122.402618721555 (37.8031019907049, -122.402618721555)
427 251307 2 17 200 Cashmere St 1 13 1 1       3x3   6016315.0 2096328.0 37.7370332293639 -122.38605389871 (37.7370332293639, -122.38605389871)
433 251301 2 36 100 Whitney Young Cir 2 13 1 7       3x3   6016360.0 2096059.0 37.736297099957106 -122.385879567348 (37.7362970999571, -122.385879567348)
474 251300 2 36 100 Whitney Young Cir 1 13 1 8       3x3   6016360.0 2096059.0 37.736297099957106 -122.385879567348 (37.7362970999571, -122.385879567348)
780 251383 2 113 49x Milan Ter 1 13 1 1       3x3   5997587.0 2087495.0 37.711725600519706 -122.450168218052 (37.7117256005197, -122.450168218052)
883 251306 2 1 1 Cashmere St 5 13 1 1       3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
885 251305 2 1 1 Cashmere St 4 13 1 1       3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
887 251303 2 103 1 Cashmere St 2 13 1 8       3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
891 251304 2 1 1 Cashmere St 3 13 1 1 5     3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
896 251302 2 103 1 Cashmere St 1 13 1 8       3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
1305 251497 2 17 329x Warren Dr 1 13 1 1       3x3   5994610.0 2103362.0 37.7551216790189 -122.461607123764 (37.7551216790189, -122.461607123764)
1398 251517 2 47 145 Bonview St 1 13 1 1       3x3   6007188.0 2098162.0 37.7415596321362 -122.417740072125 (37.7415596321362, -122.417740072125)
1600 251625 2 47 76R Amber Dr 3 13 1 1           5999293.0 2100015.0 37.746200078593205 -122.44517138727 (37.7462000785932, -122.44517138727)
1605 251634 2 47 14R Amethyst Way 3 13 1 1           5999202.0 2100044.0 37.746274510978395 -122.445488137723 (37.7462745109784, -122.445488137723)
1613 251616 2 47 64R Amber Dr 3 13 1 1           5999367.0 2100045.0 37.746286674920704 -122.44491766156601 (37.7462866749207, -122.444917661566)
1618 251611 2 47 56R Amber Dr 4 13 1 1           5999423.0 2100048.0 37.7462981080439 -122.44472423658002 (37.7462981080439, -122.44472423658)
1619 251617 2 47 64R Amber Dr 4 13 1 1           5999367.0 2100045.0 37.746286674920704 -122.44491766156601 (37.7462866749207, -122.444917661566)
1624 251624 2 47 76R Amber Dr 2 13 1 1           5999293.0 2100015.0 37.746200078593205 -122.44517138727 (37.7462000785932, -122.44517138727)
1625 251623 2 47 76R Amber Dr 1 13 1 1           5999293.0 2100015.0 37.746200078593205 -122.44517138727 (37.7462000785932, -122.44517138727)
1626 251635 2 47 18R Amethyst Way 1 13 1 1           5999176.0 2100050.0 37.746289501198795 -122.445578473632 (37.7462895011988, -122.445578473632)
1638 251620 2 47 72R Amber Dr 3 13 1 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
1639 251615 2 47 64R Amber Dr 2 13 1 1           5999367.0 2100045.0 37.746286674920704 -122.44491766156601 (37.7462866749207, -122.444917661566)
1640 251622 2 47 72R Amber Dr 5 13 1 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
1641 251627 2 47 2R Amethyst Way 2 13 1 1           5999263.0 2100016.0 37.746201111936706 -122.44527519504999 (37.7462011119367, -122.44527519505)
1643 251614 2 47 64R Amber Dr 1 13 1 1           5999367.0 2100045.0 37.746286674920704 -122.44491766156601 (37.7462866749207, -122.444917661566)
1652 251618 2 47 72R Amber Dr 1 13 1 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
1772 173895 2 3 326x Dellbrook Ave 2 13 1 1     3 3x3   5997295.0 2102064.0 37.7517118802849 -122.452228008054 (37.7517118802849, -122.452228008054)
2457 253065 2 64 1x Drake St 1 13 1 1       3x3   6001423.0 2086924.0 37.710376533009295 -122.436869130393 (37.7103765330093, -122.436869130393)
2864 209183 2 17 140 Kensington Way 3 13 1 1   08/09/2017 12:00:00 AM 3 Width 3ft Permit Number 780524 5994862.40668 2098482.07156 37.741737150351 -122.460380669142 (37.741737150351, -122.460380669142)
2887 209188 2 17 156 Kensington Way 2 13 1 1   08/09/2017 12:00:00 AM 3 Width 3ft Permit Number 780524 5994823.818630001 2098534.27999 37.7418782818471 -122.46051787510599 (37.7418782818471, -122.460517875106)
10146 173882 2 3 201x Howth St 1 13 1 1           5997459.0 2090748.0 37.7206502603184 -122.450845024895 (37.7206502603184, -122.450845024895)
10196 173897 2 105 90x Knollview Way 1 13 1 1       3x3   5997593.0 2101480.0 37.7501254274205 -122.451155378281 (37.7501254274205, -122.451155378281)
10199 173896 2 3 326x Dellbrook Ave 1 13 1 1       3x3   5997295.0 2102064.0 37.7517118802849 -122.452228008054 (37.7517118802849, -122.452228008054)
10255 112606 2 47 100X Monument Way 1 13 1 1       10x10   5999003.0 2105766.0 37.761974353511896 -122.446587863076 (37.7619743535119, -122.446587863076)
22926 251147 2 47 113x Gladeview Way 1 13 1 1       3x3   5997915.0 2102038.0 37.7516759885035 -122.450082102397 (37.7516759885035, -122.450082102397)
23421 195972 2 86 200 Tulare St 18 13 1 1     10 Width 4ft   6015355.8319 2100319.8042599997 37.7479407691514 -122.389648918288 (37.7479407691514, -122.389648918288)
23859 223337 2 197 21 Poppy Ln 1 13 1 1     5 Width 2ft   6002002.72042 2096679.5859400001 37.737196106421706 -122.435562951888 (37.7371961064217, -122.435562951888)
24155 249927 2 47 358 Greenwich St 12 13 1 1     31 Width 0ft   6011132.35015 2120388.99651 37.8028110368738 -122.40566696715099 (37.8028110368738, -122.405666967151)
24822 250192 2 42 11 Alta St 2 13 1 1     9 Width 0ft   6011786.88966 2119947.0785 37.8016342173021 -122.403370805543 (37.8016342173021, -122.403370805543)
24893 249803 2 218 258 Chestnut St 2 13 1 1     5 Width 0ft   6010797.8681 2121034.56269 37.8045648929076 -122.406869977661 (37.8045648929076, -122.406869977661)
25385 228907 2 11 902 Duboce Ave 4 13 1 1     11 Width 7ft   6002320.43591 2108252.4902 37.7689905824786 -122.435292027503 (37.7689905824786, -122.435292027503)
25761 217537 2 224 89 Ralston St 1 13 1 1     18     5992163.635980001 2088434.33055 37.713992927605204 -122.468980989298 (37.7139929276052, -122.468980989298)
25938 249996 2 141 41 Darrell Pl 2 13 1 1     9 Width 0ft   6011497.53106 2120284.14207 37.8025435461134 -122.40439586268101 (37.8025435461134, -122.404395862681)
26205 195969 2 86 200 Tulare St 15 13 1 1     8     6015417.97335 2100326.09336 37.7479614832509 -122.389434473133 (37.7479614832509, -122.389434473133)
26526 228904 2 11 902 Duboce Ave 1 13 1 1     6     6002231.23378 2108246.83249 37.7689699817064 -122.435600166732 (37.7689699817064, -122.435600166732)
27063 233956 2 108 3 Penny Ln 3 13 1 1     1 Width 2ft   6002403.3233199995 2096434.7165299999 37.7365464964208 -122.434160386288 (37.7365464964208, -122.434160386288)
27098 249881 2 180 230 Greenwich St 17 13 1 1     16 Width 0ft   6011514.20842 2120460.74576 37.803029388647104 -122.404350588107 (37.8030293886471, -122.404350588107)
27119 209185 2 39 140 Kensington Way 5 13 1 1     7 Width 3ft   5994853.690119999 2098493.2474700003 37.741767335194105 -122.460411617495 (37.7417673351941, -122.460411617495)
27599 232417 2 1 173 Everson St 1 13 1 1     15     6002718.41885 2097663.27226 37.7399377058635 -122.433158722322 (37.7399377058635, -122.433158722322)
27647 223848 2 136 163 Corwin St 4 13 1 1     5 Width 3ft   6000598.61266 2104296.68505 37.758030988052 -122.44096386459299 (37.758030988052, -122.440963864593)
27650 239211 2 147 100 Hwy 101 Southbound 11 13 1 1     5     6005882.93751 2108938.64172 37.7710762568972 -122.42301832034501 (37.7710762568972, -122.423018320345)
27714 237848 2 16 21 Addison St 7 13 1 1     6 Width 8ft   6003593.08721 2096850.61715 37.7377559191042 -122.430076526206 (37.7377559191042, -122.430076526206)
27928 231945 2 22 33 Penny Ln 4 13 1 1     2 Width 2ft   6002666.1416 2096136.6991599998 37.7357431221521 -122.433230424364 (37.7357431221521, -122.433230424364)
28538 212784 2 15 739 Foerster St 1 13 1 1     17 Width 3ft   5998105.0801800005 2095806.61255 37.734576984727795 -122.448975948078 (37.7345769847278, -122.448975948078)
28833 249969 2 16 213 Filbert St 2 13 1 1     28 Width 0ft   6011730.79134 2120085.86253 37.802012151107704 -122.403574702535 (37.8020121511077, -122.403574702535)
29592 249968 2 175 213 Filbert St 3 13 1 1     11 Width 0ft   6011722.66122 2120088.35569 37.8020185425825 -122.403603012281 (37.8020185425825, -122.403603012281)
29662 223849 2 136 163 Corwin St 5 13 1 1     5 Width 3ft   6000601.16124 2104292.97169 37.7580209372281 -122.440954784152 (37.7580209372281, -122.440954784152)
29851 210532 2 1 47 Ralston St 5 13 1 1     3     5992170.38695 2088246.7586700001 37.7134782905637 -122.46894401367099 (37.7134782905637, -122.468944013671)
29920 240423 2 45 5 Penny Ln 5 13 1 1     2 Width 2ft   6002449.92079 2096381.9214299999 37.7364041778047 -122.433995506402 (37.7364041778047, -122.433995506402)
30020 218148 2 47 35 Ashton Ave 1 13 1 1     25     5994122.86099 2090034.3755400002 37.7184992748049 -122.462325196761 (37.7184992748049, -122.462325196761)
30330 233958 2 108 19 Penny Ln 1 13 1 1     4 Width 2ft   6002544.64531 2096274.1188599998 37.73611355200129 -122.433660302082 (37.7361135520013, -122.433660302082)
30471 188564 2 5 300 Vermont St 4 13 1 1     21     6011131.87643 2106822.77201 37.7655613532939 -122.404712987912 (37.7655613532939, -122.404712987912)
31147 207112 2 38 59 Ralston St 4 13 1 1     12     5992171.746719999 2088295.8735200001 37.7136132266511 -122.46894288591899 (37.7136132266511, -122.468942885919)
31427 223996 2 287 100 Hwy 101 Southbound 23 13 1 1     18     6005945.0032 2108837.4935 37.770802030213105 -122.42279644320699 (37.7708020302131, -122.422796443207)
31601 195958 2 86 200 Tulare St 4 13 1 1     10     6015649.240619999 2100340.8983400003 37.7480149542299 -122.388635787013 (37.7480149542299, -122.388635787013)
31969 239194 2 147 101 Hwy 101 Northbound 6 13 1 1     3     6005943.751730001 2109019.81978 37.7713025838749 -122.422813731768 (37.7713025838749, -122.422813731768)
32290 239198 2 147 101 Hwy 101 Northbound 10 13 1 1     3     6005918.91365 2109064.99496 37.771425222619705 -122.42290285910299 (37.7714252226197, -122.422902859103)
32977 219173 2 322 47 Ralston St 3 13 1 1     14     5992177.27741 2088252.3205900001 37.71349396036 -122.46892060252199 (37.71349396036, -122.468920602522)
33201 195967 2 86 200 Tulare St 13 13 1 1     5     6015456.783980001 2100328.64296 37.747970635647 -122.389300444473 (37.747970635647, -122.389300444473)
33236 195970 2 86 200 Tulare St 16 13 1 1     8     6015399.1088 2100325.42161 37.747958592828205 -122.389499659601 (37.7479585928282, -122.389499659601)
33977 249894 2 86 230 Greenwich St 30 13 1 1     24 Width 0ft   6011403.76038 2120447.63681 37.802987222140395 -122.40473187458599 (37.8029872221404, -122.404731874586)
34117 237115 2 18 100 Hwy 101 Southbound 6 13 1 1     6     6005846.05822 2108984.84199 37.7712010306339 -122.42314917169399 (37.7712010306339, -122.423149171694)
34603 249714 2 5 2975 Broadway 3 13 1 1     20     5999388.9274 2116973.5904200003 37.7927695576174 -122.446059261445 (37.7927695576174, -122.446059261445)
34830 239214 2 147 100 Hwy 101 Southbound 7 13 1 1     6     6005859.14445 2108978.35649 37.771183961488106 -122.423103444792 (37.7711839614881, -122.423103444792)
34978 249883 2 190 230 Greenwich St 19 13 1 1     14 Width 0ft   6011507.08304 2120427.1107900003 37.802936637067496 -122.40437287690901 (37.8029366370675, -122.404372876909)
35110 176590 2 288 4103 Alemany Blvd 1 13 1 1     23 Width 10ft   5991596.71486 2086796.0596 37.7094618598487 -122.470821200944 (37.7094618598487, -122.470821200944)
35242 249713 2 5 2975 Broadway 2 13 1 1     15     5999382.51554 2116973.87968 37.792769985700296 -122.446081467494 (37.7927699857003, -122.446081467494)
35303 249715 2 5 2975 Broadway 4 13 1 1     18     5999395.51836 2116974.38878 37.7927721260745 -122.44603651397 (37.7927721260745, -122.44603651397)
35375 239209 2 147 100 Hwy 101 Southbound 14 13 1 1     2     6005896.875990001 2108918.25042 37.7710210537973 -122.42296865708299 (37.7710210537973, -122.422968657083)
35387 240421 2 45 5 Penny Ln 3 13 1 1     2 Width 2ft   6002440.8921300005 2096392.57557 37.736432919229706 -122.43402748359101 (37.7364329192297, -122.434027483591)
36138 249778 2 26 119 Pfeiffer St 4 13 1 1     10 Width 0ft   6010409.80858 2121137.7854400002 37.804826595643 -122.408220184708 (37.804826595643, -122.408220184708)
36699 218742 2 37 32 Los Palmos Dr 6 13 1 1     3 Width 3ft   5998867.6092 2095887.4020200002 37.734842393562104 -122.44634545 (37.7348423935621, -122.44634545)
37767 211724 2 26 41 Ralston St 1 13 1 1     4     5992178.335940001 2088233.1934099998 37.71344150289679 -122.468915552827 (37.7134415028968, -122.468915552827)
37934 249882 2 16 230 Greenwich St 18 13 1 1     27 Width 0ft   6011509.072430001 2120419.3733099997 37.8029155030083 -122.40436544761499 (37.8029155030083, -122.404365447615)
Powered by Datasette · Query took 9.366ms · Data source: data.sfgov.org