sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
170634 38226 1 36 1099 Mississippi St 3 1 1 1   07/21/1998 12:00:00 AM 11   Permit Number 40351 6014262.677019999 2102083.6302 37.752723184838295 -122.393552456191 (37.7527231848383, -122.393552456191)
175253 224019 2 36 1300 San Jose Ave 17 7 1 1     12     6003580.635530001 2095660.4174400002 37.7344871964146 -122.430034698739 (37.7344871964146, -122.430034698739)
176279 224023 2 36 1300 San Jose Ave 24 7 1 1     12     6003511.08148 2095643.96545 37.734438083547104 -122.430273996654 (37.7344380835471, -122.430273996654)
178257 247074 2 36 2401 Castro St 10 7 1 1     25     6002773.69931 2098494.22235 37.7422224380182 -122.43302693833799 (37.7422224380182, -122.433026938338)
178569 176383 2 36 199 Peninsula Ave 1 7 1 1     17     6012515.53938 2087594.1826400002 37.7128409356448 -122.39857773288799 (37.7128409356448, -122.398577732888)
180081 224015 2 36 1000 San Jose Ave 89 7 1 1     21     6005001.605909999 2096940.71634 37.7380829836485 -122.42521300248801 (37.7380829836485, -122.425213002488)
181295 247092 2 36 2301 Castro St 10 7 1 1     3     6002754.09625 2098614.08678 37.742550445936395 -122.43310328180901 (37.7425504459364, -122.433103281809)
181489 247933 2 36 1099 Esmeralda Ave 6 17 1 1     25     6010316.772530001 2098765.05298 37.7433910575536 -122.40696428417601 (37.7433910575536, -122.406964284176)
183147 66382 1 36 661 Fillmore St 1 1 1 1 1 01/04/1991 12:00:00 AM 12   Permit Number 29508 6003420.5252 2110677.1492 37.7757105120941 -122.431660023451 (37.7757105120941, -122.431660023451)
183400 224013 2 36 1000 San Jose Ave 86 7 1 1     16     6005014.2312 2096961.20623 37.738139957502796 -122.42517080809601 (37.7381399575028, -122.425170808096)
188666 224021 2 36 1300 San Jose Ave 20 7 1 1     22     6003548.3510300005 2095664.8984299998 37.734497671711296 -122.430146636467 (37.7344976717113, -122.430146636467)
10605 1293 3 36 4000X Alemany Blvd 1 11 1 2     50 10   5991961.87152 2087160.6390900002 37.7104840184951 -122.46958569253701 (37.7104840184951, -122.469585692537)
12006 1294 3 36 4000X Alemany Blvd 2 11 1 2     25 10   5991953.08243 2087152.92109 37.7104623187479 -122.469615507754 (37.7104623187479, -122.469615507754)
16272 107070 2 36 400X Mariposa St 2 1 1 1   10/01/2014 12:00:00 AM 3 20x6 Permit Number 773144 6015880.83246 2106317.74548 37.7644389427302 -122.388252013943 (37.7644389427302, -122.388252013943)
18226 4848 3 36 229 Cortland Ave 1 1 1 2     32 2x3   6006739.96805 2097466.29285 37.7396241527309 -122.419239878116 (37.7396241527309, -122.419239878116)
6636 2588 3 36 1710 Bush St 1 1 1 2   07/12/1999 12:00:00 AM 18 3   6005206.687000001 2115142.0135 37.788071009916 -122.42579911500499 (37.788071009916, -122.425799115005)
1068 11520 3 36 101X Jennings St 10 1 1 2   05/01/2017 12:00:00 AM 6 3X3   6018495.90717 2096693.85175 37.738158246093 -122.378538834904 (37.738158246093, -122.378538834904)
1843 9890 3 36 1700 Gough St 2 1 1 2     24 3X3   6005344.337040001 2115550.48459 37.7892003471598 -122.42535194865299 (37.7892003471598, -122.425351948653)
3956 15038 3 36 1017 Mendell St 1 1 1 2     30 3X3   6015648.0 2096190.0 37.7366173719863 -122.388350408836 (37.7366173719863, -122.388350408836)
6238 8189 3 36 1279 Fulton St 1 1 1 2     18 3X3   6001660.1742 2111123.4233 37.7768359307235 -122.437781474603 (37.7768359307235, -122.437781474603)
6681 10654 3 36 930 Hayes St 2 1 1 2     18 3X3   6003365.9666 2110715.3678 37.7758123582585 -122.431851484644 (37.7758123582585, -122.431851484644)
7002 5239 3 36 1100 Divisadero St 8 1 1 2     12 3X3   6001407.3425 2112393.2913 37.780308287354295 -122.438747110907 (37.7803082873543, -122.438747110907)
7110 10652 1 36 931 Hayes St 1 1 1 1     18 3X3   6003404.4622 2110674.9336 37.775703518104 -122.431715431116 (37.775703518104, -122.431715431116)
7531 8183 3 36 1216 Fulton St 2 1 1 2     100 3X3   6001748.9425 2111188.325 37.777019181607706 -122.437479047598 (37.7770191816077, -122.437479047598)
7855 10655 1 36 937 Hayes St 1 1 1 1     18 3X3   6003345.7495 2110667.1791 37.775678897926 -122.43191797899799 (37.775678897926, -122.431917978998)
7947 2629 1 36 1872 Bush St 1 1 1 1     12 3X3   6004578.2934 2115053.5876 37.787792683911 -122.427966943787 (37.787792683911, -122.427966943787)
8329 8190 3 36 1280 Fulton St 1 1 1 2     100 3X3   6001658.902000001 2111173.1154 37.7769723003903 -122.437789435412 (37.7769723003903, -122.437789435412)
8867 10653 3 36 930 Hayes St 1 1 1 2     18 3X3   6003401.4158 2110719.799 37.775826534714106 -122.43172917338 (37.7758265347141, -122.43172917338)
9234 4832 1 36 104X CORTLAND AVE 1 1 1 1     48 3X3   6006272.0 2097672.0 37.7401626122958 -122.420872513823 (37.7401626122958, -122.420872513823)
9298 17755 1 36 1634 Pine St 5 1 1 1     18 3X3   6005983.055346799 2115593.0882202997 37.789353391125104 -122.42314508816901 (37.7893533911251, -122.423145088169)
9377 17756 1 36 1634 Pine St 6 1 1 1     18 3X3   6005973.81147 2115593.81965 37.7893548777914 -122.423177122971 (37.7893548777914, -122.423177122971)
9401 4822 1 36 60 Cortland Ave 2 1 1 1     75 3X3   6006061.0289274 2097780.9763268996 37.7404499429552 -122.421609705422 (37.7404499429552, -122.421609705422)
13431 11527 3 36 101X Jennings St 17 1 1 2     12 3X3   6018609.30332 2096848.22468 37.738588373848295 -122.378157476493 (37.7385883738483, -122.378157476493)
13473 11540 3 36 101X Jennings St 30 1 1 2     18 3X3   6018782.49291 2097080.98118 37.7392370206652 -122.37757481115 (37.7392370206652, -122.37757481115)
13479 22442 1 36 6025 03rd St 6 1 1 1     24 3X3   6013654.8805 2091521.7057 37.7236885437418 -122.394914674123 (37.7236885437418, -122.394914674123)
13488 3672 1 36 100X Cargo Way 108 1 1 9     18 3X3   6017032.375109999 2098991.89434 37.7443874218329 -122.383759005485 (37.7443874218329, -122.383759005485)
13507 11536 3 36 101X Jennings St 26 1 1 2     18 3X3   6018721.15121 2096997.58655 37.739004655647 -122.377781119206 (37.739004655647, -122.377781119206)
13546 11531 3 36 101X Jennings St 21 1 1 2     18 3X3   6018661.768080001 2096921.7146599998 37.7387930541475 -122.37798117610501 (37.7387930541475, -122.377981176105)
13576 3696 3 36 401X Cargo Way 1 1 1 2     18 3X3   6016376.57655 2099377.09307 37.7454088259626 -122.386053488085 (37.7454088259626, -122.386053488085)
13710 3708 1 36 401X Cargo Way 13 1 1 1     18 3X3   6016594.5506 2099214.51013 37.744974467789504 -122.385288434823 (37.7449744677895, -122.385288434823)
13776 3680 1 36 100X Cargo Way 116 1 1 9     18 3X3   6016866.69606 2099115.15257 37.7447167041098 -122.384340477447 (37.7447167041098, -122.384340477447)
13810 11546 3 36 101X Jennings St 36 1 1 2     18 3X3   6018856.19666 2097185.73418 37.7395287121888 -122.37732724037701 (37.7395287121888, -122.377327240377)
13853 11518 3 36 101X Jennings St 8 1 1 2     18 3X3   6018467.96004 2096661.77747 37.7380686358665 -122.37863323672899 (37.7380686358665, -122.378633236729)
13880 3671 1 36 100X Cargo Way 107 1 1 9     18 3X3   6017047.36981 2098978.83891 37.7443524031345 -122.38370624765 (37.7443524031345, -122.38370624765)
13907 3714 3 36 401X Cargo Way 19 1 1 2     18 3X3   6016696.4691699995 2099138.87958 37.744772439592204 -122.384930747455 (37.7447724395922, -122.384930747455)
13958 3709 3 36 401X Cargo Way 14 1 1 2     12 3X3   6016611.7626 2099202.9223 37.7449436021699 -122.38522811100201 (37.7449436021699, -122.385228111002)
13998 11516 3 36 101X Jennings St 6 1 1 2     18 3X3   6018445.80461 2096632.24283 37.737986318204605 -122.378707789643 (37.7379863182046, -122.378707789643)
14283 11524 3 36 101X Jennings St 14 1 1 2     18 3X3   6018572.85172 2096797.82035 37.7384479645089 -122.378280011831 (37.7384479645089, -122.378280011831)
14381 3679 1 36 100X Cargo Way 115 1 1 9     12 3X3   6016884.1224 2099103.28613 37.744685084848896 -122.384279393677 (37.7446850848489, -122.384279393677)
14511 11548 3 36 101X Jennings St 38 1 1 2     12 3X3   6018882.85871 2097216.8887400003 37.7396157251883 -122.377237214629 (37.7396157251883, -122.377237214629)
14535 3713 3 36 401X Cargo Way 18 1 1 2     18 3X3   6016679.4743 2099151.07612 37.7448049887681 -122.384990362612 (37.7448049887681, -122.384990362612)
14593 3718 3 36 401X Cargo Way 23 1 1 2     18 3X3   6016837.584419999 2099032.41565 37.7444879156766 -122.384435379316 (37.7444879156766, -122.384435379316)
14596 3733 3 36 401X Cargo Way 38 1 1 2     18 3X3   6017103.99643 2098828.8007400003 37.743943558756705 -122.38349999984501 (37.7439435587567, -122.383499999845)
14617 11525 3 36 101X Jennings St 15 1 1 2     18 3X3   6018584.76615 2096814.86638 37.7384954262103 -122.37824000008499 (37.7384954262103, -122.378240000085)
14633 11522 3 36 101X Jennings St 12 1 1 2     18 3X3   6018545.03968 2096763.4476400001 37.738352050906 -122.37837378772801 (37.738352050906, -122.378373787728)
14692 3717 3 36 401X Cargo Way 22 1 1 2     18 3X3   6016818.97287 2099045.87092 37.7445238319196 -122.384500671891 (37.7445238319196, -122.384500671891)
14711 11538 3 36 101X Jennings St 28 1 1 2     18 3X3   6018744.95776 2097030.5986900001 37.7390966122121 -122.377701096637 (37.7390966122121, -122.377701096637)
14717 3720 3 36 401X Cargo Way 25 1 1 2     18 3X3   6016885.74999 2098998.54038 37.7443975643918 -122.38426647223999 (37.7443975643918, -122.38426647224)
14752 3664 1 36 100X Cargo Way 100 1 1 9   03/07/2006 12:00:00 AM 3 3X3   6017168.62408 2098888.98032 37.744112371380204 -122.383280718132 (37.7441123713802, -122.383280718132)
14775 11542 3 36 101X Jennings St 32 1 1 2     18 3X3   6018808.16459 2097116.8368799998 37.739336887696396 -122.377488536484 (37.7393368876964, -122.377488536484)
14867 3710 3 36 401X Cargo Way 15 1 1 2   04/01/1990 12:00:00 AM 12 3X3   6016627.8913900005 2099188.4950200003 37.7449048800496 -122.385171335 (37.7449048800496, -122.385171335)
14940 26805 3 36 1491 McKinnon Ave 2 1 1 2     18 3X3   6015969.8239 2095448.3954 37.734598903014295 -122.38718600253901 (37.7345989030143, -122.387186002539)
14990 3727 3 36 401X Cargo Way 32 1 1 2     18 3X3   6017002.99503 2098909.3169299997 37.7441590569979 -122.383854848043 (37.7441590569979, -122.383854848043)
15014 11529 3 36 101X Jennings St 19 1 1 2     18 3X3   6018637.527419999 2096885.1095 37.7386912077413 -122.37806244962401 (37.7386912077413, -122.378062449624)
15019 11534 3 36 101X Jennings St 24 1 1 2     18 3X3   6018698.318659999 2096968.53923 37.7389236393092 -122.37785804901002 (37.7389236393092, -122.37785804901)
15189 3712 3 36 401X Cargo Way 17 1 1 2     18 3X3   6016661.27341 2099164.52322 37.7448409049843 -122.385054235166 (37.7448409049843, -122.385054235166)
15190 3701 3 36 401X Cargo Way 6 1 1 2   06/12/2000 12:00:00 AM 3 3X3   6016463.92851 2099311.9747200003 37.745234858406 -122.385746898422 (37.745234858406, -122.385746898422)
15231 11541 3 36 101X Jennings St 31 1 1 2     18 3X3   6018795.49875 2097098.36536 37.7392854707446 -122.377531048337 (37.7392854707446, -122.377531048337)
15280 3725 3 36 401X Cargo Way 30 1 1 2     18 3X3   6016971.06909 2098934.28119 37.7442258388522 -122.383966980005 (37.7442258388522, -122.383966980005)
15289 22103 3 36 3550 03rd St 3 1 1 2     12 3X3   6015999.32561 2099148.4464 37.7447601233736 -122.387342025935 (37.7447601233736, -122.387342025935)
15305 3683 1 36 100X Cargo Way 119 1 1 9     18 3X3   6016838.589430001 2099135.269 37.7447703855426 -122.384439066524 (37.7447703855426, -122.384439066524)
15306 22434 3 36 6000 03rd St 3 1 1 2     18 3X3   6013550.0151 2091475.3264 37.7235553639507 -122.395273931127 (37.7235553639507, -122.395273931127)
15310 3668 1 36 100X Cargo Way 104 1 1 9     12 3X3   6017100.61527 2098941.7519 37.7442535127858 -122.38351955288 (37.7442535127858, -122.38351955288)
15313 22105 3 36 3550 03rd St 5 1 1 2     18 3X3   6015990.42325 2099120.8516599997 37.7446838608656 -122.38737088427 (37.7446838608656, -122.38737088427)
15340 3684 1 36 100X Cargo Way 120 1 1 9     18 3X3   6016817.82171 2099151.7639099997 37.744814528777795 -122.384512026728 (37.7448145287778, -122.384512026728)
15381 3665 1 36 100X Cargo Way 101 1 1 9     18 3X3   6017153.34624 2098900.7145700003 37.74414374693129 -122.383334362693 (37.7441437469313, -122.383334362693)
15426 3670 1 36 100X Cargo Way 106 1 1 9     18 3X3   6017067.53558 2098965.3092900002 37.744316368207706 -122.383635576218 (37.7443163682077, -122.383635576218)
15456 3728 3 36 401X Cargo Way 33 1 1 2     12 3X3   6017021.23739 2098897.913 37.744128752548704 -122.383790975489 (37.7441287525487, -122.383790975489)
15457 3729 3 36 401X Cargo Way 34 1 1 2     18 3X3   6017037.38715 2098884.5074400003 37.744092836325 -122.38373419946998 (37.744092836325, -122.38373419947)
15479 11521 3 36 101X Jennings St 11 1 1 2     18 3X3   6018533.508280001 2096747.4741099998 37.738307555143706 -122.378412549408 (37.7383075551437, -122.378412549408)
15508 11512 3 36 101X Jennings St 2 1 1 2     12 3X3   6018400.60741 2096569.54507 37.7378116707805 -122.378859707612 (37.7378116707805, -122.378859707612)
15523 26807 3 36 1487 McKinnon Ave 1 1 1 2     18 3X3   6015996.3267 2095429.905 37.7345495997276 -122.38709308337098 (37.7345495997276, -122.387093083371)
15591 11533 3 36 101X Jennings St 23 1 1 2     18 3X3   6018685.57005 2096950.68125 37.738873902319 -122.377900889128 (37.738873902319, -122.377900889128)
15631 3715 3 36 401X Cargo Way 20 1 1 2   06/07/1996 12:00:00 AM 3 3X3   6016713.472019999 2099127.09165 37.744741012786896 -122.38487113321699 (37.7447410127869, -122.384871133217)
15648 3722 3 36 401X Cargo Way 27 1 1 2     18 3X3   6016920.12543 2098972.91356 37.7443290989992 -122.384145823682 (37.7443290989992, -122.384145823682)
15661 11532 3 36 101X Jennings St 22 1 1 2     18 3X3   6018674.73047 2096936.9392900001 37.738835572289794 -122.377937414197 (37.7388355722898, -122.377937414197)
15740 11517 3 36 101X Jennings St 7 1 1 2     18 3X3   6018459.10272 2096646.1554299998 37.738025252555 -122.37866277678499 (37.738025252555, -122.378662776785)
15758 22102 3 36 3550 03rd St 2 1 1 2     12 3X3   6016009.792669999 2099202.98145 37.744910445068896 -122.387309635952 (37.7449104450689, -122.387309635952)
15773 3675 1 36 100X Cargo Way 111 1 1 9   03/07/2006 12:00:00 AM 3 3X3   6016978.81066 2099030.1280400003 37.74448944274229 -122.383946883753 (37.7444894427423, -122.383946883753)
15806 11530 3 36 101X Jennings St 20 1 1 2     18 3X3   6018648.41512 2096905.05742 37.7387465808009 -122.37802618897 (37.7387465808009, -122.37802618897)
15917 11515 3 36 101X Jennings St 5 1 1 2     18 3X3   6018435.759869999 2096618.26492 37.7379473838671 -122.378741549297 (37.7379473838671, -122.378741549297)
15985 11549 3 36 101X Jennings St 39 1 1 2     18 3X3   6018893.31945 2097233.60379 37.7396621976446 -122.37720220492399 (37.7396621976446, -122.377202204924)
15997 3723 3 36 401X Cargo Way 28 1 1 2     18 3X3   6016936.70179 2098960.3168599997 37.744295427497704 -122.384087628549 (37.7442954274977, -122.384087628549)
16000 3730 3 36 401X Cargo Way 35 1 1 2     12 3X3   6017054.36564 2098871.4939599996 37.744058042453496 -122.383674585207 (37.7440580424535, -122.383674585207)
16127 3731 3 36 401X Cargo Way 36 1 1 2     18 3X3   6017071.75465 2098858.47223 37.74402324858939 -122.383613550927 (37.7440232485894, -122.383613550927)
16170 3716 3 36 401X Cargo Way 21 1 1 2     18 3X3   6016802.38016 2099057.65052 37.744555258722 -122.38455886702299 (37.744555258722, -122.384558867023)
16319 26014 1 36 1634 Oakdale Ave 1 1 1 1   03/19/2004 12:00:00 AM 3 3X3   6014769.7753099995 2095716.92157 37.735269692036205 -122.39135377296002 (37.7352696920362, -122.39135377296)
16379 11537 3 36 101X Jennings St 27 1 1 2     18 3X3   6018733.38325 2097012.4655799998 37.7390461845215 -122.37773985832399 (37.7390461845215, -122.377739858324)
16384 11539 3 36 101X Jennings St 29 1 1 2     18 3X3   6018768.44621 2097065.7782599998 37.739194502529294 -122.37762232410601 (37.7391945025293, -122.377622324106)
16435 3724 3 36 401X Cargo Way 29 1 1 2     18 3X3   6016958.14867 2098944.9648700003 37.7442544597685 -122.38401240026501 (37.7442544597685, -122.384012400265)
16445 3669 1 36 100X Cargo Way 105 1 1 9     17 3X3   6017084.9315599995 2098953.56707 37.7442850879842 -122.383574606702 (37.7442850879842, -122.383574606702)
Powered by Datasette · Query took 5.006ms · Data source: data.sfgov.org