sf-trees

Data source: data.sfgov.org

Custom SQL query returning 59 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
791 191798 3 114 2 Newhall St 3 4 1 2   11/12/2014 12:00:00 AM 6 Width 3ft Permit Number 774049 6018546.987380001 2097184.73725 37.7395089360924 -122.378396294176 (37.7395089360924, -122.378396294176)
827 191800 3 114 2 Newhall St 5 4 1 2   11/12/2014 12:00:00 AM 19 Width 4ft Permit Number 774049 6018580.4534 2097158.49779 37.739438732322704 -122.37827876085301 (37.7394387323227, -122.378278760853)
874 19854 3 114 100 STAIRWAY29 4 1 1 2     3 100ST            
3248 23887 3 114 1750X Geary Blvd 4 1 1 2     18 3X3   6003189.5886 2113919.6305 37.784600462473 -122.432690563632 (37.784600462473, -122.432690563632)
5019 23410 3 114 1748X Van Ness Ave 6 11 1 2     30 9   6006148.01248 2116523.4539799998 37.7919172512266 -122.422640495371 (37.7919172512266, -122.422640495371)
5869 19852 3 114 100 STAIRWAY29 2 1 1 2     12 100ST            
6066 23885 3 114 1750X Geary Blvd 2 1 1 2     3 3X3   6003231.6817 2113926.6459999997 37.7846221123784 -122.432545437068 (37.7846221123784, -122.432545437068)
6122 23406 3 114 1748X Van Ness Ave 2 11 1 2     24 9   6006168.03383 2116381.79756 37.7915294275986 -122.42256115088499 (37.7915294275986, -122.422561150885)
6402 23443 3 114 2100X Van Ness Ave 2 11 1 2     24 9   6005986.240069999 2117685.53144 37.7950988961632 -122.423282873032 (37.7950988961632, -122.423282873032)
8382 23409 3 114 1748X Van Ness Ave 5 11 1 2     30 9   6006150.92127 2116485.89798 37.7918142959375 -122.42262776096202 (37.7918142959375, -122.422627760962)
10541 1813 3 114 2082 Bay Shore Blvd 1 1 1 2   12/13/1991 12:00:00 AM 12 3X3   6012099.01215 2087998.4540799998 37.713927769919 -122.400045768207 (37.713927769919, -122.400045768207)
17115 19795 3 114 100 STAIRWAY20 1 1 1 2     12 15ST            
18557 12099 3 114 1281X La Salle Ave 3 1 1 2   12/04/1992 12:00:00 AM 24 3X3   6017033.141005999 2094557.4754692002 37.732211440602605 -122.383447721977 (37.7322114406026, -122.383447721977)
19280 1843 3 114 2200 Bay Shore Blvd 4 11 1 2     12 6   6011383.0146015 2087402.1416029998 37.712250468957 -122.40247863283399 (37.712250468957, -122.402478632834)
23139 19365 3 114 500X Lake St 2 1 1 2     24 3X3   5993863.684719999 2114886.5972700003 37.7867221812625 -122.46502504683998 (37.7867221812625, -122.46502504684)
23322 23886 3 114 1750X Geary Blvd 3 1 1 2     19 3X3   6003218.9262 2113924.0949 37.784614384352004 -122.432589384494 (37.784614384352, -122.432589384494)
72210 16475 3 114 9X Newhall St 9 1 1 2     18 3X3   6018697.204870099 2097076.1109207 37.73921894851821 -122.37786936428301 (37.7392189485182, -122.377869364283)
77351 12094 3 114 1261X La Salle Ave 2 1 1 2     12 3X3   6017141.6501925 2094501.7221284 37.732064349457005 -122.383068698568 (37.732064349457, -122.383068698568)
83001 8296 3 114 18 Garlington Ct 1 1 1 2     18 3X3   6016769.107068701 2094699.6972286 37.7325873571063 -122.384370457364 (37.7325873571063, -122.384370457364)
84644 8439 3 114 1720X Geary Blvd 3 1 1 2     18 3x3   6003193.61701 2113921.75435 37.7846065224894 -122.43267677846599 (37.7846065224894, -122.432676778466)
84693 1816 3 114 2100 Bay Shore Blvd 1 11 1 2     12 6   6012027.2003656 2087907.9406618 37.7136752340099 -122.400287624748 (37.7136752340099, -122.400287624748)
85616 1762 3 114 2000X Bay Shore Blvd 3 1 1 2   12/27/1991 12:00:00 AM 12 3x3   6012375.8565272 2088505.2474916999 37.7153347551878 -122.399124435859 (37.7153347551878, -122.399124435859)
86584 16461 3 114 2X Newhall St 4 1 1 2     18 3X3   6018746.801501201 2097101.6577332001 37.739291827880294 -122.37769965200899 (37.7392918278803, -122.377699652009)
86585 1862 3 114 2510 Bay Shore Blvd 6 11 1 2     12 6   6010780.8257042 2086709.3373148 37.710314531205896 -122.404511250175 (37.7103145312059, -122.404511250175)
87252 1861 3 114 2510 Bay Shore Blvd 5 11 1 2     6 6   6010780.8257042 2086709.3373148 37.710314531205896 -122.404511250175 (37.7103145312059, -122.404511250175)
87452 12105 3 114 1281X La Salle Ave 9 1 1 2   12/04/1992 12:00:00 AM 18 3X3   6017033.141005999 2094557.4754692002 37.732211440602605 -122.383447721977 (37.7322114406026, -122.383447721977)
87914 1852 3 114 2401 Bay Shore Blvd 15 1 1 2   11/23/1992 12:00:00 AM 12 3X3   6011063.3259362 2087019.7277799998 37.7111825850692 -122.403556689346 (37.7111825850692, -122.403556689346)
89329 16462 3 114 2X Newhall St 5 1 1 2     6 3X3   6018746.801501201 2097101.6577332001 37.739291827880294 -122.37769965200899 (37.7392918278803, -122.377699652009)
93163 12090 3 114 1261X La Salle Ave 5 1 1 2     12 3X3   6017141.6501925 2094501.7221284 37.732064349457005 -122.383068698568 (37.732064349457, -122.383068698568)
94981 15024 3 114 845 Mendell St 1 1 1 2   12/30/1992 12:00:00 AM 17 3X3   6015971.14204 2096622.00458 37.7378214697096 -122.387263283018 (37.7378214697096, -122.387263283018)
97437 1826 3 114 2138 Bay Shore Blvd 1 1 1 2   11/02/1991 12:00:00 AM 12 3x3   6011843.4146873 2087682.3291292998 37.713045499820794 -122.400907017094 (37.7130454998208, -122.400907017094)
97946 16466 3 114 2X Newhall St 9 1 1 2     18 3X3   6018746.801501201 2097101.6577332001 37.739291827880294 -122.37769965200899 (37.7392918278803, -122.377699652009)
98048 24204 3 114 80X Whitney Young Cir 4 1 1 2   11/20/1991 12:00:00 AM 30 3x3   6016946.00997 2094945.60902 37.73327236236629 -122.383775970862 (37.7332723623663, -122.383775970862)
102500 3793 3 114 75 Cashmere St 1 1 1 2     18 3X3   6017167.2819088 2095817.4840533 37.7356785868328 -122.38307162670601 (37.7356785868328, -122.383071626706)
106392 8302 3 114 25 Garlington Ct 1 1 1 2     12 3X3   6016780.483136799 2094683.2530579 37.732542833716 -122.38432998229099 (37.732542833716, -122.384329982291)
111168 22108 3 114 3550 03rd St 8 1 1 2     12 3X3   6015960.65745 2099048.08294 37.744482404383895 -122.387468734005 (37.7444824043839, -122.387468734005)
111671 109907 3 114 1415 Howard St 2 1 1 2   07/17/2015 10:12:00 AM 9 4x4   6008287.6 2109783.3 37.773530888410896 -122.414760273118 (37.7735308884109, -122.414760273118)
113390 117085 3 114 1415 Howard St 4 1 1 2     18 4x4   6008287.6 2109783.3 37.773530888410896 -122.414760273118 (37.7735308884109, -122.414760273118)
113964 8305 3 114 29 Garlington Ct 2 1 1 2     18 3X3   6016787.0658034 2094691.4882738998 37.732565809963106 -122.384307797551 (37.7325658099631, -122.384307797551)
115131 16473 3 114 9X Newhall St 7 1 1 2     12 3X3   6018697.204870099 2097076.1109207 37.73921894851821 -122.37786936428301 (37.7392189485182, -122.377869364283)
117123 12636 3 114 901 Lake St 4 1 1 2     100 3X3   5992666.273990001 2114790.8903900003 37.7863902797856 -122.46916079788099 (37.7863902797856, -122.469160797881)
119232 6465 3 114 1200X Evans Ave 5 1 1 2   03/10/2016 02:16:00 PM 3 3X3   6017709.266009999 2097062.52601 37.739127157777205 -122.38128430413201 (37.7391271577772, -122.381284304132)
122570 22179 3 114 3955X 03rd St 1 1 1 2   02/03/1992 12:00:00 AM 12 3X3   6015698.56805 2097858.21385 37.741200749075105 -122.38829196576599 (37.7412007490751, -122.388291965766)
123955 8438 3 114 1720X Geary Blvd 2 1 1 2     24 3x3   6003216.05015 2113926.93493 37.7846220192585 -122.432599537586 (37.7846220192585, -122.432599537586)
125100 1818 3 114 2100 Bay Shore Blvd 3 11 1 2   12/30/1991 12:00:00 AM 3 6   6012027.2003656 2087907.9406618 37.7136752340099 -122.400287624748 (37.7136752340099, -122.400287624748)
125721 12093 3 114 1261X La Salle Ave 1 1 1 2     12 3X3   6017141.6501925 2094501.7221284 37.732064349457005 -122.383068698568 (37.732064349457, -122.383068698568)
127141 1761 3 114 2000X Bay Shore Blvd 2 1 1 2   01/18/1991 12:00:00 AM 18 3x3   6012375.8565272 2088505.2474916999 37.7153347551878 -122.399124435859 (37.7153347551878, -122.399124435859)
127345 28139 3 114 525X EUGENIA AVE 1 1 1 2     30 4x4   6007058.0 2097880.0 37.740778006453795 -122.418169580752 (37.7407780064538, -122.418169580752)
127449 10848 3 114 1139X Hudson Ave 56 1 1 2     18 3X4   6018102.76401 2094614.84701 37.7324280296634 -122.379753739799 (37.7324280296634, -122.379753739799)
129279 21837 3 114 201 Lake St 3 1 1 2   03/11/2015 12:00:00 AM 3 3X3   5994816.5533 2114874.05731 37.786742647269705 -122.46172746258699 (37.7867426472697, -122.461727462587)
139000 1768 3 114 2000X Bay Shore Blvd 7 1 1 2   01/28/1991 12:00:00 AM 24 3X3   6012375.8565272 2088505.2474916999 37.7153347551878 -122.399124435859 (37.7153347551878, -122.399124435859)
139020 1856 3 114 2500 Bay Shore Blvd 3 11 1 2     12 6   6010837.5147418 2086759.4488696998 37.7104552954566 -122.404318844881 (37.7104552954566, -122.404318844881)
139770 8304 3 114 29 Garlington Ct 1 1 1 2     18 3X3   6016787.0658034 2094691.4882738998 37.732565809963106 -122.384307797551 (37.7325658099631, -122.384307797551)
140227 16472 3 114 9X Newhall St 6 1 1 2     18 3X3   6018697.204870099 2097076.1109207 37.73921894851821 -122.37786936428301 (37.7392189485182, -122.377869364283)
140266 12081 3 114 1261X La Salle Ave 10 1 1 2   12/16/1992 12:00:00 AM 18 3X3   6017141.6501925 2094501.7221284 37.732064349457005 -122.383068698568 (37.732064349457, -122.383068698568)
143575 1765 3 114 2000X Bay Shore Blvd 5 1 1 2   01/18/1991 12:00:00 AM 36 3X3   6012375.8565272 2088505.2474916999 37.7153347551878 -122.399124435859 (37.7153347551878, -122.399124435859)
143986 12622 3 114 814 Lake St 1 1 1 2     140 3X3   5992940.7068300005 2114858.78084 37.786592541866796 -122.468216278652 (37.7865925418668, -122.468216278652)
146005 191802 3 114 180x Bay Shore Blvd 1 3 1 2     27     6011170.05761 2099578.4094700003 37.745672070114395 -122.404071054532 (37.7456720701144, -122.404071054532)
157873 191803 3 114 180x Bay Shore Blvd 3 3 1 2     36     6011162.1503800005 2099563.42906 37.7456304953456 -122.404097342621 (37.7456304953456, -122.404097342621)
Powered by Datasette · Query took 3.23ms · Data source: data.sfgov.org