sf-trees

Data source: data.sfgov.org

Custom SQL query returning 26 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
17396 28296 1 66 1432 Guerrero St 1 1 1 1   02/26/2003 12:00:00 AM 6 2X3   6005818.9272 2100626.68333 37.7482499542668 -122.42264897149599 (37.7482499542668, -122.422648971496)
18434 28792 1 66 2731 Harrison St 1 1 1 1     6 3x3   6008964.243480001 2102548.86607 37.753704789464294 -122.411908330514 (37.7537047894643, -122.411908330514)
18475 26484 3 66 154 Gold Mine Dr 1 1 1 2     6 3X3   6000987.64369 2098692.2557200002 37.7426647191989 -122.439216742684 (37.7426647191989, -122.439216742684)
19529 24597 1 66 451 Cortland Ave 1 1 1 1   04/10/1996 12:00:00 AM 6 3X3   6007425.33634 2097280.23764 37.7391518611665 -122.41685698498101 (37.7391518611665, -122.416856984981)
20561 28791 1 66 2737 Harrison St 1 1 1 1     6 3x3   6008967.21311 2102509.30076 37.7535963186214 -122.41189526514799 (37.7535963186214, -122.411895265148)
25122 206533 2 66 665 Miramar Ave 1 1 1 1     6 Width 2ft   5995361.50595 2093791.16395 37.7288857636427 -122.45831551006201 (37.7288857636427, -122.458315510062)
25180 126376 2 66 122 Cervantes Blvd 2 1 1 1     6 Width 2ft   6001336.2876 2121154.5777 37.8043604581295 -122.43962119477399 (37.8043604581295, -122.439621194774)
25343 183040 2 66 2562 21st Ave 2 1 1 1     6 Width 0ft   5989885.4338 2097934.2198 37.739945333152 -122.477549168466 (37.739945333152, -122.477549168466)
37239 41230 1 66 3618 Webster St 1 1 1 1 1 11/30/1999 12:00:00 AM 6 3x3 Permit Number 41935 6002625.18254 2121047.68706 37.804140238442 -122.43515322167102 (37.804140238442, -122.435153221671)
49647 206622 2 66 1912 10th Ave 1 1 1 1     6 Width 3ft   5993175.38418 2102417.55667 37.752445798858396 -122.466499759777 (37.7524457988584, -122.466499759777)
58539 206598 2 66 150 Magellan Ave 2 1 1 1     6 Width 4ft   5995052.00135 2100847.98673 37.74824426696271 -122.45989646247601 (37.7482442669627, -122.459896462476)
70281 206632 2 66 99 Castenada Ave 2 1 1 1     6 Width 3ft   5994454.48924 2101216.21265 37.749220940594604 -122.46198932515 (37.7492209405946, -122.46198932515)
74097 223041 2 66 410 Cortland Ave 1 1 1 1     6 Width 3ft   6007256.618290001 2097259.39898 37.7390851512711 -122.41743886071899 (37.7390851512711, -122.417438860719)
126743 223043 2 66 4107 Ogden Ave 2 1 1 1     6 Width 3ft   6008381.78974 2096055.8705400003 37.735843768863795 -122.413463422917 (37.7358437688638, -122.413463422917)
132280 223046 2 66 77 28th St 1 1 1 1     6 Width 3ft   6005471.50149 2099604.5609999998 37.7454238329391 -122.423777694396 (37.7454238329391, -122.423777694396)
137011 137657 2 66 2167 TURK BLVD 1 1 1 1     6 Width 0ft   5999659.4785 2111881.8514 37.778804413574704 -122.444756988886 (37.7788044135747, -122.444756988886)
137986 223050 2 66 18 Buena Vista Ter 1 1 1 1     6 Width 3ft   6001422.84544 2108013.2139 37.7682825750187 -122.43837958446301 (37.7682825750187, -122.438379584463)
152052 223044 2 66 13 Stoneman St 2 1 1 1     6 Width 3ft   6008324.57166 2099444.87133 37.7451460071793 -122.413900908902 (37.7451460071793, -122.413900908902)
158004 223037 2 66 203 Surrey St 2 1 1 1     6 Width 3ft   6002071.560219999 2096098.27883 37.7356038810064 -122.435283373351 (37.7356038810064, -122.435283373351)
160564 31753 1 66 2642 21st Ave 1 1 1 1 1 06/19/1995 12:00:00 AM 6   Permit Number 35239 5989905.4007 2097364.9943 37.738383545459 -122.477438539611 (37.738383545459, -122.477438539611)
162977 223033 2 66 281 Richland Ave 2 1 1 1     6 Width 3ft   6006248.27078 2096110.4955099998 37.735873731571395 -122.420843728155 (37.7358737315714, -122.420843728155)
165172 50986 1 66 1120REVISED Greenwich St 1 1 1 1   08/06/2004 12:00:00 AM 6   Permit Number 47576 6007503.31376 2119893.93908 37.801248132044 -122.418190201138 (37.801248132044, -122.418190201138)
171923 206534 2 66 665 Miramar Ave 2 1 1 1     6 Width 2ft   5995362.10243 2093779.40423 37.7288535085691 -122.45831259717501 (37.7288535085691, -122.458312597175)
177415 223049 2 66 45 Hartford St 1 1 1 1     6 Width 3ft   6002666.83309 2105626.92623 37.7618010890622 -122.433906166852 (37.7618010890622, -122.433906166852)
177940 206677 2 66 228 Yerba Buena Ave 1 1 1 1     6 Width 3ft   5994904.4684 2095946.32835 37.7347770452256 -122.46005157662901 (37.7347770452256, -122.460051576629)
189037 206564 2 66 2044 10th Ave 1 1 1 1     6 Width 3ft   5993156.7665 2101574.66751 37.7501303674196 -122.46650288401399 (37.7501303674196, -122.466502884014)
Powered by Datasette · Query took 173.828ms · Data source: data.sfgov.org