sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
12440 100166 7 218 2340 Twin Peaks Blvd   7 1 1         Permit Number 769026          
21199 97237 7 41 125 Excelsior Ave   9 1 4 1 09/07/2011 12:00:00 AM     Permit Number 767513 6002911.0 2092621.3 37.7261045201699 -122.43213288829399 (37.7261045201699, -122.432132888294)
74398 97290 7 3 55 Hiliritas Ave   7 1 1         Permit Number 778896 6001461.7 2096833.2 37.7375871516219 -122.437444499981 (37.7375871516219, -122.437444499981)
76012 97025 7 88 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
78101 96597 7 458 325 Sanchez St   5 1 4 1         6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
78805 97021 7 180 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
79011 108637 7 3 15 TUCKER AVE   13 1 1           6011049.2 2088423.2 37.715035447895396 -122.403704200211 (37.7150354478954, -122.403704200211)
79404 97051 7 180 795 Wisconsin St   9 1 1 1 08/19/2011 12:00:00 AM     Permit Number 767554 6012787.8 2103832.3 37.7574425906128 -122.39877559017401 (37.7574425906128, -122.398775590174)
79535 96590 7 49 450 Church St   5 1 4 1         6004088.8 2106523.6 37.7643437320395 -122.42905208409401 (37.7643437320395, -122.429052084094)
80672 98502 7 17 244 Glenview Dr   13 2 1           5999066.0 2100737.0 37.7481695560511 -122.44600824337601 (37.7481695560511, -122.446008243376)
80849 97052 7 291 795 Wisconsin St   9 1 1 1 08/19/2011 12:00:00 AM     Permit Number 767554 6012787.8 2103832.3 37.7574425906128 -122.39877559017401 (37.7574425906128, -122.398775590174)
81073 101977 7 129 601 Grand View Ave   7 1 1           6000076.2 2101609.9 37.750623962991796 -122.44257767940901 (37.7506239629918, -122.442577679409)
81165 97014 7 353 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
81341 97022 7 195 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
81598 94690 7 329 749 Congo St   7 1 1   10/28/2010 12:00:00 AM     Permit Number 53820 6000274.0 2096023.0 37.735294937499 -122.441492809367 (37.735294937499, -122.441492809367)
81703 96593 7 49 450 Church St   5 1 4 1         6004088.8 2106523.6 37.7643437320395 -122.42905208409401 (37.7643437320395, -122.429052084094)
82720 98465 7 17 190 Portola Dr   13 2 1           5999550.3 2100620.3 37.7478767693988 -122.444325170302 (37.7478767693988, -122.444325170302)
82794 110929 7 3 445 BEACON ST   13 1 1       3x3   6002243.0 2098437.0 37.7420352018096 -122.434857838675 (37.7420352018096, -122.434857838675)
82893 97042 7 322 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
85013 97015 7 353 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
85657 96591 7 49 450 Church St   5 1 4 1         6004088.8 2106523.6 37.7643437320395 -122.42905208409401 (37.7643437320395, -122.429052084094)
86057 94469 7 136 4128 17th St   6 1 1         in landscaped area 6001502.0 2105859.0 37.7623721357484 -122.437951476108 (37.7623721357484, -122.437951476108)
87538 97027 7 1 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
88802 97029 7 232 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
89166 102275 7 17 267 Topaz Way   13 2 1           6001225.6 2097744.2 37.740075118911705 -122.438326054857 (37.7400751189117, -122.438326054857)
90103 100046 7 17 562 28th St   7 1 1   11/28/2012 12:00:00 AM 17   Permit Number 769057 6002262.0 2099459.0 37.7448424535299 -122.43486521318898 (37.7448424535299, -122.434865213189)
90230 98140 7 47 315 San Marcos Ave   7 1 1           5992920.8 2100212.1 37.746375486546704 -122.467219803339 (37.7463754865467, -122.467219803339)
90248 97040 7 14 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
91108 97177 7 17 257 Roosevelt Way   13 1 1         Monterey cypress tree in backyard on private property; not a Significant tree 6000848.1 2107127.9 37.765819014897296 -122.44030407045099 (37.7658190148973, -122.440304070451)
92954 97034 7 54 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
94734 98893 7 17 216 Glenview Dr   13 2 1           5998910.0 2100761.0 37.7482265448319 -122.44654941060699 (37.7482265448319, -122.446549410607)
94845 97016 7 353 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
97037 97024 7 52 1455 Alabama St   1 1 1   08/16/2011 12:00:00 AM     Permit Number 768189 6009349.0 2100759.5 37.748813167460106 -122.410451409671 (37.7488131674601, -122.410451409671)
97416 96594 7 49 450 Church St   5 1 4 1         6004088.8 2106523.6 37.7643437320395 -122.42905208409401 (37.7643437320395, -122.429052084094)
98291 98892 7 17 220 Glenview Dr   13 2 1           5998935.0 2100753.0 37.7482060067302 -122.44646238623999 (37.7482060067302, -122.44646238624)
98644 106968 7 54 351 26th Ave   13 1 1           5987720.26121 2113604.44601 37.7828456076198 -122.48618540122601 (37.7828456076198, -122.486185401226)
99802 98890 7 17 256 Glenview Dr   13 2 1           5999134.0 2100748.0 37.748203642185395 -122.44577389345 (37.7482036421854, -122.44577389345)
99914 97028 7 112 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
100855 114731 7 103 934 BRANNAN ST   13 1 1 9     10x10   6010724.0 2108745.0 37.7708165471861 -122.40625919407302 (37.7708165471861, -122.406259194073)
101483 113482 7 3 2839 Pierce St   13 1 1           6001345.0 2118077.0 37.7959107386074 -122.43937030854799 (37.7959107386074, -122.439370308548)
102208 110843 7 231 2037 TURK BLVD   7 1 1     15     6000252.0 2111948.0 37.779019836036206 -122.442711981138 (37.7790198360362, -122.442711981138)
102307 99256 7 116 1466 York St   13 1 1           6010099.0 2100741.0 37.7488043872035 -122.407856595429 (37.7488043872035, -122.407856595429)
103566 94487 7 136 4128 17th St   6 1 1         in landscaped area 6001502.0 2105859.0 37.7623721357484 -122.437951476108 (37.7623721357484, -122.437951476108)
103600 98436 7 17 238 Glenview Dr   13 1 1           5999035.0 2100736.0 37.7481650400364 -122.446115368035 (37.7481650400364, -122.446115368035)
104476 97043 7 322 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
104783 96999 7 20 195A Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
107232 98405 7 12 84 Richland Ave   1 1 1   02/08/2012 12:00:00 AM     Permit Number 768549 6005038.1 2096133.0 37.735867237922 -122.425029371072 (37.735867237922, -122.425029371072)
107492 98715 7 3 26 Vernon St   13 1 1           5992459.0 2088068.0 37.713004133171 -122.46793347935301 (37.713004133171, -122.467933479353)
107550 97032 7 477 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
107998 97023 7 52 1443 Alabama St   1 1 1   08/16/2011 12:00:00 AM     Permit Number 768190 6009347.4 2100788.9 37.748893803646105 -122.410459018192 (37.7488938036461, -122.410459018192)
108286 100045 7 181 556 28th St   7 1 1         Not sure which property tree is located on. 6002301.0 2099461.0 37.7448501592716 -122.434730501666 (37.7448501592716, -122.434730501666)
110024 96606 7 458 325 Sanchez St   5 1 4 1         6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
110212 110320 7 54 9 Imperial Aly   13 2 1           6005040.9 2119421.8 37.7998128500526 -122.426677597274 (37.7998128500526, -122.426677597274)
110904 109242 7 64 2479 DIAMOND ST   2 2 1           6002238.1 2097343.7 37.7390329760373 -122.434796615916 (37.7390329760373, -122.434796615916)
111128 96599 7 458 325 Sanchez St   5 1 4 1         6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
112387 109194 7 180 4705 03rd St   13 1 19     45     6015121.6 2095617.0 37.7350148477359 -122.39013039721901 (37.7350148477359, -122.390130397219)
112498 106458 7 17 71 HANCOCK ST   13 1 1           6003861.6 2105050.0 37.7602847161222 -122.429732794413 (37.7602847161222, -122.429732794413)
113186 96604 7 458 325 Sanchez St   5 1 4 1         6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
113756 96600 7 458 325 Sanchez St   5 1 4 1         6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
114652 97162 7 235 478 10th Ave   13 1 1         Tree in backyard on private property; not significant. 5992861.5 2112216.7 37.7793335349967 -122.468298031686 (37.7793335349967, -122.468298031686)
114948 113440 7 47 190 BEACON ST   13 1 1     32 3x3   6003193.0 2097540.0 37.739626138558705 -122.43150902083299 (37.7396261385587, -122.431509020833)
115312 100244 7 113 71 Sanchez St   13 1 1         Interior courtyard 6003507.0 2107903.0 37.7680982797144 -122.431162830878 (37.7680982797144, -122.431162830878)
115357 98501 7 17 232 Glenview Dr   13 2 1           5998998.0 2100740.0 37.748173910048706 -122.446243600021 (37.7481739100487, -122.446243600021)
116003 114410 7 3 10 GARDENSIDE DR   1 1 1           5999306.0 2102458.0 37.752908704913395 -122.445302055175 (37.7529087049134, -122.445302055175)
116314 96592 7 49 450 Church St   5 1 4 1         6004088.8 2106523.6 37.7643437320395 -122.42905208409401 (37.7643437320395, -122.429052084094)
118024 94228 7 175 1097 Church St   7 1 1   06/25/2010 12:00:00 AM     Permit Number 53567 6004455.0 2102510.0 37.753344058808395 -122.427499544702 (37.7533440588084, -122.427499544702)
119700 100472 7 3 70 Stanford Heights Ave   13 1 1           5997872.4 2096006.9 37.735113616296 -122.44979482672899 (37.735113616296, -122.449794826729)
119975 112668 7 3 129 Henry St   13 1 1           6002668.0 2107340.8 37.766507036069605 -122.434024647923 (37.7665070360696, -122.434024647923)
120804 96938 7 17 1306 Cole St   13 1 1         Backyard tree on private property 5998246.0 2105961.0 37.7624665052811 -122.449220068104 (37.7624665052811, -122.449220068104)
121581 96589 7 49 450 Church St   5 1 4 1         6004088.8 2106523.6 37.7643437320395 -122.42905208409401 (37.7643437320395, -122.429052084094)
122333 97685 7 47 84 Coventry Ct   13 1 1           5997084.0 2096485.0 37.7363812239889 -122.452555087132 (37.7363812239889, -122.452555087132)
123910 96598 7 458 325 Sanchez St   5 3 4 1         6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
124250 99374 7 3 21 Panorama Dr   13 1 1     24     5998009.0 2100230.0 37.7467170430405 -122.449626769288 (37.7467170430405, -122.449626769288)
125346 100148 7 17 209 Vicksburg St   13 1 1           6004141.0 2102142.0 37.7523158521071 -122.428559192815 (37.7523158521071, -122.428559192815)
125485 97041 7 14 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
125835 97004 7 20 195A Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
126465 101951 7 17 21 Lyell St   19 1 1           6003106.0 2094969.0 37.7325618289587 -122.43162632292 (37.7325618289587, -122.43162632292)
126549 94468 7 136 4128 17th St   6 1 1         in landscaped area 6001502.0 2105859.0 37.7623721357484 -122.437951476108 (37.7623721357484, -122.437951476108)
126860 96602 7 458 325 Sanchez St   5 1 4 1         6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
127434 97236 7 458 125 Excelsior Ave   9 1 4 1 09/07/2011 12:00:00 AM     Permit Number 767513 6002911.0 2092621.3 37.7261045201699 -122.43213288829399 (37.7261045201699, -122.432132888294)
127473 97045 7 207 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
128034 96601 7 458 325 Sanchez St   5 1 4 1         6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
128066 98503 7 47 208 Glenview Dr   13 1 1           5998871.0 2100779.0 37.74827374071911 -122.44668556582701 (37.7482737407191, -122.446685565827)
128311 98265 7 143 755 O'Farrell St   13 1 1         Backyard tree; not significant 6007700.0 2113968.3 37.784988860902295 -122.417089467607 (37.7849888609023, -122.417089467607)
128784 97039 7 14 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
129310 99268 7 17 292 Whitney St   8 1 1           6004280.0 2096681.0 37.7373290690714 -122.42768945491501 (37.7373290690714, -122.427689454915)
129485 97033 7 70 61 Vicksburg St   13 1 1         Possible significant tree; Nellie RoW; rear yard 6004120.0 2102703.0 37.753855038047 -122.428671801406 (37.753855038047, -122.428671801406)
140389 97037 7 477 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
140586 97044 7 322 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
140629 97038 7 14 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
141038 102381 7 3 258 Molimo Dr   13 1 1           5997615.0 2096604.0 37.7367383790998 -122.450727783905 (37.7367383790998, -122.450727783905)
141787 103673 7 54 64 Henry St   13 1 1           6003097.0 2107420.0 37.7667488371496 -122.432546472662 (37.7667488371496, -122.432546472662)
142264 96605 7 458 325 Sanchez St   5 1 4 1         6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
142266 98139 7 124 556 Laidley St   13 1 1       3x3   6003085.0 2096041.0 37.7355041065287 -122.431775438062 (37.7355041065287, -122.431775438062)
142369 97035 7 309 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
142682 102752 7 116 2452 Green St   13 1 1           6001313.0 2117994.0 37.7956810212331 -122.43947508164 (37.7956810212331, -122.43947508164)
144514 96603 7 458 325 Sanchez St   5 1 4 1         6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
145213 97026 7 208 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
145522 97036 7 477 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
145716 98878 7 17 11 Panorama Dr   13 2 1           5998029.0 2100213.0 37.7466715093679 -122.449556386849 (37.7466715093679, -122.449556386849)
631 251294 7 54 7126 Geary Blvd 1 16 1 1       3x3   5984860.0 2112552.0 37.779788778901796 -122.49600289252199 (37.7797887789018, -122.496002892522)
Powered by Datasette · Query took 4.713ms · Data source: data.sfgov.org