sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
94759 47444 1 16 651 43rd Ave 2 1 1 1   05/14/2002 12:00:00 AM     Permit Number 45354 5982550.9590229 2111342.50779778 37.7763323565324 -122.503901138971 (37.7763323565324, -122.503901138971)
55330 37078 1 16 1318 44th Ave 1 1 1 1 1 04/20/2002 12:00:00 AM 2   Permit Number 39680 5982466.3981 2106106.9098 37.761951943280394 -122.50380580728 (37.7619519432804, -122.50380580728)
136410 82431 1 18 650 43rd Ave 1 1 1 1   07/22/2009 12:00:00 AM 1 3x3 Permit Number 52680 5982600.56645 2111346.95635 37.7763474878375 -122.503729865488 (37.7763474878375, -122.503729865488)
166287 55604 1 16 658 43rd Ave 1 1 1 1   01/08/1973 12:00:00 AM 1   Permit Number 773340 5982601.78539 2111293.4380900003 37.7762006139918 -122.50372168450501 (37.7762006139918, -122.503721684505)
61940 92237 1 18 710 43rd Ave 1 1 1 1   07/22/2009 12:00:00 AM 3 3x3 Permit Number 52681 5982614.54862 2110914.94505 37.7751621329201 -122.503649497706 (37.7751621329201, -122.503649497706)
171448 83913 1 16 1659 44th Ave 1 1 1 1   01/23/2008 12:00:00 AM 1 3x3 Permit Number 50155 5982499.5096 2103826.5104 37.7556925599446 -122.503522416925 (37.7556925599446, -122.503522416925)
54349 79894 2 16 4119 Clement St 1 1 1 1 1 10/20/2001 12:00:00 AM 7     5982716.5012300005 2113074.1195 37.78109658773229 -122.503456745272 (37.7810965877323, -122.503456745272)
67159 92236 1 16 551 42nd Ave 1 1 1 1   07/22/2009 12:00:00 AM 2 3x3 Permit Number 52679 5982837.48707 2112035.40062 37.7782516820937 -122.502961282193 (37.7782516820937, -122.502961282193)
57130 92234 1 18 530 42nd Ave 1 1 1 1 1 07/22/2009 12:00:00 AM 4 3x3 Permit Number 52677 5982879.44866 2112163.93194 37.778607057674996 -122.50282564106199 (37.778607057675, -122.502825641062)
155742 40221 1 16 1463 43rd Ave 1 1 1 1   05/06/1999 12:00:00 AM 4   Permit Number 41400 5982763.9993 2105167.6847 37.7593905919599 -122.502707013206 (37.7593905919599, -122.502707013206)
171006 72283 2 16 779 42nd Ave 1 1 1 1 1 01/20/1996 12:00:00 AM 4     5982894.68666 2110493.65125 37.774021849099704 -122.502649263154 (37.7740218490997, -122.502649263154)
171943 184308 2 16 1555 43rd Ave 1 1 1 1     1 Width 0ft   5982786.0012 2104528.3348 37.7576364108681 -122.502583598561 (37.7576364108681, -122.502583598561)
30074 47440 1 18 859 42nd Ave 1 1 1 1 1 05/14/2002 12:00:00 AM 5   Permit Number 45351 5982914.18523 2109947.95579 37.7725246733221 -122.50254141771099 (37.7725246733221, -122.502541417711)
70691 184573 2 16 1731 43rd Ave 1 1 1 1     2 Width 0ft   5982827.3086 2103329.3402 37.754346736395995 -122.502352009826 (37.754346736396, -122.502352009826)
26539 184576 2 16 1735 43rd Ave 1 1 1 1     2 Width 0ft   5982829.6776 2103308.6964 37.75429019350779 -122.50234228965799 (37.7542901935078, -122.502342289658)
24589 184585 2 16 1743 43rd Ave 1 1 1 1     1 Width 0ft   5982830.016 2103255.9026 37.754145256427606 -122.50233721253099 (37.7541452564276, -122.502337212531)
157734 46392 1 35 2474 44th Ave 2 1 1 1 1 03/05/2002 12:00:00 AM 1   Permit Number 44624 5982733.0582 2098295.9927 37.7405210225717 -122.502305471655 (37.7405210225717, -122.502305471655)
102609 89562 3 16 5027 Anza St 1 1 1 2   03/27/2008 12:00:00 AM 3 3x3   5983024.08969 2111679.84197 37.7772863874511 -122.50228944566099 (37.7772863874511, -122.502289445661)
102770 96076 1 18 411 41st Ave 2 1 1 1 1     3x3 Permit Number 767701 5983098.7 2113007.7 37.780936680817206 -122.502129633812 (37.7809366808172, -122.502129633812)
175243 96075 1 18 411 41st Ave 1 1 1 1 1 07/28/2011 12:00:00 AM 3 3x3 Permit Number 767701 5983103.04582 2113013.19289 37.7809520179972 -122.50211500631399 (37.7809520179972, -122.502115006314)
119284 116071 3 84 4150X CLEMENT ST 1 7 1 2     8 3x3   5983115.0 2113126.0 37.7812624555251 -122.502082001527 (37.7812624555251, -122.502082001527)
109056 51769 1 35 3638 Lawton St 4 1 1 1 1 07/30/2009 12:00:00 AM 1 3x3 Permit Number 52851 5982925.7859 2104266.232 37.7569249636711 -122.50208077934201 (37.7569249636711, -122.502080779342)
153533 117710 2 18 477 41st Ave 1 9 1 1     5 Width 8ft   5983117.17834 2112671.33055 37.7800141944428 -122.502040811752 (37.7800141944428, -122.502040811752)
40255 51768 1 35 3638 Lawton St 3 1 1 1 1 07/30/2009 12:00:00 AM 1 3x3 Permit Number 52851 5982945.3427 2104265.0097 37.756922756494106 -122.50201305526699 (37.7569227564941, -122.502013055267)
186101 51766 1 35 3638 Lawton St 2 1 1 1   06/28/2005 12:00:00 AM 1   Permit Number 48032 5982963.9827 2104265.9264 37.7569263685127 -122.50194866004801 (37.7569263685127, -122.501948660048)
185728 51437 1 16 535 41st Ave 1 1 1 1   10/19/2004 12:00:00 AM 2   Permit Number 47757 5983145.9728 2112126.6615400002 37.7785203841092 -122.501900888351 (37.7785203841092, -122.501900888351)
167545 51767 1 35 3638 Lawton St 1 1 1 1   06/28/2005 12:00:00 AM 1   Permit Number 48032 5982982.0116 2104266.5376 37.756929105781495 -122.501886355597 (37.7569291057815, -122.501886355597)
136211 183297 2 35 1279 42nd Ave 1 1 1 1     11 Width 0ft   5983033.5705 2106401.2294 37.762793394201005 -122.501865989484 (37.762793394201, -122.501865989484)
132519 47430 1 16 651 41st Ave 1 1 1 1 1 05/14/2002 12:00:00 AM 5   Permit Number 45341 5983172.9702 2111364.55723 37.776429453588 -122.501751096095 (37.776429453588, -122.501751096095)
189079 117920 2 198 727 41st Ave 1 1 1 1     10 Width 3ft   5983191.607000001 2110832.41366 37.7749694365706 -122.501647249063 (37.7749694365706, -122.501647249063)
106043 89022 1 16 801 41st Ave 1 1 1 1   10/01/2008 12:00:00 AM   3x3 Permit Number 51767 5983196.2 2110303.4 37.7735171880717 -122.501592216483 (37.7735171880717, -122.501592216483)
50531 96079 1 18 664 41st Ave 1 1 1 1 1 07/28/2011 12:00:00 AM 1 3x3 Permit Number 767703 5983226.11153 2111277.81973 37.7761944189321 -122.501560849986 (37.7761944189321, -122.501560849986)
60980 70441 2 35 2443 43rd Ave 1 1 1 1 1 06/11/1994 12:00:00 AM 2     5982992.9824 2098498.3633 37.741091945342795 -122.501421735716 (37.7410919453428, -122.501421735716)
135433 96081 1 18 790 41st Ave 2 1 1 1 1 07/28/2011 12:00:00 AM 1 3x3 Permit Number 767704 5983251.84023 2110453.37841 37.773932253218 -122.501410848383 (37.773932253218, -122.501410848383)
23887 83255 2 18 790 41st Ave 1 1 1 1 1   1     5983253.61867 2110435.38712 37.773882958787205 -122.501403365431 (37.7738829587872, -122.501403365431)
94281 96080 1 18 790 41st Ave 1 1 1 1 1 07/28/2011 12:00:00 AM   3x3 Permit Number 767704 5983278.4 2110433.5 37.7738792326413 -122.501317504516 (37.7738792326413, -122.501317504516)
175787 49394 1 16 868 41st Ave 1 1 1 1   03/18/2003 12:00:00 AM 4   Permit Number 46347 5983274.10488 2109909.62702 37.7724405765784 -122.50129360387301 (37.7724405765784, -122.501293603873)
45057 70451 2 16 2683 43rd Ave 1 1 1 1 1 06/11/1994 12:00:00 AM 4     5983041.4986 2096885.6865 37.7366668238827 -122.5011347377 (37.7366668238827, -122.5011347377)
51315 34818 1 35 443 40th Ave 2 1 1 1 1 07/29/1997 12:00:00 AM     Permit Number 38451 5983428.96299375 2112819.28622042 37.780438749009704 -122.500973171264 (37.7804387490097, -122.500973171264)
139180 34817 1 35 443 40th Ave 1 1 1 1 1 07/29/1997 12:00:00 AM     Permit Number 38451 5983428.96299375 2112819.28622042 37.780438749009704 -122.500973171264 (37.7804387490097, -122.500973171264)
130514 117789 2 18 3921 Balboa St 1 1 1 1     4 Width 3ft   5983401.92135 2111008.87073 37.7754662872697 -122.500932791041 (37.7754662872697, -122.500932791041)
138008 56715 1 16 3550 Moraga St 1 1 1 1     2     5983275.5384 2103598.154 37.75511115010929 -122.50082181985901 (37.7551111501093, -122.500821819859)
46105 117727 2 16 432 40th Ave 2 1 1 1     1 Width 4ft   5983474.89929 2112887.7743599997 37.780629494505796 -122.50081932484501 (37.7806294945058, -122.500819324845)
67414 117728 2 16 432 40th Ave 1 1 1 1     2 Width 4ft   5983476.79722 2112873.2862 37.780589825682895 -122.50081168738001 (37.7805898256829, -122.50081168738)
43768 81737 1 18 591 40th Ave 1 1 1 1   12/07/2007 12:00:00 AM 4 3x3 Permit Number 49969 5983468.0529 2111801.95258 37.7776477425111 -122.500762690576 (37.7776477425111, -122.500762690576)
76643 184445 2 35 2143 42nd Ave 1 1 1 1     2 Width 0ft   5983233.2456 2100550.728 37.746741282577894 -122.500742738194 (37.7467412825779, -122.500742738194)
25201 183343 2 35 1220 41st Ave 1 1 1 1     2 Width 0ft   5983371.791 2106830.4783 37.7639918518381 -122.500727966306 (37.7639918518381, -122.500727966306)
42925 67228 1 16 679 40th Ave 1 1 1 1 1 05/26/1992 12:00:00 AM 5   Permit Number 30687 5983489.7095099995 2111188.94144 37.775965863323 -122.500642433993 (37.775965863323, -122.500642433993)
66582 47427 1 16 743 40th Ave 1 1 1 1 1 05/14/2002 12:00:00 AM 3   Permit Number 45338 5983505.42349 2110743.75617 37.7747444359741 -122.500555150992 (37.7747444359741, -122.500555150992)
176672 50404 1 16 650 40th Ave 1 1 1 1 1 10/06/2003 12:00:00 AM 1   Permit Number 47055 5983530.01588 2111373.74494 37.776475646301606 -122.500516673446 (37.7764756463016, -122.500516673446)
24630 184291 2 35 1543 41st Ave 1 2 1 1     3 Width 0ft   5983404.3155 2104639.3384 37.7579775103532 -122.50045345703501 (37.7579775103532, -122.500453457035)
151092 72277 2 16 819 40th Ave 1 1 1 1 1 01/20/1996 12:00:00 AM 6     5983524.1138 2110218.5518 37.773303473649605 -122.500451657892 (37.7733034736496, -122.500451657892)
168858 117913 2 18 893 40th Ave 1 1 1 1     2 Width 3ft   5983541.21756 2109770.57795 37.7720744705229 -122.500359367665 (37.7720744705229, -122.500359367665)
166746 117912 2 18 889 40th Ave 1 1 1 1     2 Width 4ft   5983541.524809999 2109784.94999 37.772113950042794 -122.50035936764999 (37.7721139500428, -122.50035936765)
180951 73633 2 18 782 40th Ave 1 1 1 1 1 01/20/1996 12:00:00 AM 1     5983562.4874599995 2110479.0519 37.7740209842304 -122.500338183608 (37.7740209842304, -122.500338183608)
170495 117867 2 370 842 40th Ave 2 1 1 1     2 Width 3ft   5983574.3920599995 2110074.48435 37.7729108571993 -122.500267088216 (37.7729108571993, -122.500267088216)
177121 117868 2 370 842 40th Ave 1 1 1 1     3 Width 4ft   5983575.47317 2110057.58486 37.7728645195254 -122.500262098966 (37.7728645195254, -122.500262098966)
59594 67226 1 16 858 40th Ave 1 1 1 1 1 05/26/1992 12:00:00 AM 2   Permit Number 30685 5983581.64532 2109958.3486599997 37.7725924077801 -122.500233411273 (37.7725924077801, -122.500233411273)
51275 67225 1 16 862 40th Ave 1 1 1 1 1 05/26/1992 12:00:00 AM 3   Permit Number 30684 5983582.48092 2109929.96399 37.7725145206954 -122.50022842205 (37.7725145206954, -122.50022842205)
165978 67253 1 16 878 40th Ave 1 1 1 1 1 06/08/1992 12:00:00 AM 4   Permit Number 30717 5983587.04483 2109836.93635 37.7722593614509 -122.50020575664101 (37.7722593614509, -122.500205756641)
149853 53802 1 35 1758 41st Ave 1 1 1 1   02/09/1972 12:00:00 AM 1   Permit Number 9494 5983498.0607 2103182.1267 37.7539819174643 -122.500021533616 (37.7539819174643, -122.500021533616)
114510 84877 1 16 1951 41st Ave 2 1 1 1   04/06/2007 12:00:00 AM     Permit No. 49250 5983480.4 2101864.4 37.7503627699789 -122.499985207399 (37.7503627699789, -122.499985207399)
128529 84876 1 16 1951 41st Ave 1 1 1 1   04/06/2007 12:00:00 AM     Permit No. 49250 5983480.4 2101864.4 37.7503627699789 -122.499985207399 (37.7503627699789, -122.499985207399)
140762 92430 1 18 1758 41st Ave 2 1 1 1 1 07/29/2009 12:00:00 AM   3x3 Permit Number 52821 5983521.6 2103180.6 37.7539791070225 -122.499940017573 (37.7539791070225, -122.499940017573)
131317 117739 2 84 475 39th Ave 1 2 1 1     4 Width 4ft   5983746.16527 2112679.78018 37.7800743257794 -122.49986552243 (37.7800743257794, -122.49986552243)
171845 54485 1 16 524 39th Ave 1 1 1 1 1 10/14/1995 12:00:00 AM 3   Permit Number 10277 5983807.43995 2112211.38308 37.778791839243205 -122.499618921418 (37.7787918392432, -122.499618921418)
158906 82734 1 18 663 39th Ave 1 1 1 1   07/10/2009 12:00:00 AM 3 3x3 Permit Number 52670 5983795.84033 2111312.2935099998 37.776322519429606 -122.499592582815 (37.7763225194296, -122.499592582815)
175620 117840 3 16 600x 39th Ave 2 11 1 2     2 Width 6ft   5983808.599090001 2111637.58628 37.777216427782896 -122.499572493795 (37.7772164277829, -122.499572493795)
61829 79376 1 18 683 39th Ave 1 1 1 1   07/10/2009 12:00:00 AM 3 3x3 Permit Number 52671 5983799.61702 2111191.23616 37.7759903525694 -122.499570569578 (37.7759903525694, -122.499570569578)
60634 117841 3 16 600x 39th Ave 1 11 1 2     2 Width 6ft   5983809.68656 2111621.06726 37.7771711351486 -122.499567510814 (37.7771711351486, -122.499567510814)
156479 94817 1 18 683 39th Ave 2 1 1 1 1 07/10/2009 12:00:00 AM 3 3x3 Permit Number 52671 5983800.6479400005 2111169.09276 37.775929613686294 -122.499565366534 (37.7759296136863, -122.499565366534)
51598 117842 3 16 620x 39th Ave 5 11 1 2     2 Width 6ft   5983810.65643 2111554.107 37.7769873385843 -122.499559205901 (37.7769873385843, -122.499559205901)
178771 184275 2 35 1535 40th Ave 1 1 1 1     2 Width 0ft   5983712.9456 2104682.7299 37.7581147632448 -122.499389306755 (37.7581147632448, -122.499389306755)
171595 184311 2 35 1563 40th Ave 1 1 1 1     2 Width 0ft   5983718.446 2104512.8306 37.757648590113604 -122.49935772939301 (37.7576485901136, -122.499357729393)
154043 117830 2 16 870 39th Ave 6 1 1 1     1 Width 3ft   5983887.3151 2110064.19539 37.77290096878129 -122.499183906851 (37.7729009687813, -122.499183906851)
33246 102378 2 16 870 39th Ave 4 1 1 3     2     5983886.84831 2110037.48525 37.7728276030319 -122.499183547509 (37.7728276030319, -122.499183547509)
69190 102377 2 16 870 39th Ave 2 1 1 3     3     5983889.8768 2109995.31333 37.7727119887219 -122.49916995510901 (37.7727119887219, -122.499169955109)
154893 49552 1 16 1606@ LAWTON 40th Ave 1 1 1 1   05/05/2003 12:00:00 AM 1   Permit Number 46442 5983773.0639 2104184.1322 37.7567492805381 -122.499144554539 (37.7567492805381, -122.499144554539)
164030 184601 2 35 1763 40th Ave 1 1 1 1     4 Width 0ft   5983763.5526 2103165.7132 37.753952428223 -122.49910220128099 (37.753952428223, -122.499102201281)
48191 31876 1 237 457 38th Ave 1 1 1 1   06/26/1995 12:00:00 AM 2   Permit Number 35315 5984053.55944 2112762.76101 37.7803202011246 -122.49880825564199 (37.7803202011246, -122.498808255642)
34641 31877 1 237 457 38th Ave 2 1 1 1   06/26/1995 12:00:00 AM 2   Permit Number 35315 5984054.95538 2112747.63581 37.780278753599895 -122.49880230879499 (37.7802787535999, -122.498802308795)
161530 67267 1 16 552 38th Ave 1 1 1 1 1 06/09/1992 12:00:00 AM 3   Permit Number 30740 5984123.38609 2112065.40916 37.7784095705965 -122.49851517128599 (37.7784095705965, -122.498515171286)
158895 92228 1 18 819 38th Ave 1 1 1 1   07/10/2009 12:00:00 AM 2 3x3 Permit Number 52552 5984148.0757 2110235.49072 37.77338659024161 -122.498294572929 (37.7733865902416, -122.498294572929)
147200 92229 1 18 831 38th Ave 1 1 1 1   07/10/2009 12:00:00 AM 2 3x3 Permit Number 52669 5984149.10381 2110157.50395 37.7731725212481 -122.498285255587 (37.7731725212481, -122.498285255587)
123530 88091 1 35 1619 39th Ave   1 1 1   06/30/2008 12:00:00 AM   3x3 Permit Number 51095 5984024.3 2104125.3 37.756602478656 -122.498271356488 (37.756602478656, -122.498271356488)
56474 183181 2 16 2401 40th Ave 1 1 1 1     4 Width 0ft   5983915.9024 2098758.6426 37.7418607608057 -122.49824988070299 (37.7418607608057, -122.498249880703)
153700 183184 2 16 2415 40th Ave 4 1 1 1     3 Width 0ft   5983915.9024 2098706.2108 37.7417167973555 -122.49824600919202 (37.7417167973555, -122.498246009192)
155036 183182 2 16 2411 40th Ave 2 1 1 1     3 Width 0ft   5983916.579 2098737.6699 37.74180321515429 -122.498245992674 (37.7418032151543, -122.498245992674)
137406 183183 2 16 2413 40th Ave 3 1 1 1     3 Width 0ft   5983917.2555 2098721.0947 37.7417577438343 -122.49824242970399 (37.7417577438343, -122.498242429704)
24823 47425 1 18 754 38th Ave 1 1 1 1 1 05/14/2002 12:00:00 AM 5   Permit Number 45336 5984176.15569 2110679.3098400002 37.7746068364777 -122.49823022658701 (37.7746068364777, -122.498230226587)
188640 184708 2 35 1619 39th Ave 1 1 1 1     1 Width 0ft   5984043.3081 2104133.2508 37.7566254238897 -122.498206207845 (37.7566254238897, -122.498206207845)
51735 88092 1 35 1619 39th Ave 2 1 1 1   06/30/2008 12:00:00 AM 2 3x3 Permit Number 51095 5984042.9711 2104115.7287 37.756577293333294 -122.49820607925 (37.7565772933333, -122.49820607925)
171549 183196 2 84 2479 40th Ave 1 1 1 1     1 Width 0ft   5983931.1246 2098292.1691 37.740580843976005 -122.49816280562901 (37.740580843976, -122.498162805629)
91592 37724 1 16 2400X 40TH AVE 1 1 1 1   06/30/1998 12:00:00 AM     Permit Number 40087 5983946.0 2098489.0 37.741122160337504 -122.498125905701 (37.7411221603375, -122.498125905701)
96765 37720 1 16 2400X 40TH AVE 2 1 1 1   06/30/1998 12:00:00 AM     Permit Number 40087 5983946.0 2098489.0 37.741122160337504 -122.498125905701 (37.7411221603375, -122.498125905701)
122602 37719 1 16 2400X 40TH AVE 3 1 1 1   06/30/1998 12:00:00 AM     Permit Number 40087 5983946.0 2098489.0 37.741122160337504 -122.498125905701 (37.7411221603375, -122.498125905701)
124347 37718 1 16 2400X 40TH AVE 4 1 1 1   06/30/1998 12:00:00 AM     Permit Number 40087 5983946.0 2098489.0 37.741122160337504 -122.498125905701 (37.7411221603375, -122.498125905701)
136125 183176 2 35 2446 40th Ave 1 1 1 1     2 Width 0ft   5983967.9959 2098507.985 37.7411755776416 -122.498051254673 (37.7411755776416, -122.498051254673)
135632 183177 2 35 2450 40th Ave 1 1 1 1     2 Width 0ft   5983968.3342 2098473.4815 37.741080860242896 -122.498047537544 (37.7410808602429, -122.498047537544)
178235 51494 1 35 1767 39th Ave 1 1 1 1   01/12/2005 12:00:00 AM 1   Permit Number 47806 5984074.2238 2103158.268 37.7539502052222 -122.498027293704 (37.7539502052222, -122.498027293704)
157753 184578 2 35 1726 39th Ave 1 1 1 1     3 Width 0ft   5984111.7886 2103392.1174 37.7545944930516 -122.49791465490499 (37.7545944930516, -122.497914654905)
Powered by Datasette · Query took 82.955ms · Data source: data.sfgov.org