sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
76012 97025 7 88 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
78805 97021 7 180 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
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)
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)
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)
90248 97040 7 14 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
92954 97034 7 54 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
94845 97016 7 353 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
99914 97028 7 112 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
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)
107550 97032 7 477 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
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)
127473 97045 7 207 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
128784 97039 7 14 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
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)
142369 97035 7 309 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
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)
112387 109194 7 180 4705 03rd St   13 1 19     45     6015121.6 2095617.0 37.7350148477359 -122.39013039721901 (37.7350148477359, -122.390130397219)
83931 105169 7 60 4755X 03RD ST 3 8 1 19     23 4x4   6015032.0 2095658.0 37.7351224553975 -122.39044304267901 (37.7351224553975, -122.390443042679)
111891 105167 7 60 4755X 03RD ST 1 8 1 19     8 3x3   6015032.0 2095658.0 37.7351224553975 -122.39044304267901 (37.7351224553975, -122.390443042679)
112389 105171 7 21 4755X 03RD ST 5 7 1 19     14 4x4   6015032.0 2095658.0 37.7351224553975 -122.39044304267901 (37.7351224553975, -122.390443042679)
117969 105170 7 21 4755X 03RD ST 4 8 1 19     2 3x3   6015032.0 2095658.0 37.7351224553975 -122.39044304267901 (37.7351224553975, -122.390443042679)
82327 33793 7 21 200x Mission St 11 1 1 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138.0 2116340.0 37.791861063915796 -122.394982044679 (37.7918610639158, -122.394982044679)
83310 33775 7 21 200x Mission St 2 1 1 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138.0 2116340.0 37.791861063915796 -122.394982044679 (37.7918610639158, -122.394982044679)
85637 33789 7 21 200x Mission St 7 1 1 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138.0 2116340.0 37.791861063915796 -122.394982044679 (37.7918610639158, -122.394982044679)
89534 33794 7 21 200x Mission St 13 1 1 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138.0 2116340.0 37.791861063915796 -122.394982044679 (37.7918610639158, -122.394982044679)
92335 33787 7 21 200x Mission St 5 1 1 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138.0 2116340.0 37.791861063915796 -122.394982044679 (37.7918610639158, -122.394982044679)
112911 33786 7 21 200x Mission St 4 1 1 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138.0 2116340.0 37.791861063915796 -122.394982044679 (37.7918610639158, -122.394982044679)
120104 33790 7 21 200x Mission St 8 1 1 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138.0 2116340.0 37.791861063915796 -122.394982044679 (37.7918610639158, -122.394982044679)
120823 33791 7 21 200x Mission St 9 1 1 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138.0 2116340.0 37.791861063915796 -122.394982044679 (37.7918610639158, -122.394982044679)
128175 33776 7 21 200x Mission St 1 1 1 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138.0 2116340.0 37.791861063915796 -122.394982044679 (37.7918610639158, -122.394982044679)
128562 33799 7 21 200x Mission St 10 1 1 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138.0 2116340.0 37.791861063915796 -122.394982044679 (37.7918610639158, -122.394982044679)
142955 33788 7 21 200x Mission St 6 1 1 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138.0 2116340.0 37.791861063915796 -122.394982044679 (37.7918610639158, -122.394982044679)
77354 33781 7 21 200x misson st 12 1 1 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6013804.30364325 2116217.11127164 37.7915050790356 -122.396128026757 (37.7915050790356, -122.396128026757)
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)
139657 117644 7 47 1111X SANSOME ST 1 13 1 1       3x30   6011937.0 2119613.0 37.8007253016149 -122.402827843034 (37.8007253016149, -122.402827843034)
76017 106971 7 3 3479X San Bruno Ave 1 7 1 1     30     6011510.60551 2091910.0343099998 37.7246353494236 -122.402354399294 (37.7246353494236, -122.402354399294)
109029 108973 7 3 3485X SAN BRUNO AVE 1 3 1 10           6011510.0 2091910.0 37.724635221414 -122.402356490066 (37.724635221414, -122.402356490066)
113280 105686 7 94 635 08TH ST 3 30 1 1     6     6011418.5 2109097.9 37.7718243537934 -122.40388172759701 (37.7718243537934, -122.403881727597)
124771 105685 7 94 635 08TH ST 2 30 1 1     8     6011418.5 2109097.9 37.7718243537934 -122.40388172759701 (37.7718243537934, -122.403881727597)
126368 105684 7 94 635 08TH ST 1 30 1 1     10     6011418.5 2109097.9 37.7718243537934 -122.40388172759701 (37.7718243537934, -122.403881727597)
79011 108637 7 3 15 TUCKER AVE   13 1 1           6011049.2 2088423.2 37.715035447895396 -122.403704200211 (37.7150354478954, -122.403704200211)
98786 100139 7 17 155 05th St 2 7 1 1         Permit Number 769024 6011029.6 2112857.4 37.782125333955705 -122.40549178692301 (37.7821253339557, -122.405491786923)
1273 251481 7 3 32 Peralta Ave 1 13 1 2       3x3   6010779.0 2100499.0 37.7481779538542 -122.40548810426901 (37.7481779538542, -122.405488104269)
141354 120533 7 103 951 Brannan St 1 5 1 1     22 3x3   6010745.0 2108673.0 37.7706200263658 -122.40618148078501 (37.7706200263658, -122.406181480785)
669 251343 7 39 934 Brannan St 1 13 1 1       3x3   6010724.0 2108745.0 37.7708165471861 -122.40625919407302 (37.7708165471861, -122.406259194073)
100855 114731 7 103 934 BRANNAN ST   13 1 1 9     10x10   6010724.0 2108745.0 37.7708165471861 -122.40625919407302 (37.7708165471861, -122.406259194073)
22300 248974 7 2 716 Goettingen St 1 13 1 1       3x3   6010713.0 2091306.0 37.7229322393396 -122.405069122237 (37.7229322393396, -122.405069122237)
86843 109377 7 86 111 BAY ST 4 13 1 1           6010193.2 2121519.2 37.8058617340589 -122.40899671325899 (37.8058617340589, -122.408996713259)
96460 109375 7 86 111 BAY ST 2 13 1 1           6010193.2 2121519.2 37.8058617340589 -122.40899671325899 (37.8058617340589, -122.408996713259)
112237 109378 7 86 111 BAY ST 5 13 1 1           6010193.2 2121519.2 37.8058617340589 -122.40899671325899 (37.8058617340589, -122.408996713259)
118325 109374 7 86 111 BAY ST 1 13 1 1           6010193.2 2121519.2 37.8058617340589 -122.40899671325899 (37.8058617340589, -122.408996713259)
127758 109376 7 86 111 BAY ST 3 13 1 1           6010193.2 2121519.2 37.8058617340589 -122.40899671325899 (37.8058617340589, -122.408996713259)
102307 99256 7 116 1466 York St   13 1 1           6010099.0 2100741.0 37.7488043872035 -122.407856595429 (37.7488043872035, -122.407856595429)
105590 121144 7 3 400 Franconia St 1 13 1 1     15 3x3   6010016.0 2098808.0 37.743492145498294 -122.40800731166901 (37.7434921454983, -122.408007311669)
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)
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)
84088 103516 7 47 980 Green St 1 13 1 1           6008298.0 2118971.0 37.7987586699451 -122.415374854445 (37.7987586699451, -122.415374854445)
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)
140943 120977 7 3 794x Gates St 1 2 1 1     3030 3x3   6008103.0 2095407.0 37.7340464539486 -122.414381414226 (37.7340464539486, -122.414381414226)
92938 99277 7 17 85X 10th St 3 7 1 1   04/25/2012 12:00:00 AM     Permit Number 768878 6007907.6 2110517.0 37.7755240963356 -122.416126724722 (37.7755240963356, -122.416126724722)
97530 99275 7 17 85X 10th St 1 7 1 1   04/25/2012 12:00:00 AM     Permit Number 768878 6007907.6 2110517.0 37.7755240963356 -122.416126724722 (37.7755240963356, -122.416126724722)
125343 99276 7 17 85X 10th St 2 7 1 1   04/25/2012 12:00:00 AM     Permit Number 768878 6007907.6 2110517.0 37.7755240963356 -122.416126724722 (37.7755240963356, -122.416126724722)
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)
80595 102251 7 458 125X Powhattan Ave 4 7 1 1   01/07/2013 12:00:00 AM     Permit Number 768486 6007606.0 2098071.0 37.7413332800665 -122.416288322592 (37.7413332800665, -122.416288322592)
99354 102249 7 41 125X Powhattan Ave 2 7 1 1   01/07/2013 12:00:00 AM     Permit Number 768486 6007606.0 2098071.0 37.7413332800665 -122.416288322592 (37.7413332800665, -122.416288322592)
101894 102250 7 41 125X Powhattan Ave 3 7 1 1   01/07/2013 12:00:00 AM     Permit Number 768486 6007606.0 2098071.0 37.7413332800665 -122.416288322592 (37.7413332800665, -122.416288322592)
104754 102248 7 41 125X Powhattan Ave 1 7 1 1   01/07/2013 12:00:00 AM     Permit Number 768486 6007606.0 2098071.0 37.7413332800665 -122.416288322592 (37.7413332800665, -122.416288322592)
85764 115641 7 3 81x ELSIE ST 7 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
86412 115638 7 3 81x ELSIE ST 4 16 1 2     7 3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
90360 115646 7 3 81x ELSIE ST 12 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
95069 115635 7 3 81x ELSIE ST 1 16 1 2     20 3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
96699 115645 7 3 81x ELSIE ST 11 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
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)
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)
Powered by Datasette · Query took 2.966ms · Data source: data.sfgov.org