sf-trees

Data source: data.sfgov.org

Custom SQL query returning 56 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
539 206615 2 66 198 Vasquez Ave 1 2 1 1     6 Width 3ft Permit Number 779324 5994758.52704 2099346.29484 37.7441041156281 -122.460802465585 (37.7441041156281, -122.460802465585)
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)
26518 206504 2 66 1959 10th Ave 1 2 1 1     6 Width 6ft   5993136.05327 2102151.01657 37.7517116786758 -122.46661639913602 (37.7517116786758, -122.466616399136)
29674 206651 2 66 160 Castenada Ave 1 2 1 1     6 Width 3ft   5994510.63767 2100971.03236 37.7485509699531 -122.461777389118 (37.7485509699531, -122.461777389118)
33381 206506 2 66 1985 10th Ave 1 2 1 1     6 Width 6ft   5993143.71774 2101970.98373 37.7512177970674 -122.46657681008301 (37.7512177970674, -122.466576810083)
34122 206658 2 66 41 Alton Ave 2 2 1 1     6 Width 3ft   5994157.02115 2101539.85513 37.7500924502117 -122.463041445619 (37.7500924502117, -122.463041445619)
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)
39798 206669 2 66 15 Sotelo Ave 4 2 1 1     6 Width 3ft   5994007.62455 2100906.4247 37.74834460433671 -122.463512099503 (37.7483446043367, -122.463512099503)
40135 206582 2 66 190 Dorantes Ave 1 2 1 1     6 Width 3ft   5993610.53275 2099775.23813 37.745215765798996 -122.464803087101 (37.745215765799, -122.464803087101)
47868 206574 2 66 120 Montalvo Ave 2 2 1 1     6 Width 3ft   5993698.095930001 2099619.5133 37.744793232835605 -122.464489006068 (37.7447932328356, -122.464489006068)
49358 206666 2 66 15 Sotelo Ave 1 2 1 1     6 Width 3ft   5993976.53914 2100938.08553 37.74842974584271 -122.46362188875901 (37.7484297458427, -122.463621888759)
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)
54773 206638 2 66 167 Castenada Ave 1 2 1 1     6 Width 3ft   5994538.83302 2100858.6540099997 37.7482440304446 -122.46167174395 (37.7482440304446, -122.46167174395)
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)
58785 206665 2 66 11 Santa Rita Ave 1 2 1 1     6 Width 3ft   5993870.76921 2100887.71242 37.748285339014295 -122.463983980089 (37.7482853390143, -122.463983980089)
60482 247587 2 66 800 Tompkins Ave 8 7 1 1     6     6008949.04431 2096428.8077599998 37.7368996080238 -122.41152853331499 (37.7368996080238, -122.411528533315)
62866 206570 2 66 4 Dorantes Ave 1 2 1 1     6 Width 3ft   5993230.1067699995 2099675.67045 37.7449204374235 -122.46611129043 (37.7449204374235, -122.46611129043)
63732 247588 2 66 800 Tompkins Ave 9 7 1 1     6     6008943.011630001 2096440.0672900002 37.7369301858647 -122.411550186315 (37.7369301858647, -122.411550186315)
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)
72564 206631 2 66 89 Ventura Ave 1 2 1 1     6 Width 3ft   5994365.2652199995 2101880.85976 37.7510407556506 -122.462346061026 (37.7510407556506, -122.462346061026)
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)
74465 206646 2 66 180 Castenada Ave 3 2 1 1     6 Width 3ft   5994489.718859999 2100854.37735 37.7482294605322 -122.46184126797701 (37.7482294605322, -122.461841267977)
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)
133979 206590 2 66 340 Magellan Ave 1 2 1 1     6 Width 3ft   5994099.18491 2099823.6206900002 37.745376773231 -122.463116933812 (37.745376773231, -122.463116933812)
134479 206645 2 66 180 Castenada Ave 2 2 1 1     6 Width 3ft   5994475.58114 2100840.87711 37.748191578392294 -122.461889176638 (37.7481915783923, -122.461889176638)
134876 206558 2 66 517 Laguna Honda Blvd 1 2 1 1     6 Width 4ft   5995506.851369999 2100151.8642599997 37.7463590370584 -122.458273237436 (37.7463590370584, -122.458273237436)
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)
137122 206507 2 66 1985 10th Ave 2 2 1 1     6 Width 6ft   5993144.62205 2101960.97627 37.751190371338 -122.46657295558599 (37.751190371338, -122.466572955586)
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)
151744 218121 2 66 45 Lopez Ave 2 2 1 1     6 Width 0ft   5994024.91011 2100655.57636 37.7476568343048 -122.463434125583 (37.7476568343048, -122.463434125583)
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)
156496 206639 2 66 175 Castenada Ave 1 2 1 1     6 Width 3ft   5994510.39425 2100823.8744099997 37.748146897381794 -122.461767562235 (37.7481468973818, -122.461767562235)
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)
158121 206588 2 66 348 Magellan Ave 1 2 1 1     6 Width 3ft   5994058.29292 2099782.40477 37.7452612490171 -122.463255340382 (37.7452612490171, -122.463255340382)
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)
162090 206642 2 66 196 Castenada Ave 2 2 1 1     6 Width 3ft   5994408.53923 2100777.89876 37.7480147959636 -122.46211643714899 (37.7480147959636, -122.462116437149)
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)
164769 206602 2 66 160 Magellan Ave 3 2 1 1     6 Width 4ft   5995047.859019999 2100763.4476 37.7480119055303 -122.45990466338101 (37.7480119055303, -122.459904663381)
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)
168564 206601 2 66 160 Magellan Ave 1 2 1 1     6 Width 4ft   5995052.26314 2100785.00395 37.7480713471357 -122.45989099549601 (37.7480713471357, -122.459890995496)
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)
179119 206587 2 66 348 Magellan Ave 2 2 1 1     6 Width 3ft   5994044.71238 2099771.06427 37.745229328484704 -122.46330147648099 (37.7452293284847, -122.463301476481)
184549 206626 2 66 40 Ventura Ave 2 2 1 1     6 Width 3ft   5994084.99265 2101862.2244599997 37.750973444992205 -122.46331391231199 (37.7509734449922, -122.463313912312)
187736 206608 2 66 2 Sola Ave 3 2 1 1     6 Width 4ft   5994960.813709999 2100721.5804 37.7478919422595 -122.460202627649 (37.7478919422595, -122.460202627649)
188058 206537 2 66 401 Pacheco St 2 2 1 1     6 Width 3ft   5994067.3294 2101503.80633 37.7499883024325 -122.46334898679 (37.7499883024325, -122.46334898679)
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 5.746ms · Data source: data.sfgov.org