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)
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)
112387 109194 7 180 4705 03rd St   13 1 19     45     6015121.6 2095617.0 37.7350148477359 -122.39013039721901 (37.7350148477359, -122.390130397219)
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)
3132 253339 7 47 2019X 24th Ave 1 9 1 13       3x3   5988853.0 2101569.0 37.7498655183494 -122.481384971136 (37.7498655183494, -122.481384971136)
109029 108973 7 3 3485X SAN BRUNO AVE 1 3 1 10           6011510.0 2091910.0 37.724635221414 -122.402356490066 (37.724635221414, -122.402356490066)
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)
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)
1380 251512 7 20 4116x 18th St 1 13 1 6       3x3   6002190.0 2105341.0 37.760988934022706 -122.43553488468001 (37.7609889340227, -122.43553488468)
102914 112377 7 36 801 ULLOA ST 3 1 1 6     36     5993401.0 2098089.0 37.7405736985828 -122.46540514019699 (37.7405736985828, -122.465405140197)
107936 118318 7 22 20 Norton St 1 7 1 6           6002015.686319999 2092167.12899 37.724806667280895 -122.435195459751 (37.7248066672809, -122.435195459751)
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)
78101 96597 7 458 325 Sanchez St   5 1 4 1         6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
79535 96590 7 49 450 Church St   5 1 4 1         6004088.8 2106523.6 37.7643437320395 -122.42905208409401 (37.7643437320395, -122.429052084094)
81703 96593 7 49 450 Church St   5 1 4 1         6004088.8 2106523.6 37.7643437320395 -122.42905208409401 (37.7643437320395, -122.429052084094)
85657 96591 7 49 450 Church St   5 1 4 1         6004088.8 2106523.6 37.7643437320395 -122.42905208409401 (37.7643437320395, -122.429052084094)
97416 96594 7 49 450 Church St   5 1 4 1         6004088.8 2106523.6 37.7643437320395 -122.42905208409401 (37.7643437320395, -122.429052084094)
100052 97238 7 41 125 Excelsior Ave 1 9 1 4 1 09/07/2011 12:00:00 AM 3 3x3 Permit Number 767513 6002911.0 2092621.3 37.7261045201699 -122.43213288829399 (37.7261045201699, -122.432132888294)
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)
116314 96592 7 49 450 Church St   5 1 4 1         6004088.8 2106523.6 37.7643437320395 -122.42905208409401 (37.7643437320395, -122.429052084094)
121581 96589 7 49 450 Church St   5 1 4 1         6004088.8 2106523.6 37.7643437320395 -122.42905208409401 (37.7643437320395, -122.429052084094)
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)
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)
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)
1273 251481 7 3 32 Peralta Ave 1 13 1 2       3x3   6010779.0 2100499.0 37.7481779538542 -122.40548810426901 (37.7481779538542, -122.405488104269)
19656 101900 7 3 1100 Ocean Ave 1 7 1 2         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967)
78854 101901 7 2 1100 Ocean Ave 2 7 1 2         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967)
85764 115641 7 3 81x ELSIE ST 7 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
85853 114950 7 3 1X WOODACRE DR 2 19 1 2       30x100   5991187.0 2095315.0 37.732829063550795 -122.47285799850201 (37.7328290635508, -122.472857998502)
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)
107366 101903 7 75 1100 Ocean Ave 4 7 1 2         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967)
108009 115652 7 3 81x ELSIE ST 18 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
110616 101905 7 75 1100 Ocean Ave 6 7 1 2         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967)
111345 114949 7 3 1X WOODACRE DR 1 19 1 2     30 30x100   5991187.0 2095315.0 37.732829063550795 -122.47285799850201 (37.7328290635508, -122.472857998502)
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)
146191 101904 7 75 1100 Ocean Ave 5 7 1 2         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967)
631 251294 7 54 7126 Geary Blvd 1 16 1 1       3x3   5984860.0 2112552.0 37.779788778901796 -122.49600289252199 (37.7797887789018, -122.496002892522)
669 251343 7 39 934 Brannan St 1 13 1 1       3x3   6010724.0 2108745.0 37.7708165471861 -122.40625919407302 (37.7708165471861, -122.406259194073)
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)
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)
1996 252848 7 164 99 Reposa Way 1 13 1 1       3x3   5998022.0 2098104.0 37.7408803073177 -122.44942865965 (37.7408803073177, -122.44942865965)
2595 253142 7 186 735 29th Ave 1 5 1 1       3x3   5986898.0 2110914.0 37.7754104499772 -122.48883220977301 (37.7754104499772, -122.488832209773)
2606 253143 7 186 735 29th Ave 2 5 1 1       3x3   5986898.0 2110914.0 37.7754104499772 -122.48883220977301 (37.7754104499772, -122.488832209773)
2764 253207 7 47 89 Woodhaven Ct 1 16 1 1       3x3   5996069.0 2103645.0 37.75598259914371 -122.45658197288401 (37.7559825991437, -122.456581972884)
Powered by Datasette · Query took 3.147ms · Data source: data.sfgov.org