sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
136130 178972 2 18 856 Sunnydale Ave 1 1 1 1     1 Width 3ft   6009124.92679 2086754.6391599998 37.7103462396574 -122.410237598787 (37.7103462396574, -122.410237598787)
156949 178980 2 18 38 Whipple Ave 1 1 1 1     1 Width 2ft   5998273.4288099995 2087174.03892 37.7108835719974 -122.44777265158702 (37.7108835719974, -122.447772651587)
181085 178981 2 18 38 Whipple Ave 2 1 1 1     1 Width 2ft   5998261.9451 2087183.3832900003 37.7109085731488 -122.447813014086 (37.7109085731488, -122.447813014086)
34465 179159 2 18 113 Seville St 1 1 1 1     1 Width 4ft   6001727.04807 2087313.1468599997 37.711462320802205 -122.435846103423 (37.7114623208022, -122.435846103423)
151564 179160 2 18 113 Seville St 2 1 1 1     1 Width 4ft   6001754.98626 2087320.62379 37.711484437814896 -122.43575007652599 (37.7114844378149, -122.435750076526)
26523 88167 1 18 189 Leland Ave 1 1 1 1   12/07/2013 12:00:00 AM 1 3x3 Permit Number 51184 6010014.6058 2087504.2072 37.7124542316575 -122.40721547231199 (37.7124542316575, -122.407215472312)
55797 178976 2 18 221 Naglee Ave 1 1 1 1     1 Width 1ft   5998101.98654 2088087.6608 37.7133823688881 -122.448430945451 (37.7133823688881, -122.448430945451)
184405 179029 2 18 226 Raymond Ave 1 1 1 1     1 Width 3ft   6009880.60922 2087872.96636 37.7134592690157 -122.407704592601 (37.7134592690157, -122.407704592601)
134984 179034 2 18 88 Alpha St 2 2 1 1     1 Width 5ft   6011090.19294 2088313.2717799998 37.7147358971229 -122.403554780747 (37.7147358971229, -122.403554780747)
68476 179033 2 18 88 Alpha St 1 2 1 1     1 Width 5ft   6011104.28456 2088327.78048 37.7147765222032 -122.40350709418001 (37.7147765222032, -122.40350709418)
53260 178985 2 18 276 Foote Ave 1 1 1 1     1 Width 1ft   5998310.44307 2088707.23579 37.7150954964391 -122.447755025789 (37.7150954964391, -122.447755025789)
36963 179014 2 18 174 Prague St 1 1 1 1     1 Width 2ft   6004359.78757 2090147.3010099998 37.7193934976835 -122.426948390073 (37.7193934976835, -122.426948390073)
56542 213324 2 18 355 Byxbee St 1 4 1 1     1 Width 3ft   5991941.51913 2090886.05993 37.7207119433918 -122.469927103079 (37.7207119433918, -122.469927103079)
189007 214828 2 18 14 Holloway Ave 1 1 1 1     1 Width 3ft   5996730.05288 2091219.63097 37.7219034920315 -122.453398786937 (37.7219034920315, -122.453398786937)
132513 202042 2 18 52 Exeter St 1 4 1 1     1 Width 3ft   6012532.81359 2090984.9967200002 37.7221523937885 -122.398755844523 (37.7221523937885, -122.398755844523)
30296 202045 2 18 41 Exeter St 1 4 1 1     1 Width 3ft   6012584.35783 2091031.2434099999 37.7222822496095 -122.39858091108201 (37.7222822496095, -122.398580911082)
117664 178989 2 18 342 Oneida Ave 3 1 1 1     1 Width 2ft   5999402.14397 2091356.43076 37.722431916576795 -122.444171904613 (37.7224319165768, -122.444171904613)
136084 214838 2 18 525 Faxon Ave 1 1 1 1     1 Width 3ft   5994748.09139 2092048.02975 37.7240642697395 -122.460309866434 (37.7240642697395, -122.460309866434)
175560 214826 2 18 115 Judson Ave 1 9 1 1     1 Width 8ft   5999324.23026 2093457.23325 37.728195788502795 -122.444592150628 (37.7281957885028, -122.444592150628)
70081 214717 2 18 151 Westgate Dr 1 1 1 1     1 Width 3ft   5993452.86708 2094012.79018 37.729384430533706 -122.464929844743 (37.7293844305337, -122.464929844743)
48960 214716 2 18 163 Westgate Dr 1 1 1 1     1 Width 3ft   5993482.35353 2094088.81019 37.729594862901 -122.46483342661502 (37.729594862901, -122.464833426615)
165082 213691 2 18 292 Circular Ave 1 1 1 1     1 Width 3ft   6000508.81995 2094097.0756400002 37.7300201720878 -122.440542862272 (37.7300201720878, -122.440542862272)
166562 214763 2 18 81 Northwood Dr 2 1 1 1     1 Width 2ft   5995479.81772 2094208.1402 37.7300374777322 -122.457936663441 (37.7300374777322, -122.457936663441)
28184 214762 2 18 81 Northwood Dr 1 1 1 1     1 Width 2ft   5995454.99385 2094213.2008599997 37.730049946826796 -122.45802284817199 (37.7300499468268, -122.458022848172)
66203 214714 2 18 106 Aptos Ave 1 1 1 1     1 Width 3ft   5993036.39091 2094292.8856099998 37.7301294810876 -122.466389978617 (37.7301294810876, -122.466389978617)
177159 179100 2 18 135 Craut St 2 1 1 1     1 Width 3ft   6004051.95756 2094086.86306 37.73019325200929 -122.42829307076599 (37.7301932520093, -122.428293070766)
132753 179101 2 18 135 Craut St 3 1 1 1     1 Width 3ft   6004050.870569999 2094104.12464 37.730240586937 -122.428298058407 (37.730240586937, -122.428298058407)
47200 214819 2 18 14 Hearst Ave 1 1 1 1     1 Width 2ft   6001004.15668 2094363.7751900002 37.730780661291206 -122.438849530576 (37.7307806612912, -122.438849530576)
65949 214701 2 18 289 Santa Ana Ave 2 1 1 1     1 Width 3ft   5992648.14001 2094956.6542099998 37.7319296144386 -122.467780457307 (37.7319296144386, -122.467780457307)
27296 213681 2 18 305 Baden St 1 9 1 1     1 Width 5ft   6000730.35653 2095033.04499 37.7326027399078 -122.439844065674 (37.7326027399078, -122.439844065674)
71520 213678 2 18 196 Lippard Ave 1 1 1 1     1 Width 3ft   6001770.450019999 2095060.16023 37.73273634229739 -122.43625015533001 (37.7327363422974, -122.43625015533)
70897 237408 2 18 113 Cuvier St 1 1 1 1     1 Width 3ft   6004031.84478 2095124.54925 37.7330413671563 -122.42843653693998 (37.7330413671563, -122.42843653694)
174759 213676 2 18 180 Lippard Ave 1 1 1 1     1 Width 3ft   6001814.64929 2095222.55474 37.7331847514805 -122.43610896448 (37.7331847514805, -122.43610896448)
34005 196506 2 18 1301 Newcomb Ave 4 1 1 1     1 Width 3ft   6016688.4000699995 2094936.9316 37.7332342924349 -122.384666003252 (37.7332342924349, -122.384666003252)
64185 196507 2 18 65 Whitney Young Cir 1 1 1 1     1 Width 3ft   6016757.4280199995 2094967.1096700002 37.7333209726796 -122.384429453683 (37.7333209726796, -122.384429453683)
28369 237264 2 18 780 Andover St 1 1 1 1     1 Width 3ft   6007326.8188 2095184.16778 37.7333909723093 -122.417049136835 (37.7333909723093, -122.417049136835)
56297 179040 2 18 2945 24th Ave 4 4 1 1     1 Width 2ft   5989055.545969999 2095618.79902 37.7335395942586 -122.480249118621 (37.7335395942586, -122.480249118621)
48514 50297 1 18 2909 24th Ave 1 1 1 1 1 01/28/2004 12:00:00 AM 1   Permit Number 47009 5989047.82914 2095849.4982599998 37.7341725865769 -122.48029267728701 (37.7341725865769, -122.480292677287)
55363 213618 2 18 47 Stanford Heights Ave 1 9 1 1     1 Width 3ft   5997823.37766 2095859.28539 37.7347054969618 -122.449953678441 (37.7347054969618, -122.449953678441)
59938 237315 2 18 515 Nevada St 1 1 1 1     1 Width 2ft   6008887.93473 2095934.39273 37.7355386235085 -122.41170489307501 (37.7355386235085, -122.411704893075)
178004 237262 2 18 251 Richland Ave 1 1 1 1     1 Width 3ft   6006011.4232 2096130.28963 37.735914728990004 -122.42166401060301 (37.73591472899, -122.421664010603)
165818 239455 2 18 201 Sussex St 1 1 1 1     1 Width 3ft   6001688.324030001 2096388.17196 37.736378089382704 -122.436629108958 (37.7363780893827, -122.436629108958)
160445 239452 2 18 135 Swiss Ave 2 1 1 1     1 Width 2ft   6001289.95457 2096424.81573 37.7364560578872 -122.438009060187 (37.7364560578872, -122.438009060187)
174043 237274 2 18 624 Moultrie St 1 1 1 1     1 Width 3ft   6007643.98133 2096429.64875 37.7368286272306 -122.41604078636298 (37.7368286272306, -122.416040786363)
185530 237333 2 18 379 Highland Ave 1 1 1 1     1 Width 2ft   6007360.67513 2096538.56664 37.7371117589919 -122.417028018027 (37.7371117589919, -122.417028018027)
38688 237334 2 18 379 Highland Ave 2 1 1 1     1 Width 2ft   6007338.79094 2096540.2275099999 37.737115088292 -122.417103799428 (37.737115088292, -122.417103799428)
53356 238510 2 18 272 Arlington St 1 1 1 1     1 Width 2ft   6004605.35635 2096606.41263 37.737142667797706 -122.42655923724399 (37.7371426677977, -122.426559237244)
160348 218239 2 18 333 Wawona St 2 2 1 1     1 Width 2ft   5992027.82558 2097196.10935 37.738042756963296 -122.47008800346599 (37.7380427569633, -122.470088003466)
30946 214679 2 18 2662 16th Ave 1 1 1 1     1 Width 3ft   5991458.95209 2097290.33549 37.7382685749396 -122.472061728486 (37.7382685749396, -122.472061728486)
69474 214675 2 18 2666 15th Ave 1 1 1 1     1 Width 3ft   5991784.11224 2097296.36475 37.7383039407656 -122.47093793473199 (37.7383039407656, -122.470937934732)
148310 238495 2 18 160 Randall St 1 1 1 1     1 Width 3ft   6004494.89279 2097560.99136 37.739757479015005 -122.42700912849199 (37.739757479015, -122.427009128492)
127118 237289 2 18 220 Gates St 1 1 1 1     1 Width 3ft   6008259.21213 2097608.44348 37.7400999111754 -122.413997022154 (37.7400999111754, -122.413997022154)
152727 214806 2 18 39 Reposa Way 2 1 1 1     1 Width 2ft   5997950.91184 2097983.31568 37.7405448705597 -122.449665760462 (37.7405448705597, -122.449665760462)
66928 214803 2 18 861 Rockdale Dr 1 1 1 1     1 Width 2ft   5996696.54151 2098246.82779 37.741196566960795 -122.454021889422 (37.7411965669608, -122.454021889422)
55168 214804 2 18 861 Rockdale Dr 2 1 1 1     1 Width 2ft   5996707.74048 2098249.43953 37.7412043802882 -122.45398335617399 (37.7412043802882, -122.453983356174)
67306 237199 2 18 506 29th St 1 1 1 1     1 Width 3ft   6003244.32891 2098942.2749900003 37.743479370974896 -122.43143162557699 (37.7434793709749, -122.431431625577)
65415 214681 2 18 18 Taraval St 1 1 1 1     1 Width 3ft   5993846.98731 2099285.74524 37.743885371716 -122.463949948827 (37.743885371716, -122.463949948827)
152835 237409 2 18 85 29th St 1 1 1 1     1 Width 3ft   6005854.88413 2099040.03879 37.7438954180548 -122.422411912884 (37.7438954180548, -122.422411912884)
59593 237207 2 18 483 Valley St 2 2 1 1     1     6002742.12056 2099166.74161 37.7440672281147 -122.433184169536 (37.7440672281147, -122.433184169536)
168358 237206 2 18 483 Valley St 1 2 1 1     1     6002728.73401 2099167.30182 37.7440680069289 -122.43323049721 (37.7440680069289, -122.43323049721)
32991 237208 2 18 483 Valley St 3 2 1 1     1     6002753.541619999 2099167.64088 37.74407034517979 -122.433144742342 (37.7440703451798, -122.433144742342)
42773 237209 2 18 483 Valley St 5 2 1 1     1     6002775.7731 2099167.46556 37.744071124872896 -122.43306785839899 (37.7440711248729, -122.433067858399)
30654 237210 2 18 483 Valley St 6 2 1 1     1     6002788.0313800005 2099167.4963 37.744071904607395 -122.43302547424 (37.7440719046074, -122.43302547424)
31049 237165 2 18 1801 Alabama St 1 1 1 1     1 Width 3ft   6009370.48822 2099100.96041 37.7442603881066 -122.41026001891001 (37.7442603881066, -122.41026001891)
162921 237202 2 18 300 Valley St 3 1 1 1     1 Width 2ft   6003860.21691 2099267.14708 37.744406281519296 -122.42932520110901 (37.7444062815193, -122.429325201109)
43645 213424 2 18 2329 Cecilia Ave 1 1 1 1     1 Width 3ft   5991443.60729 2099536.95345 37.7444363251911 -122.47227850735001 (37.7444363251911, -122.47227850735)
36046 237218 2 18 1534 Sanchez St 2 1 1 1     1 Width 3ft   6003930.350380001 2099302.4493400003 37.744507183667295 -122.42908521071699 (37.7445071836673, -122.429085210717)
179381 213434 2 18 2326 Cecilia Ave 2 2 1 1     1 Width 3ft   5991474.66936 2099581.1439400003 37.7445594585564 -122.47217432268499 (37.7445594585564, -122.472174322685)
136693 237414 2 18 618 28th St 2 1 1 1     1 Width 2ft   6001860.112380001 2099445.78199 37.744783333975704 -122.436253917188 (37.7447833339757, -122.436253917188)
183012 239409 2 18 38 Newburg St 1 1 1 1     1 Width 2ft   6002441.3727400005 2099900.5673700003 37.746065076544 -122.434276539152 (37.746065076544, -122.434276539152)
180388 246511 2 18 207 Duncan St 1 4 1 1     1 Width 4ft   6005075.21268 2099872.36362 37.746136778598 -122.42516705074101 (37.746136778598, -122.425167050741)
150275 237181 2 18 125 Mullen Ave 1 1 1 1     1 Width 3ft   6009871.831 2099849.755 37.7463445040092 -122.408579286712 (37.7463445040092, -122.408579286712)
62219 213573 2 18 401 Dewey Blvd 6 2 1 1     1 Width 3ft   5995208.70184 2100413.07322 37.7470591142869 -122.459323109585 (37.7470591142869, -122.459323109585)
186079 213586 2 18 2146 12th Ave 1 1 1 1     1 Width 3ft   5992608.85526 2100815.1518900003 37.748013300381395 -122.468342327659 (37.7480133003814, -122.468342327659)
166393 214768 2 18 48 Marcela Ave 1 1 1 1     1 Width 4ft   5994762.16541 2100788.31407 37.7480637478616 -122.460894375369 (37.7480637478616, -122.460894375369)
152202 214767 2 18 333 Pacheco St 2 2 1 1     1 Width 4ft   5994252.85515 2100808.3467 37.7480894333884 -122.462656990837 (37.7480894333884, -122.462656990837)
121797 214666 2 18 2116 17th Ave 1 1 1 1     1 Width 3ft   5991020.8875 2100990.67096 37.7484033831124 -122.473846204659 (37.7484033831124, -122.473846204659)
177005 214490 2 18 2083 16th Ave 3 2 1 1     1 Width 3ft   5991275.47389 2101260.33758 37.7491585600375 -122.47298552109 (37.7491585600375, -122.47298552109)
113411 114039 2 18 1328 TREAT WAY   1 1 1     1 3x3   6008689.0 2100921.0 37.7492195885474 -122.412745111821 (37.7492195885474, -122.412745111821)
29862 237360 2 18 1328 Treat Way 1 1 1 1     1 Width 3ft   6008685.53865 2100922.75177 37.749224204239 -122.412757205096 (37.749224204239, -122.412757205096)
34050 214489 2 18 2083 16th Ave 1 2 1 1     1 Width 3ft   5991276.32219 2101284.43599 37.7492247771203 -122.47298434476801 (37.7492247771203, -122.472984344768)
153811 196454 2 18 1950 Cesar Chavez St 10 4 1 1     1 Width 3ft   6012891.82767 2101016.42082 37.749716592054206 -122.398218262172 (37.7497165920542, -122.398218262172)
178948 196451 2 18 1950 Cesar Chavez St 3 4 1 1     1 Width 3ft   6013299.05466 2101039.80695 37.7498034800424 -122.396811684714 (37.7498034800424, -122.396811684714)
147208 196450 2 18 1950 Cesar Chavez St 1 4 1 1     1 Width 3ft   6013387.24706 2101044.34817 37.7498208576628 -122.39650702770001 (37.7498208576628, -122.3965070277)
51276 214657 2 18 2033 18th Ave 1 1 1 1     1 Width 2ft   5990646.87273 2101531.01352 37.7498653525019 -122.475178967532 (37.7498653525019, -122.475178967532)
169229 214485 2 18 2027 17th Ave 1 1 1 1     1 Width 2ft   5990955.91795 2101581.62177 37.7500222167656 -122.47411397779 (37.7500222167656, -122.47411397779)
170802 196438 2 18 1300 Cesar Chavez St 2 1 1 1     1 Width 3ft   6015044.32759 2101169.27402 37.7502559568629 -122.390785451805 (37.7502559568629, -122.390785451805)
67796 196439 2 18 1300 Cesar Chavez St 3 1 1 1     1 Width 3ft   6015016.02089 2101171.05558 37.7502592780626 -122.39088346350401 (37.7502592780626, -122.390883463504)
25494 237385 2 18 3100 25th St 1 1 1 1     1 Width 3ft   6008720.74445 2101541.69648 37.750925664000704 -122.412679212271 (37.7509256640007, -122.412679212271)
40351 237387 2 18 3100 25th St 6 1 1 1     1 Width 3ft   6008814.668380001 2101545.8698 37.7509423940946 -122.412354708115 (37.7509423940946, -122.412354708115)
33402 237389 2 18 3100 25th St 8 1 1 1     1 Width 3ft   6008835.28321 2101547.20536 37.750947218045795 -122.412283514173 (37.7509472180458, -122.412283514173)
57522 237388 2 18 3100 25th St 7 1 1 1     1 Width 3ft   6008822.57979 2101547.7181599997 37.7509479132318 -122.41232748022699 (37.7509479132318, -122.412327480227)
146631 237390 2 18 3100 25th St 10 1 1 1     1 Width 3ft   6008886.46543 2101550.71699 37.750959732103 -122.412106768613 (37.750959732103, -122.412106768613)
73413 239403 2 18 338 Hoffman Ave 10 9 1 1     1 Width 3ft   6000617.55151 2101735.06623 37.7509984830156 -122.440714623806 (37.7509984830156, -122.440714623806)
153480 239402 2 18 338 Hoffman Ave 9 9 1 1     1 Width 3ft   6000616.75777 2101741.19606 37.7510152688496 -122.440717808276 (37.7510152688496, -122.440717808276)
67645 239401 2 18 338 Hoffman Ave 8 9 1 1     1 Width 3ft   6000615.63827 2101746.4158900003 37.7510295374914 -122.440722053988 (37.7510295374914, -122.440722053988)
61617 239399 2 18 338 Hoffman Ave 7 9 1 1     1 Width 3ft   6000615.20196 2101754.98366 37.751053037676 -122.44072417728998 (37.751053037676, -122.44072417729)
165824 239391 2 18 4174 24th St 2 1 1 1     1 Width 3ft   6002067.4671 2101800.93595 37.7512618089847 -122.43570539191299 (37.7512618089847, -122.435705391913)
137230 239388 2 18 4162 24th St 1 1 1 1     1 Width 3ft   6002133.10623 2101804.99651 37.7512766864792 -122.43547869528 (37.7512766864792, -122.43547869528)
26420 237140 2 18 1285 York St 1 1 1 1     1 Width 3ft   6010074.8833099995 2101754.71583 37.7515864768406 -122.40801147007099 (37.7515864768406, -122.408011470071)
23166 26519 1 18 2851 Harrison St 1 1 1 1   12/04/2015 12:00:00 AM 1 1X1 Permit Number 777140 6009004.2746 2101873.01384 37.751851296609296 -122.411722142074 (37.7518512966093, -122.411722142074)
Powered by Datasette · Query took 35.102ms · Data source: data.sfgov.org