sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
97160 115639 7 3 81x ELSIE ST 5 16 1 2     6 3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
99755 115644 7 3 81x ELSIE ST 10 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
102527 115648 7 3 81x ELSIE ST 14 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
102675 115649 7 3 81x ELSIE ST 15 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
108009 115652 7 3 81x ELSIE ST 18 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
111875 115636 7 3 81x ELSIE ST 2 16 1 2     16 3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
113407 115650 7 3 81x ELSIE ST 16 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
118558 115640 7 3 81x ELSIE ST 6 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
122253 115643 7 3 81x ELSIE ST 9 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
124724 115642 7 3 81x ELSIE ST 8 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
125004 115653 7 3 81x ELSIE ST 19 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
127152 115647 7 3 81x ELSIE ST 13 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
139401 115654 7 3 81x ELSIE ST 20 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
139921 115637 7 3 81x ELSIE ST 3 16 1 2     14 3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
142076 115655 7 3 81x ELSIE ST 21 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
144101 115651 7 3 81x ELSIE ST 17 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
87654 99961 7 28 537 Valley St 1 7 1 1   07/25/2012 12:00:00 AM     Permit Number 768880 6002459.0 2099152.0 37.7440106863694 -122.434162082356 (37.7440106863694, -122.434162082356)
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)
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)
102061 109092 7 18 237 28th St 1 1 1 1 1 01/27/2015 12:00:00 AM 3 3x3 Permit Number 773766 6004335.1 2099509.2 37.7450977767532 -122.427700396282 (37.7450977767532, -122.427700396282)
22826 251117 7 212 2024 Castro St 1 13 1 1           6002622.0 2099601.0 37.7452527853239 -122.43363054854099 (37.7452527853239, -122.433630548541)
122755 102079 7 12 76 Manchester St 1 1 1 1 1 12/18/2012 12:00:00 AM   3x3 Permit Number 769729 6008162.3 2099676.4 37.7457726186307 -122.414478397936 (37.7457726186307, -122.414478397936)
90230 98140 7 47 315 San Marcos Ave   7 1 1           5992920.8 2100212.1 37.746375486546704 -122.467219803339 (37.7463754865467, -122.467219803339)
92228 122453 7 3 217 San Marcos Ave 1 13 1 1       10x10   5993325.07095 2100296.14299 37.7466295758311 -122.465827998209 (37.7466295758311, -122.465827998209)
145716 98878 7 17 11 Panorama Dr   13 2 1           5998029.0 2100213.0 37.7466715093679 -122.449556386849 (37.7466715093679, -122.449556386849)
124250 99374 7 3 21 Panorama Dr   13 1 1     24     5998009.0 2100230.0 37.7467170430405 -122.449626769288 (37.7467170430405, -122.449626769288)
82720 98465 7 17 190 Portola Dr   13 2 1           5999550.3 2100620.3 37.7478767693988 -122.444325170302 (37.7478767693988, -122.444325170302)
103600 98436 7 17 238 Glenview Dr   13 1 1           5999035.0 2100736.0 37.7481650400364 -122.446115368035 (37.7481650400364, -122.446115368035)
80672 98502 7 17 244 Glenview Dr   13 2 1           5999066.0 2100737.0 37.7481695560511 -122.44600824337601 (37.7481695560511, -122.446008243376)
115357 98501 7 17 232 Glenview Dr   13 2 1           5998998.0 2100740.0 37.748173910048706 -122.446243600021 (37.7481739100487, -122.446243600021)
1273 251481 7 3 32 Peralta Ave 1 13 1 2       3x3   6010779.0 2100499.0 37.7481779538542 -122.40548810426901 (37.7481779538542, -122.405488104269)
99802 98890 7 17 256 Glenview Dr   13 2 1           5999134.0 2100748.0 37.748203642185395 -122.44577389345 (37.7482036421854, -122.44577389345)
98291 98892 7 17 220 Glenview Dr   13 2 1           5998935.0 2100753.0 37.7482060067302 -122.44646238623999 (37.7482060067302, -122.44646238624)
94734 98893 7 17 216 Glenview Dr   13 2 1           5998910.0 2100761.0 37.7482265448319 -122.44654941060699 (37.7482265448319, -122.446549410607)
128066 98503 7 47 208 Glenview Dr   13 1 1           5998871.0 2100779.0 37.74827374071911 -122.44668556582701 (37.7482737407191, -122.446685565827)
99953 117254 7 3 2067 33RD AVE 1 13 1 1       3x3   5985987.0 2101171.0 37.7486056682842 -122.49126630479601 (37.7486056682842, -122.491266304796)
102307 99256 7 116 1466 York St   13 1 1           6010099.0 2100741.0 37.7488043872035 -122.407856595429 (37.7488043872035, -122.407856595429)
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)
99642 113379 7 250 140 CASTENADA AVE 1 7 1 1     50     5994437.0 2101097.0 37.7488926059174 -122.462041158848 (37.7488926059174, -122.462041158848)
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)
92371 118371 7 116 4808 25th St 1 1 1 1       3x3   5999981.0 2101110.0 37.7492459313263 -122.44287099416799 (37.7492459313263, -122.442870994168)
88993 121199 7 47 72 Fountain St 1 13 1 1           6000322.0 2101283.0 37.7497403826665 -122.441704227556 (37.7497403826665, -122.441704227556)
3132 253339 7 47 2019X 24th Ave 1 9 1 13       3x3   5988853.0 2101569.0 37.7498655183494 -122.481384971136 (37.7498655183494, -122.481384971136)
81073 101977 7 129 601 Grand View Ave   7 1 1           6000076.2 2101609.9 37.750623962991796 -122.44257767940901 (37.7506239629918, -122.442577679409)
901 224716 7 32 3255x 24th St 5 8 1 6     13 Width 3ft   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
903 225889 7 121 3255x 24th St 7 16 1 6     18 Width 8ft   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
905 224715 7 32 3255x 24th St 4 8 1 6     12 Width 3ft   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
909 234895 7 86 3255x 24th St 6 18 1 1     40 Width 10ft   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
914 225888 7 121 3255x 24th St 1 8 1 6     32 6x6   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
916 224714 7 32 3255x 24th St 3 8 1 6     11 Width 3ft   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
928 224422 7 32 3255x 24th St 2 8 1 6     16 Width 3ft   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
125346 100148 7 17 209 Vicksburg St   13 1 1           6004141.0 2102142.0 37.7523158521071 -122.428559192815 (37.7523158521071, -122.428559192815)
13296 187658 7 39 600X Clarendon Ave 1 7 1 1       3x3   5995637.0 2102382.0 37.7524899085688 -122.457984564932 (37.7524899085688, -122.457984564932)
95068 109091 7 316 4235 23rd St 1 1 1 1 1 01/27/2015 12:00:00 AM 3 3x3 Permit Number 773805 6001611.4 2102294.1 37.7525900037408 -122.43731782876002 (37.7525900037408, -122.43731782876)
79534 121404 7 116 1900 08th Ave 1 13 1 1     3 10x10   5993817.0 2102486.0 37.7526707300666 -122.464285931649 (37.7526707300666, -122.464285931649)
9474 173600 7 60 500 Clarendon Ave 1 5 1 1       3x3   5996184.0 2102497.0 37.7528370823128 -122.45610127186899 (37.7528370823128, -122.456101271869)
116003 114410 7 3 10 GARDENSIDE DR   1 1 1           5999306.0 2102458.0 37.752908704913395 -122.445302055175 (37.7529087049134, -122.445302055175)
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)
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)
105687 122518 7 3 772X Panorama Dr 1 16 1 1       3x3   5996713.0 2102901.0 37.753976715350106 -122.45430108189 (37.7539767153501, -122.45430108189)
100275 96676 7 84 1701 21st Ave 1 1 1 1   06/22/2011 12:00:00 AM       5989644.3 2103769.9 37.7559545815884 -122.478809598698 (37.7559545815884, -122.478809598698)
2764 253207 7 47 89 Woodhaven Ct 1 16 1 1       3x3   5996069.0 2103645.0 37.75598259914371 -122.45658197288401 (37.7559825991437, -122.456581972884)
117738 104008 7 3 357 Collingwood St 1 13 1 1     36     6002124.0 2103789.0 37.7567237682266 -122.435652112093 (37.7567237682266, -122.435652112093)
109233 104397 7 231 350 Collingwood St 1 7 1 1           6002086.0 2103822.0 37.756812219827296 -122.43578589078301 (37.7568122198273, -122.435785890783)
4447 253626 7 47 1671 Funston Ave 1 13 1 1       10x10   5992125.0 2104081.0 37.756952512450205 -122.47025325330601 (37.7569525124502, -122.470253253306)
78510 114817 7 3 100 RACCOON DR 1 16 1 1           5998725.0 2104028.0 37.757186355085004 -122.447424250084 (37.757186355085, -122.447424250084)
88934 107130 7 65 751 DOLORES ST 1 8 1 1           6005081.8 2103948.4 37.7573290011944 -122.42543429450701 (37.7573290011944, -122.425434294507)
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)
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)
5096 253768 7 47 100 Raccoon Dr 1 13 1 1           5998692.0 2104165.0 37.7575606372552 -122.44754823773899 (37.7575606372552, -122.447548237739)
119332 120526 7 3 1439 47th Ave 1 13 1 1     20 3x3   5981489.0 2105275.0 37.759610238830206 -122.50712446853998 (37.7596102388302, -122.50712446854)
82732 102470 7 3 1021 Kirkham St 2 13 1 1           5991773.0 2105198.0 37.7599991432047 -122.471551983129 (37.7599991432047, -122.471551983129)
113649 102469 7 3 1021 Kirkham St 1 13 1 1           5991773.0 2105198.0 37.7599991432047 -122.471551983129 (37.7599991432047, -122.471551983129)
129004 108871 7 17 99x OAKWOOD ST 1 13 1 1           6005305.0 2104962.0 37.760124716943295 -122.424734485609 (37.7601247169433, -122.424734485609)
112498 106458 7 17 71 HANCOCK ST   13 1 1           6003861.6 2105050.0 37.7602847161222 -122.429732794413 (37.7602847161222, -122.429732794413)
1380 251512 7 20 4116x 18th St 1 13 1 6       3x3   6002190.0 2105341.0 37.760988934022706 -122.43553488468001 (37.7609889340227, -122.43553488468)
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)
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)
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)
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)
1928 252837 7 114 98 Prosper St 5 5 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1929 252833 7 114 98 Prosper St 1 5 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1945 252839 7 114 99 Pond St 2 9 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1948 252834 7 114 98 Prosper St 2 5 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1955 252835 7 114 98 Prosper St 3 5 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
140844 102706 7 47 1342 Funston Ave 1 13 1 1           5992135.4 2106294.8 37.7630316255695 -122.470378504645 (37.7630316255695, -122.470378504645)
105403 105236 7 47 235X STATES ST 1 13 1 1     30     6001213.0 2106258.0 37.7634512529938 -122.438979613423 (37.7634512529938, -122.438979613423)
116035 105232 7 3 460X ROOSEVELT WAY 2 7 1 1     17     5999944.0 2106286.0 37.7634558498539 -122.443370673769 (37.7634558498539, -122.443370673769)
78101 96597 7 458 325 Sanchez St   5 1 4 1         6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
110024 96606 7 458 325 Sanchez St   5 1 4 1         6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
111128 96599 7 458 325 Sanchez St   5 1 4 1         6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
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)
123910 96598 7 458 325 Sanchez St   5 3 4 1         6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
126860 96602 7 458 325 Sanchez St   5 1 4 1         6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
128034 96601 7 458 325 Sanchez St   5 1 4 1         6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
142264 96605 7 458 325 Sanchez St   5 1 4 1         6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
144514 96603 7 458 325 Sanchez St   5 1 4 1         6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
79751 105231 7 105 460X ROOSEVELT WAY 1 7 1 1     9     6000051.0 2106345.0 37.7636239504047 -122.44300483360901 (37.7636239504047, -122.443004833609)
109200 101625 7 250 64 Levant St 1 8 1 1         Permit Number 769362 6000275.9 2106473.5 37.76398959970761 -122.442236202383 (37.7639895997076, -122.442236202383)
79535 96590 7 49 450 Church St   5 1 4 1         6004088.8 2106523.6 37.7643437320395 -122.42905208409401 (37.7643437320395, -122.429052084094)
Powered by Datasette · Query took 7.179ms · Data source: data.sfgov.org