sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
14729 19657 3 36 100 STAIRWAY5 56 1 1 2     18 60ST            
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)
15686 19660 3 36 100 STAIRWAY5 59 1 1 2     18 60ST            
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)
15843 107072 2 36 400X Mariposa St 4 1 1 1   10/01/2014 12:00:00 AM 3 50x5 Permit Number 773144 6015855.633230001 2106318.50292 37.7644396262057 -122.388339224777 (37.7644396262057, -122.388339224777)
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)
16120 19653 3 36 100 STAIRWAY5 52 1 1 2     12 60ST            
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)
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)
16316 107069 2 36 400X Mariposa St 1 1 1 1   10/01/2014 12:00:00 AM 3 8x8 Permit Number 773144 6015928.73625 2106322.43558 37.764454474908 -122.388086653778 (37.764454474908, -122.388086653778)
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)
16471 22104 3 36 3550 03rd St 4 1 1 2     18 3X3   6015995.55908 2099134.0934900003 37.74472050464 -122.387354048955 (37.74472050464, -122.387354048955)
16472 11547 3 36 101X Jennings St 37 1 1 2     18 3X3   6018868.04549 2097199.54045 37.7395672742039 -122.377287229525 (37.7395672742039, -122.377287229525)
16519 3732 3 36 401X Cargo Way 37 1 1 2     18 3X3   6017092.791180001 2098843.12861 37.7439822808577 -122.383539742673 (37.7439822808577, -122.383539742673)
16584 3719 3 36 401X Cargo Way 24 1 1 2     12 3X3   6016852.7534 2099021.2782 37.744458173299996 -122.38438215201799 (37.7444581733, -122.384382152018)
16591 3678 1 36 100X Cargo Way 114 1 1 9     18 3X3   6016900.5532599995 2099090.71493 37.7446514753884 -122.384221703094 (37.7446514753884, -122.384221703094)
16643 3702 3 36 401X Cargo Way 7 1 1 2   03/14/1990 12:00:00 AM 12 3X3   6016478.46508 2099300.03196 37.7452028704157 -122.385695800734 (37.7452028704157, -122.385695800734)
16658 22427 3 36 5919 03rd St 2 1 1 2     18 3X3   6013743.1817 2091759.1378 37.724345394142 -122.39462604842699 (37.724345394142, -122.394626048427)
16711 11513 3 36 101X Jennings St 3 1 1 2     12 3X3   6018414.43418 2096589.52395 37.7378672911411 -122.378813288221 (37.7378672911411, -122.378813288221)
16734 11519 3 36 101X Jennings St 9 1 1 2     18 3X3   6018482.73466 2096678.8993400002 37.7381164636019 -122.378583341463 (37.7381164636019, -122.378583341463)
16743 3677 1 36 100X Cargo Way 113 1 1 9   03/07/2006 12:00:00 AM 3 3x3   6016945.8178 2099054.7063700003 37.7445551058345 -122.38406267865801 (37.7445551058345, -122.384062678658)
16820 11511 3 36 101X Jennings St 1 1 1 2     18 5   6018385.91854 2096547.1526 37.7377493756286 -122.378908940096 (37.7377493756286, -122.378908940096)
16854 11488 3 36 100 Jennings St 2 1 1 2   01/05/1993 12:00:00 AM 6 4X4   6018872.157000001 2097296.32677 37.7398332567899 -122.377279727371 (37.7398332567899, -122.377279727371)
16927 24534 3 36 128 Cortland Ave 1 1 1 2   04/11/1996 12:00:00 AM 8 3X3   6006387.02802 2097608.2195099997 37.7399939683457 -122.420470266705 (37.7399939683457, -122.420470266705)
16934 4202 3 36 3902 Cesar Chavez St 1 1 1 2     18 3X3   6004480.6649 2100468.03712 37.7477387553393 -122.427265346224 (37.7477387553393, -122.427265346224)
17259 4834 3 36 108 Cortland Ave 1 1 1 2     30 5x5   6006318.50135 2097642.9115299997 37.7400853628581 -122.420709666225 (37.7400853628581, -122.420709666225)
17352 16120 3 36 303 Monterey Blvd 1 1 1 2     18 3x3   6000032.3049 2094633.40383 37.7314656586952 -122.44222871430401 (37.7314656586952, -122.442228714304)
17573 16029 3 36 146 Monterey Blvd 1 1 1 2     12 3X3   6001109.44487 2094693.26414 37.7316913516547 -122.43850913181002 (37.7316913516547, -122.43850913181)
17697 4413 3 36 1108 Church St 1 1 1 2     28 6x9   6004403.04195 2102416.52833 37.753084468576205 -122.427672567341 (37.7530844685762, -122.427672567341)
17950 4408 1 36 1091 Church St 1 1 1 1     18 4x4   6004454.91155 2102571.21825 37.7535121447905 -122.42750421154301 (37.7535121447905, -122.427504211543)
18215 4462 3 36 1454 Church St 1 1 1 2     18 4X4   6004517.68898 2100379.8296 37.7474986516535 -122.42713103697099 (37.7474986516535, -122.427131036971)
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)
18235 4828 3 36 85 Cortland Ave 1 1 1 2     25 3X3   6006188.87424 2097766.1175 37.740416352027204 -122.421166610858 (37.7404163520272, -122.421166610858)
18348 16020 3 36 107 Monterey Blvd 1 1 1 2     18 3x3   6001336.16248 2094611.17288 37.731478841871706 -122.437719447913 (37.7314788418717, -122.437719447913)
18512 4810 3 36 20 Cortland Ave 1 1 1 2     40 3X3   6005841.28363 2097904.31782 37.7407762175496 -122.42237826114099 (37.7407762175496, -122.422378261141)
18582 4840 3 36 138 Cortland Ave 1 1 1 2     65 3X3   6006436.16175 2097581.71528 37.7399239624285 -122.42029850157499 (37.7399239624285, -122.420298501575)
18729 4825 1 36 72 Cortland Ave 1 1 1 1     80 3X3   6006134.02134 2097745.6697400003 37.7403571145946 -122.421354819194 (37.7403571145946, -122.421354819194)
18780 16006 1 36 95 Monterey Blvd 1 1 1 1     18 3x3   6001386.18936 2094608.8979 37.7314754397255 -122.43754633291799 (37.7314754397255, -122.437546332918)
18996 28137 3 36 418 Eugenia Ave 1 1 1 2     40 4X5   6006961.256569999 2097891.09385 37.740803021841295 -122.418504870321 (37.7408030218413, -122.418504870321)
19096 4431 3 36 1195 Church St 1 1 1 2     18 3X3   6004486.69317 2101949.49973 37.7518068485257 -122.427350018309 (37.7518068485257, -122.427350018309)
19295 5760 3 36 398 Duboce Ave 2 1 1 2     36 3x3   6003950.51884 2108401.53413 37.7694922566853 -122.42966430666999 (37.7694922566853, -122.42966430667)
19493 4411 1 36 1101 Church St 1 1 1 1     18 4X4   6004460.022890001 2102441.95426 37.7531575052231 -122.42747732723801 (37.7531575052231, -122.427477327238)
19540 4835 3 36 115 Cortland Ave 1 1 1 2     24 3x3   6006362.63783 2097667.32197 37.7401548759573 -122.420558792379 (37.7401548759573, -122.420558792379)
19938 16038 3 36 163 Monterey Blvd 1 1 1 2     12 3X3   6000989.84379 2094618.6563099998 37.7314796917131 -122.43891727113301 (37.7314796917131, -122.438917271133)
20001 4839 3 36 135 Cortland Ave 1 1 1 2     18 3x3   6006426.94909 2097635.5595299997 37.7400712875725 -122.42033417588699 (37.7400712875725, -122.420334175887)
20016 16033 1 36 159 Monterey Blvd 1 1 1 1     18 3X4   6001012.52549 2094617.56697 37.7314779911003 -122.438838778307 (37.7314779911003, -122.438838778307)
20112 29963 3 36 500X Junipero Serra Blvd 6 11 1 2   03/09/2013 12:00:00 AM 3 3x3   5991394.8537099995 2093447.95886 37.7277146673841 -122.47200336878099 (37.7277146673841, -122.472003368781)
20184 16030 3 36 147 Monterey Blvd 1 1 1 2     24 3X3   6001102.99289 2094615.6926099998 37.731477991115796 -122.438525881668 (37.7314779911158, -122.438525881668)
20202 5091 3 36 2600 Diamond St 1 1 1 2     18 3X3   6002242.42307 2096653.9998400002 37.7371394644141 -122.434732362321 (37.7371394644141, -122.434732362321)
20228 4824 3 36 73 Cortland Ave 1 1 1 2     18 3X3   6006137.31563 2097787.40171 37.740471886955 -122.42134639164301 (37.740471886955, -122.421346391643)
20730 4823 3 36 66 Cortland Ave 1 1 1 2     28 3X3   6006092.06915 2097770.47064 37.74042284693579 -122.421501634396 (37.7404228469358, -122.421501634396)
21184 4827 3 36 80 Cortland Ave 1 1 1 2     80 3X3   6006160.77573 2097729.74879 37.74031490761921 -122.421261182679 (37.7403149076192, -122.421261182679)
21191 4812 3 36 28 Cortland Ave 1 1 1 2     46 3X3   6005885.45019 2097879.1399 37.7407095759957 -122.422223761224 (37.7407095759957, -122.422223761224)
21392 4831 1 36 101 Cortland Ave 1 1 1 1     12 3x3   6006324.12928 2097690.18327 37.74021547767221 -122.420693562078 (37.7402154776722, -122.420693562078)
21443 4396 3 36 1005 Church St 1 1 1 2     12 3x3   6004431.4266800005 2103008.65854 37.754711924921295 -122.427616590837 (37.7547119249213, -122.427616590837)
21637 4817 3 36 51 Cortland Ave 1 1 1 2     12 3x3   6005995.99863 2097868.77885 37.7406873618291 -122.42184079032499 (37.7406873618291, -122.421840790325)
21650 1996 3 36 175 Bocana St 1 1 1 2     40 3x3   6007331.5108 2098053.7261799998 37.741270411207296 -122.41723618861201 (37.7412704112073, -122.417236188612)
21920 4841 3 36 142 Cortland Ave 1 1 1 2     18 6x9   6006480.033919999 2097559.50493 37.7398654498357 -122.420145233727 (37.7398654498357, -122.420145233727)
Powered by Datasette · Query took 2.81ms · Data source: data.sfgov.org