sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1400 235284 3 26 4235 19th St 3 1 1 4   03/07/1990 12:00:00 AM 11 Width 3ft   6001885.77275 2104671.54401 37.7591334867264 -122.43653915428499 (37.7591334867264, -122.436539154285)
1405 228661 3 11 4235 19th St 1 1 1 4   03/07/1990 12:00:00 AM 13 Width 3ft   6001838.07707 2104669.16217 37.7591242363206 -122.436703937943 (37.7591242363206, -122.436703937943)
1407 220312 3 5 4235 19th St 7 1 1 4   08/05/1995 12:00:00 AM 15 Width 3ft   6002007.42492 2104678.29116 37.759158924972404 -122.436118906483 (37.7591589249724, -122.436118906483)
1420 228662 3 11 4235 19th St 2 1 1 4   03/07/1990 12:00:00 AM 16 Width 3ft   6001863.4982 2104671.44362 37.7591319452903 -122.436616182999 (37.7591319452903, -122.436616182999)
1421 228663 3 11 4235 19th St 6 1 1 4   06/23/2015 07:36:00 AM 2 Width 3ft   6001958.87793 2104675.64602 37.7591489038263 -122.436286615639 (37.7591489038263, -122.436286615639)
1431 220311 3 5 4235 19th St 4 1 1 4   08/05/1995 12:00:00 AM 18 Width 3ft   6001938.02984 2104676.35813 37.7591496745354 -122.436358769151 (37.7591496745354, -122.436358769151)
1449 234076 3 26 1400 San Bruno Ave 7 1 1 4     12 Width 4ft   6011147.1312 2101589.6307 37.751193164657 -122.40429186329901 (37.751193164657, -122.404291863299)
1454 234074 3 26 1400 San Bruno Ave 4 1 1 4     11 Width 3ft   6011143.5049 2101689.8522900003 37.751468148541996 -122.40431145682301 (37.751468148542, -122.404311456823)
1461 234073 3 26 1400 San Bruno Ave 3 1 1 4     17 Width 3ft   6011143.13167 2101723.71293 37.7515611015794 -122.404315130536 (37.7515611015794, -122.404315130536)
1464 234075 3 26 1400 San Bruno Ave 6 1 1 4     14 Width 4ft   6011146.17896 2101629.85029 37.75130354562771 -122.404297986789 (37.7513035456277, -122.404297986789)
4558 142520 3 16 301 FRANCISCO ST 3 1 1 4     7 Width 0ft   6009467.3323 2121175.1455 37.8048763586912 -122.411484377145 (37.8048763586912, -122.411484377145)
4564 142521 3 26 301 FRANCISCO ST 4 1 1 4   05/04/2013 12:00:00 AM 0 Width 0ft   6009485.2617 2121177.5361 37.8048839283261 -122.41142249927401 (37.8048839283261, -122.411422499274)
4565 142525 3 59 301 FRANCISCO ST 15 1 1 4     23 Width 0ft   6009759.5801 2121214.59 37.8050010513122 -122.410475804946 (37.8050010513122, -122.410475804946)
4568 142545 3 5 301 FRANCISCO ST 7 1 1 4     20 Width 0ft   6009562.3577 2121186.5007 37.80491286675579 -122.41115633279499 (37.8049128667558, -122.411156332795)
4570 142547 3 5 301 FRANCISCO ST 9 1 1 4     20 Width 0ft   6009612.5597 2121193.6724 37.804935373675605 -122.41098310943799 (37.8049353736756, -122.410983109438)
4571 142549 3 26 301 FRANCISCO ST 11 1 1 4     9 Width 0ft   6009666.9453 2121202.0395 37.8049613971858 -122.41079549257799 (37.8049613971858, -122.410795492578)
4573 142546 3 26 301 FRANCISCO ST 8 1 1 4   03/26/2016 09:47:00 AM 23 Width 0ft   6009592.8375 2121191.8795 37.8049293448711 -122.411051233847 (37.8049293448711, -122.411051233847)
4581 142526 3 26 301 FRANCISCO ST 17 1 1 4     10 Width 0ft   6009810.3798 2121222.957 37.8050268727325 -122.410300597206 (37.8050268727325, -122.410300597206)
4583 142550 3 26 301 FRANCISCO ST 16 1 1 4   03/26/2016 09:53:00 AM 22 Width 0ft   6009784.6811 2121219.3711 37.805015586162796 -122.41038927752199 (37.8050155861628, -122.410389277522)
4590 142522 3 26 301 FRANCISCO ST 12 1 1 4     8 Width 0ft   6009689.0581 2121206.8206 37.804975764730294 -122.410719306308 (37.8049757647303, -122.410719306308)
4591 142544 3 26 301 FRANCISCO ST 6 1 1 4   03/23/2016 02:55:00 PM 26 Width 0ft   6009534.8661 2121184.7078 37.8049064021217 -122.41125134413299 (37.8049064021217, -122.411251344133)
4595 142523 3 26 301 FRANCISCO ST 13 1 1 4     7 Width 0ft   6009712.3662 2121206.8206 37.804977071531404 -122.410638645677 (37.8049770715314, -122.410638645677)
4605 142542 3 16 301 FRANCISCO ST 1 1 1 4     8 Width 0ft   6009433.8643 2121170.962 37.8048629945672 -122.411599901453 (37.8048629945672, -122.411599901453)
4611 142519 3 16 301 FRANCISCO ST 2 1 1 4     6 Width 0ft   6009452.9889 2121171.5596 37.804865708173104 -122.411533760714 (37.8048657081731, -122.411533760714)
4612 142548 3 26 301 FRANCISCO ST 10 1 1 4     7 Width 0ft   6009639.4537 2121197.2583 37.8049467277157 -122.410890292822 (37.8049467277157, -122.410890292822)
4622 142543 3 16 301 FRANCISCO ST 5 1 1 4     6 Width 0ft   6009503.7886 2121178.1337 37.8048866083098 -122.411358426924 (37.8048866083098, -122.411358426924)
4955 253734 3 15 350 Girard St 12 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
4956 253729 3 15 350 Girard St 7 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
4965 253732 3 15 350 Girard St 10 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
4968 253724 3 15 350 Girard St 2 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
4982 253733 3 15 350 Girard St 11 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
4986 253726 3 15 350 Girard St 4 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
4993 253727 3 15 350 Girard St 5 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
5004 253731 3 15 350 Girard St 1 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
5021 253725 3 15 350 Girard St 3 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
5028 253730 3 15 350 Girard St 8 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
5029 251680 3 15 350 Girard St 9 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
5037 253728 3 15 350 Girard St 6 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
10264 92961 3 17 2051 34th Ave 1 1 1 4   12/24/2009 12:00:00 AM   3x3 Permit Number 53120 5985698.5 2101265.4 37.748848003369005 -122.49227087024799 (37.748848003369, -122.492270870248)
10265 92962 3 17 2051 34th Ave 2 1 1 4   12/24/2009 12:00:00 AM   3x3 Permit Number 53120 5985698.5 2101265.4 37.748848003369005 -122.49227087024799 (37.748848003369, -122.492270870248)
10282 173941 2 36 3750 18th St 4 1 1 4       3x3   6004590.0 2105440.0 37.7613967828987 -122.42724138037701 (37.7613967828987, -122.427241380377)
13009 115969 3 41 1599x 30th Ave 6 1 1 4     2 3x3   5986813.3885 2104627.15 37.7581435700771 -122.488662699732 (37.7581435700771, -122.488662699732)
19735 96580 3 131 401x Otsego Ave 5 1 1 4   05/14/2011 12:00:00 AM   3x3   6000208.5 2091425.4 37.7226672598955 -122.441389471398 (37.7226672598955, -122.441389471398)
42328 115970 3 8 1599x 30TH AVE 7 1 1 4     0 3x3   5986686.0 2104596.0 37.7580506061519 -122.489100968136 (37.7580506061519, -122.489100968136)
42976 113471 2 59 450 CHURCH ST 28 1 1 4       6x6   6004088.0 2106523.0 37.764342039298896 -122.429054808288 (37.7643420392989, -122.429054808288)
48933 115967 3 8 1599x 30th Ave 4 1 1 4     4 3x3   5986812.8086 2104676.4366 37.758278863742106 -122.488668327875 (37.7582788637421, -122.488668327875)
50839 113034 3 12 251 06th Ave 5 1 1 4     2 3x3   5993975.1139 2113804.1265 37.7837564355183 -122.464560902617 (37.7837564355183, -122.464560902617)
63419 106952 2 17 399X SOMERSET ST 1 1 1 4       3x3   6009953.0 2092875.0 37.7271978698015 -122.40780687976499 (37.7271978698015, -122.407806879765)
68226 113035 3 120 251 06th Ave 6 1 1 4     1 3x3   5993975.80165 2113783.25834 37.7836991768592 -122.464557007516 (37.7836991768592, -122.464557007516)
73786 94516 1 49 1106X Wisconsin St 1 1 1 4   08/27/2010 12:00:00 AM 2   Permit Number 53703 6012787.7377 2102360.9473599996 37.753402573178896 -122.39867255379299 (37.7534025731789, -122.398672553793)
77944 95496 2 2 600X 32nd Ave 2 1 1 4     5 3x3   5986002.12653 2111683.71465 37.7774715436696 -122.491987885766 (37.7774715436696, -122.491987885766)
78003 107872 3 15 830X Harrison St 5 1 1 4       3x3   6012494.965419999 2112152.38808 37.7802713603069 -122.400372718325 (37.7802713603069, -122.400372718325)
78104 92958 1 17 300 Seneca Ave 3 1 1 4   12/23/2009 12:00:00 AM 20 3x3 Permit Number 53118 5999177.1 2091098.3 37.721710307674606 -122.444931280306 (37.7217103076746, -122.444931280306)
78764 111862 3 82 201x LOBOS ST 4 1 1 4       3x3   5994528.0 2088713.0 37.714894412350205 -122.460829096166 (37.7148944123502, -122.460829096166)
79453 107874 3 15 830X Harrison St 7 1 1 4       3x3   6012494.965419999 2112152.38808 37.7802713603069 -122.400372718325 (37.7802713603069, -122.400372718325)
79513 95519 2 51 600X 32nd Ave 1 1 1 4     5 3x3   5985993.74648 2111883.3180400003 37.7780191077803 -122.49203157445 (37.7780191077803, -122.49203157445)
79769 113436 3 55 198x HIGHLAND AVE 3 1 1 4       4x4   6006173.0 2096415.0 37.73670559026029 -122.421125584355 (37.7367055902603, -122.421125584355)
80997 113469 2 59 450 CHURCH ST 26 1 1 4       6x6   6004088.0 2106523.0 37.764342039298896 -122.429054808288 (37.7643420392989, -122.429054808288)
81219 117257 3 15 1570 31ST AVE 5 1 1 4           5986686.8 2104596.0 37.7580506528461 -122.489098201432 (37.7580506528461, -122.489098201432)
82834 107870 3 15 830X Harrison St 3 1 1 4       3x3   6012494.965419999 2112152.38808 37.7802713603069 -122.400372718325 (37.7802713603069, -122.400372718325)
85224 112022 3 25 2101x 22nd Ave 2 1 1 4       5x5   6011761.0 2103726.0 37.757093449930004 -122.402319220858 (37.75709344993, -122.402319220858)
85887 117255 3 53 1570 31ST AVE 3 1 1 4           5986686.8 2104596.0 37.7580506528461 -122.489098201432 (37.7580506528461, -122.489098201432)
86964 113437 3 55 198x HIGHLAND AVE 4 1 1 4       4x4   6006173.0 2096415.0 37.73670559026029 -122.421125584355 (37.7367055902603, -122.421125584355)
87131 113474 2 59 450 CHURCH ST 31 1 1 4       6x6   6004088.0 2106523.0 37.764342039298896 -122.429054808288 (37.7643420392989, -122.429054808288)
87723 43903 1 35 1050 York St 2 1 1 4   04/26/2002 12:00:00 AM 6 3x3 Permit Number 43505 6009958.09497236 2103085.10649041 37.755232893914794 -122.408509176777 (37.7552328939148, -122.408509176777)
87843 95499 2 60 600X 32nd Ave 21 1 1 4     18 3x3   5985977.73249 2112402.27637 37.7794430828921 -122.49212519236 (37.7794430828921, -122.49212519236)
88558 112026 3 25 2101x 22nd Ave 6 1 1 4       5x5   6011761.0 2103726.0 37.757093449930004 -122.402319220858 (37.75709344993, -122.402319220858)
88644 111861 3 82 201x LOBOS ST 3 1 1 4       3x3   5994528.0 2088713.0 37.714894412350205 -122.460829096166 (37.7148944123502, -122.460829096166)
89462 113039 3 17 242X 07TH AVE 4 1 1 4       3x3   5993686.0 2113852.0 37.783871212200204 -122.46556459896001 (37.7838712122002, -122.46556459896)
89475 112027 3 25 2101x 22nd Ave 7 1 1 4       5x5   6011761.0 2103726.0 37.757093449930004 -122.402319220858 (37.75709344993, -122.402319220858)
89483 113468 2 59 450 CHURCH ST 4 1 1 4   06/21/2016 02:14:00 PM 3 6x7   6004088.0 2106523.0 37.764342039298896 -122.429054808288 (37.7643420392989, -122.429054808288)
89526 107869 3 15 830X Harrison St 2 1 1 4       3x3   6012494.965419999 2112152.38808 37.7802713603069 -122.400372718325 (37.7802713603069, -122.400372718325)
89609 79386 1 11 2355 Folsom St 16 1 1 4   10/30/2009 12:00:00 AM     Permit Number 53016 6008491.21757684 2104497.38565881 37.7590284322587 -122.4136819767 (37.7590284322587, -122.4136819767)
89660 113434 3 55 198x HIGHLAND AVE 1 1 1 4     12 4x4   6006173.0 2096415.0 37.73670559026029 -122.421125584355 (37.7367055902603, -122.421125584355)
90481 113037 3 17 242X 07TH AVE 2 1 1 4       3x3   5993686.0 2113852.0 37.783871212200204 -122.46556459896001 (37.7838712122002, -122.46556459896)
91198 107871 3 15 830X Harrison St 4 1 1 4       3x3   6012494.965419999 2112152.38808 37.7802713603069 -122.400372718325 (37.7802713603069, -122.400372718325)
91382 95488 2 51 600X 32nd Ave 10 1 1 4     6 3x3   5986007.7101 2111508.12486 37.776989750535 -122.491955639862 (37.776989750535, -122.491955639862)
91915 113040 3 17 242X 07TH AVE 5 1 1 4       3x3   5993686.0 2113852.0 37.783871212200204 -122.46556459896001 (37.7838712122002, -122.46556459896)
92018 110190 3 55 625 Holly Park Cir 6 1 1 4           6006167.62160945 2096413.49051844 37.736701142359294 -122.421144072665 (37.7367011423593, -122.421144072665)
92153 107873 3 15 830X Harrison St 6 1 1 4       3x3   6012494.965419999 2112152.38808 37.7802713603069 -122.400372718325 (37.7802713603069, -122.400372718325)
92566 113466 2 59 450 CHURCH ST 2 1 1 4       6x6   6004088.0 2106523.0 37.764342039298896 -122.429054808288 (37.7643420392989, -122.429054808288)
93011 113435 3 55 198x HIGHLAND AVE 2 1 1 4       4x4   6006173.0 2096415.0 37.73670559026029 -122.421125584355 (37.7367055902603, -122.421125584355)
93185 95510 2 37 500X 32nd Ave 10 1 1 4   02/19/2015 02:35:00 PM 3 3x3   5985969.9 2112493.2 37.7796922752829 -122.49215898451901 (37.7796922752829, -122.492158984519)
93377 95497 2 51 600X 32nd Ave 1 1 1 4     6 3x3   5985999.2312900005 2111660.71954 37.777408236422296 -122.491996207782 (37.7774082364223, -122.491996207782)
93918 95500 2 11 600X 32nd Ave 20 1 1 4     8 3x3   5985980.30461 2112381.8602 37.779387176289504 -122.49211479078899 (37.7793871762895, -122.492114790789)
94030 95491 2 51 600X 32nd Ave 7 1 1 4     3 3x3   5986009.30138 2111441.61533 37.776807227327396 -122.491945237383 (37.7768072273274, -122.491945237383)
94173 117256 3 53 1570 31ST AVE 4 1 1 4           5986686.8 2104596.0 37.7580506528461 -122.489098201432 (37.7580506528461, -122.489098201432)
95487 115964 3 8 1599x 30TH AVE 1 1 1 4     8 3x3   5986686.0 2104596.0 37.7580506061519 -122.489100968136 (37.7580506061519, -122.489100968136)
96050 113472 2 59 450 CHURCH ST 29 1 1 4       6x6   6004088.0 2106523.0 37.764342039298896 -122.429054808288 (37.7643420392989, -122.429054808288)
96578 95515 2 51 600X 32nd Ave 5 1 1 4     6 3x3   5985992.57608 2111969.58011 37.7782558903759 -122.492041976045 (37.7782558903759, -122.492041976045)
96802 95494 2 51 600X 32nd Ave 4 1 1 4     3 3x3   5986000.13497 2111717.2940599998 37.7775636267397 -122.491997248036 (37.7775636267397, -122.491997248036)
97255 110187 3 55 625 Holly Park Cir 3 1 1 4           6006167.62160945 2096413.49051844 37.736701142359294 -122.421144072665 (37.7367011423593, -122.421144072665)
97797 91788 3 127 830X Harrison St 8 1 1 4   03/07/2007 12:00:00 AM 3 3x3   6012494.965717 2112152.388469 37.7802713613915 -122.400372717325 (37.7802713613915, -122.400372717325)
98898 117252 6 143 2500x 34TH AVE 2 17 1 4       3x3   5985829.0 2097874.0 37.73954376030179 -122.491570003273 (37.7395437603018, -122.491570003273)
100429 113036 3 17 242X 07TH AVE 1 1 1 4       3x3   5993686.0 2113852.0 37.783871212200204 -122.46556459896001 (37.7838712122002, -122.46556459896)
101527 95518 2 51 600X 32nd Ave 2 1 1 4     5 3x3   5985992.056890001 2111902.81718 37.778072548088495 -122.49203885528601 (37.7780725480885, -122.492038855286)
101631 94927 1 21 325 Sanchez St   1 1 4   12/07/2010 12:00:00 AM   3x3 Permit Number 53976 6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
102729 95507 2 11 600X 32nd Ave 13 1 1 4     10 3x3   5985983.58763 2112182.96811 37.778841267423296 -122.492088785464 (37.7788412674233, -122.492088785464)
103944 112029 3 48 2101x 22nd Ave 9 1 1 4   07/23/2015 12:00:00 AM 3 9x9   6011761.0 2103726.0 37.757093449930004 -122.402319220858 (37.75709344993, -122.402319220858)
104395 111863 3 82 201x LOBOS ST 5 1 1 4       3x3   5994528.0 2088713.0 37.714894412350205 -122.460829096166 (37.7148944123502, -122.460829096166)
104647 107423 3 120 251 06th Ave 1 1 1 4     2 3x3   5993968.46376 2113916.3836 37.7840642796834 -122.46459206338498 (37.7840642796834, -122.464592063385)
Powered by Datasette · Query took 11.92ms · Data source: data.sfgov.org