sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
127059 105484 1 15 833 Jamestown Ave 18 1 1 1   01/30/2014 12:00:00 AM   3x3 Permit Number 772170 6014874.7 2088927.9 37.7166342161119 -122.390516776389 (37.7166342161119, -122.390516776389)
139072 105478 1 15 833 Jamestown Ave 12 1 1 1   01/30/2014 12:00:00 AM   3x3 Permit Number 772170 6014874.7 2088927.9 37.7166342161119 -122.390516776389 (37.7166342161119, -122.390516776389)
184470 195879 2 15 881 Jamestown Ave 30 1 1 1     2 Width 3ft   6014843.010980001 2088936.2451799999 37.7166553723252 -122.390626893234 (37.7166553723252, -122.390626893234)
52775 195878 2 15 881 Jamestown Ave 29 1 1 1     2 Width 3ft   6014756.78586 2089043.98437 37.716946419018 -122.39093245857799 (37.716946419018, -122.390932458578)
31864 195877 2 15 881 Jamestown Ave 28 1 1 1     2 Width 3ft   6014742.2889 2089063.14086 37.7169982145749 -122.390983906081 (37.7169982145749, -122.390983906081)
41659 178541 2 15 383 Wilde Ave 2 1 1 1     17 Width 3ft   6010763.14033 2089167.46002 37.7170630503084 -122.404745314969 (37.7170630503084, -122.404745314969)
40118 195876 2 15 881 Jamestown Ave 27 1 1 1     2 Width 3ft   6014722.93243 2089087.3362900002 37.7170635763921 -122.391052502784 (37.7170635763921, -122.391052502784)
131661 195875 2 15 881 Jamestown Ave 26 1 1 1     2 Width 3ft   6014702.6108099995 2089108.4073299998 37.717120305646 -122.39112421743401 (37.717120305646, -122.391124217434)
33749 71323 2 15 542 Munich St 1 1 1 1 1 08/26/1995 12:00:00 AM 14 3x3   6003533.1657 2089339.03151 37.7171273913949 -122.429748095618 (37.7171273913949, -122.429748095618)
156168 195874 2 15 881 Jamestown Ave 25 1 1 1     2 Width 3ft   6014684.01117 2089125.40125 37.717165935444996 -122.39118969524799 (37.717165935445, -122.391189695248)
65912 178540 2 15 386 Wilde Ave 1 1 1 1     13 Width 3ft   6010727.65839 2089224.49237 37.7172176662453 -122.40487197278 (37.7172176662453, -122.40487197278)
179725 195873 2 15 881 Jamestown Ave 24 1 1 1     2 Width 3ft   6014659.9545 2089146.17672 37.7172216457504 -122.391274299863 (37.7172216457504, -122.391274299863)
158118 195872 2 15 881 Jamestown Ave 23 1 1 1     2 Width 3ft   6014642.0829300005 2089159.24693 37.7172565421344 -122.391336987109 (37.7172565421344, -122.391336987109)
105029 105483 1 15 833 Jamestown Ave 17 1 1 1   01/30/2014 12:00:00 AM   3x3 Permit Number 772170 6014353.8 2089169.6 37.7172689657855 -122.39233417718201 (37.7172689657855, -122.392334177182)
109271 105488 1 15 833 Jamestown Ave 22 1 1 1       3x3 Permit Number 772170 6014353.8 2089169.6 37.7172689657855 -122.39233417718201 (37.7172689657855, -122.392334177182)
122296 105473 1 15 833 Jamestown Ave 8 1 1 1   01/30/2014 12:00:00 AM   3x3 Permit Number 772170 6014353.8 2089169.6 37.7172689657855 -122.39233417718201 (37.7172689657855, -122.392334177182)
152026 195871 2 15 881 Jamestown Ave 22 1 1 1     2 Width 3ft   6014626.21861 2089171.94185 37.7172905194175 -122.391392710014 (37.7172905194175, -122.391392710014)
30709 195870 2 15 881 Jamestown Ave 21 1 1 1     2 Width 3ft   6014596.38264 2089191.2735400002 37.7173419444641 -122.39149719055 (37.7173419444641, -122.39149719055)
139222 111092 2 15 801 GONZALEZ DR   2 1 1   06/04/2015 12:00:00 AM 2   Permit Number 775593 5988333.0 2089769.0 37.717435525652704 -122.48231868452 (37.7174355256527, -122.48231868452)
111271 111095 2 15 841x GONZALEZ DR 1 2 1 1   06/04/2015 12:00:00 AM 3   Permit Number 775593 5988358.0 2089771.0 37.7174424713469 -122.48223241855301 (37.7174424713469, -122.482232418553)
146394 178605 2 15 0 Gonzalez Dr 6 2 1 1     2     5988508.8443599995 2089780.72483 37.71747794624039 -122.48171173733299 (37.7174779462404, -122.481711737333)
148106 178604 2 15 0 Gonzalez Dr 1 2 1 1     2     5988124.07873 2089803.3530000001 37.7175176953569 -122.48304333649999 (37.7175176953569, -122.4830433365)
38675 54001 1 15 19 Rutland St 1 1 1 1   04/05/1972 12:00:00 AM 12   Permit Number 9719 6010666.13404 2089379.87515 37.717640876409604 -122.405095569414 (37.7176408764096, -122.405095569414)
184602 54000 1 15 15 Rutland St 1 1 1 1   04/05/1972 12:00:00 AM 19   Permit Number 9718 6010673.62628 2089402.8086700002 37.71770426600779 -122.40507128591001 (37.7177042660078, -122.40507128591)
163021 195869 2 15 881 Jamestown Ave 10 1 1 1     1 Width 4ft   6014230.67939 2089421.95835 37.7179550545644 -122.392777395286 (37.7179550545644, -122.392777395286)
162229 195868 2 15 881 Jamestown Ave 9 1 1 1     2 Width 4ft   6014208.61168 2089436.1660799999 37.7179928404794 -122.392854667732 (37.7179928404794, -122.392854667732)
135722 195867 2 15 881 Jamestown Ave 8 1 1 1     2 Width 4ft   6014190.80973 2089445.9953 37.7180188407662 -122.392916889096 (37.7180188407662, -122.392916889096)
10510 1087 3 15 2174 Alemany Blvd 1 1 1 2     35 3X3   5999920.01803 2089753.43888 37.718059997362396 -122.442266720544 (37.7180599973624, -122.442266720544)
24035 178607 2 15 0 Gonzalez Dr 1 2 1 1     2     5990327.66617 2089955.55198 37.7180635775375 -122.47543773036101 (37.7180635775375, -122.475437730361)
172969 195866 2 15 881 Jamestown Ave 7 1 1 1     2 Width 4ft   6014162.83531 2089463.80547 37.7180661900688 -122.393014830689 (37.7180661900688, -122.393014830689)
177432 195865 2 15 881 Jamestown Ave 6 1 1 1     2 Width 4ft   6014137.22595 2089483.7511200001 37.718119534279296 -122.39310474668801 (37.7181195342793, -122.393104746688)
181760 195864 2 15 881 Jamestown Ave 5 1 1 1     2 Width 4ft   6014122.19061 2089493.97182 37.7181467630545 -122.393157432565 (37.7181467630545, -122.393157432565)
180107 195863 2 15 881 Jamestown Ave 4 1 1 1     2 Width 4ft   6014108.38675 2089504.7741900003 37.7181756573713 -122.393205902428 (37.7181756573713, -122.393205902428)
10459 1079 1 15 2133 Alemany Blvd 1 1 1 1     40 3X3   6000101.3096199995 2089802.83807 37.718205967213 -122.441643618974 (37.718205967213, -122.441643618974)
44439 178537 2 15 641 Vienna St 1 1 1 1     10 Width 2ft   6002884.33955 2089748.61217 37.7182152473007 -122.43202000794201 (37.7182152473007, -122.432020007942)
38092 195862 2 15 881 Jamestown Ave 3 1 1 1     2 Width 4ft   6014091.2192400005 2089520.09734 37.718216777965296 -122.393266315296 (37.7182167779653, -122.393266315296)
12800 1083 1 15 2150 Alemany Blvd 1 1 1 1     35 3x3   5999998.5130900005 2089822.2609599999 37.718253440618504 -122.44200033506901 (37.7182534406185, -122.442000335069)
182581 195861 2 15 881 Jamestown Ave 2 1 1 1     2 Width 4ft   6014062.44151 2089544.1547299998 37.718281235976 -122.39336747103901 (37.718281235976, -122.393367471039)
10491 1075 1 15 2119 Alemany Blvd 1 1 1 1     14     6000135.00359 2089836.3366200002 37.7182998663217 -122.44152955615299 (37.7182998663217, -122.441529556153)
165879 195860 2 15 881 Jamestown Ave 1 1 1 1     2 Width 4ft   6014042.40973 2089558.52381 37.7183195776565 -122.393437718003 (37.7183195776565, -122.393437718003)
13175 1076 1 15 2124 Alemany Blvd 1 1 1 1     25 3x3   6000057.48494 2089881.91046 37.7184205850222 -122.441800773687 (37.7184205850222, -122.441800773687)
50055 178539 2 15 490 Harkness Ave 1 1 1 1     8 Width 3ft   6010199.09845 2089695.50908 37.7184814223664 -122.406732139473 (37.7184814223664, -122.406732139473)
10562 1073 1 15 2118 Alemany Blvd 1 1 1 1     25 3x3   6000085.1139 2089908.73955 37.7184958258874 -122.44170719653201 (37.7184958258874, -122.441707196532)
92233 111089 2 15 10x HIGUERA AVE 1 11 1 1   08/30/2016 12:00:00 AM 3 3x3 Permit Number 777485 5988057.0 2090190.0 37.7185754269376 -122.483303520979 (37.7185754269376, -122.483303520979)
21948 413 3 15 3854 19th Ave 1 1 1 2   05/25/1994 12:00:00 AM 8 2X3   5990824.06176 2090161.99601 37.7186591841634 -122.47373697479401 (37.7186591841634, -122.473736974794)
116026 1065 3 15 2071X Alemany Blvd 1 1 1 2     30 3X3   6000361.32249 2090050.85473 37.7189017758401 -122.440762648624 (37.7189017758401, -122.440762648624)
172380 178532 2 15 2077 Alemany Blvd 1 1 1 1     20 Width 3ft   6000360.4691699995 2090050.99345 37.7189021081373 -122.440765608152 (37.7189021081373, -122.440765608152)
109545 111090 2 15 28x HIGUERA AVE 1 3 1 1   06/04/2015 12:00:00 AM 3   Permit Number 777485 5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
12553 1045 3 15 2003X Alemany Blvd 1 1 1 2     25 3X3   6000641.86431 2090326.5948 37.719674868584704 -122.43981268741999 (37.7196748685847, -122.43981268742)
125203 114389 6 15 345x ARBALLO DR 1 7 1 1     8     5988176.0 2090635.0 37.7198042094326 -122.48292478788 (37.7198042094326, -122.48292478788)
172686 200224 2 15 3098 Ingalls St 4 1 1 1     12 Width 0ft   6014365.7136 2090125.8044 37.719895176072605 -122.392359839359 (37.7198951760726, -122.392359839359)
30367 200223 2 15 3098 Ingalls St 3 1 1 1     12 Width 0ft   6014379.7223 2090145.2948 37.7199494707461 -122.392312778235 (37.7199494707461, -122.392312778235)
70067 178621 2 15 2000 Alemany Blvd 2 1 1 1     20 Width 3ft   6000618.20182 2090428.8464900001 37.7199542816414 -122.439901807531 (37.7199542816414, -122.439901807531)
142119 1043 3 15 2000 Alemany Blvd 1 1 1 2     30 3X5   6000617.15273 2090448.0855 37.7200070478885 -122.43990681257799 (37.7200070478885, -122.439906812578)
147050 200222 2 15 3098 Ingalls St 2 1 1 1     14 Width 0ft   6014396.7763 2090173.3121 37.7200273476772 -122.39225578645299 (37.7200273476772, -122.392255786453)
152316 200221 2 15 3098 Ingalls St 1 1 1 1     14 Width 0ft   6014405.3033 2090186.1027 37.7200629416077 -122.392227205373 (37.7200629416077, -122.392227205373)
13520 29553 3 15 3000X Ingalls St 4 1 1 2     18 3X3   6014413.8304 2090200.1114 37.7201018801983 -122.39219870906601 (37.7201018801983, -122.392198709066)
14160 29552 3 15 3000X Ingalls St 3 1 1 2     18 3X3   6014430.2753 2090217.7745 37.720151292667495 -122.392143098776 (37.7201512926675, -122.392143098776)
103182 29554 3 15 3030 Ingalls St 1 1 1 2     18 3X3   6014438.8118347 2090233.7051406002 37.7201955090298 -122.39211470411699 (37.7201955090298, -122.392114704117)
114413 29555 3 15 3030 Ingalls St 2 1 1 2     18 3X3   6014438.8118347 2090233.7051406002 37.7201955090298 -122.39211470411699 (37.7201955090298, -122.392114704117)
120833 29558 3 15 3030 Ingalls St 3 1 1 2     18 3X3   6014438.8118347 2090233.7051406002 37.7201955090298 -122.39211470411699 (37.7201955090298, -122.392114704117)
15135 29551 3 15 3000X Ingalls St 2 1 1 2     18 3X3   6014443.0659 2090235.4376 37.720200502216294 -122.39210012020901 (37.7202005022163, -122.392100120209)
149833 200203 2 15 3000 Ingalls St 1 1 1 1     16 Width 0ft   6014458.9018 2090257.3642 37.720261587554205 -122.392046912905 (37.7202615875542, -122.392046912905)
102131 29550 3 15 3000X Ingalls St 1 1 1 2     18 3X3   6014485.674235599 2090296.5698245 37.7203707248314 -122.391957108854 (37.7203707248314, -122.391957108854)
87417 94437 1 15 3711@533 Gonzalez 19th Ave 1 1 1 1   08/04/2010 12:00:00 AM 32   Permit Number 53664 5990297.3 2090806.0 37.7203969366505 -122.475604756889 (37.7203969366505, -122.475604756889)
80722 1026 1 15 1955X Alemany Blvd 1 1 1 1     35 3X3   6000855.2579 2090665.6856099998 37.7206180798117 -122.439099353738 (37.7206180798117, -122.439099353738)
10666 108381 1 15 204 Russia Ave 1 1 1 1 1 12/19/2014 12:00:00 AM 3 3x3 Permit Number 773815 6001936.176109999 2090655.40431 37.7206512958141 -122.435362229505 (37.7206512958141, -122.435362229505)
84041 114392 6 15 104x TAPIA DR 1 8 1 1     10     5988688.0 2090939.0 37.72066869526729 -122.481177253578 (37.7206686952673, -122.481177253578)
166073 211987 2 15 951 Junipero Serra Blvd 15 1 1 1     13 Width 3ft   5991283.96245 2090948.88613 37.7208464163014 -122.472204628055 (37.7208464163014, -122.472204628055)
70308 178533 2 15 1971 Alemany Blvd 3 1 1 1     28 Width 2ft   6000911.61584 2090780.99233 37.7209378926573 -122.438912801483 (37.7209378926573, -122.438912801483)
62159 178536 2 15 2134 San Jose Ave 12 9 1 1     15 Width 3ft   5998755.19209 2090916.21978 37.7211862692206 -122.44637660699499 (37.7211862692206, -122.446376606995)
34933 178535 2 15 2134 San Jose Ave 11 1 1 1     12 Width 4ft   5998787.03696 2090942.1024 37.7212591556762 -122.446268389794 (37.7212591556762, -122.446268389794)
59357 178534 2 15 2134 San Jose Ave 10 1 1 1     10 Width 4ft   5998794.56221 2090951.4910799998 37.721285364599204 -122.446243052271 (37.7212853645992, -122.446243052271)
41219 211988 2 15 951 Junipero Serra Blvd 21 1 1 1     15 Width 3ft   5991299.375030001 2091144.62881 37.7213847693696 -122.47216561275299 (37.7213847693696, -122.472165612753)
44181 11759 3 15 901X Junipero Serra Blvd 9 1 1 2     18 3x5   5991288.1161497 2091224.4470027 37.7216032788517 -122.472210346501 (37.7216032788517, -122.472210346501)
126341 11756 3 15 901X Junipero Serra Blvd 3 1 1 2     18 3X5   5991288.1161497 2091224.4470027 37.7216032788517 -122.472210346501 (37.7216032788517, -122.472210346501)
96525 96881 1 15 2200X San Jose Ave 6 5 1 1           5998886.2 2091075.7 37.7216316467069 -122.445935216513 (37.7216316467069, -122.445935216513)
102506 96880 1 15 2200X San Jose Ave 5 1 1 1   05/09/2011 12:00:00 AM       5998886.2 2091075.7 37.7216316467069 -122.445935216513 (37.7216316467069, -122.445935216513)
81509 106258 2 15 205 GRANADA AVE 2 2 1 1     16 4x4   5995602.7 2091290.9 37.722034494846895 -122.457300887551 (37.7220344948469, -122.457300887551)
119445 88345 1 15 347 Vienna St   1 1 1   07/10/2008 12:00:00 AM   3x3 Permit Number 51330 6003917.0 2091407.0 37.7228273068445 -122.428568687279 (37.7228273068445, -122.428568687279)
157618 178636 2 15 371 Naples St 1 1 1 1     12 Width 2ft   6003616.32219 2091419.98171 37.7228459311798 -122.42960899208401 (37.7228459311798, -122.429608992084)
168194 178635 2 15 347 Vienna St 1 1 1 1     9 Width 3ft   6003933.72351 2091415.2294700001 37.72285084955671 -122.42851146394199 (37.7228508495567, -122.428511463942)
158417 201998 2 15 200 Paul Ave 1 1 1 1     5 Width 3ft   6012853.60662 2091263.9911900002 37.7229363247465 -122.397666492108 (37.7229363247465, -122.397666492108)
32371 201999 2 15 200 Paul Ave 2 4 1 1     4 Width 3ft   6012837.45496 2091269.25359 37.7229498748073 -122.397722694373 (37.7229498748073, -122.397722694373)
24869 202000 2 15 200 Paul Ave 3 1 1 1     3 Width 3ft   6012773.51606 2091290.0244900002 37.7230033467173 -122.397945175839 (37.7230033467173, -122.397945175839)
73247 202001 2 15 200 Paul Ave 4 1 1 1     4 Width 3ft   6012749.41946 2091296.9164 37.7230209284511 -122.398028956696 (37.7230209284511, -122.398028956696)
156709 202002 2 15 200 Paul Ave 5 1 1 1     4 Width 3ft   6012728.61586 2091304.05924 37.7230393825427 -122.398101371875 (37.7230393825427, -122.398101371875)
51340 202003 2 15 200 Paul Ave 6 1 1 1     4 Width 3ft   6012704.69846 2091311.94783 37.7230597108282 -122.398184603239 (37.7230597108282, -122.398184603239)
24634 202004 2 15 200 Paul Ave 7 1 1 1     4 Width 3ft   6012681.9088 2091316.93525 37.7230721358484 -122.398263732799 (37.7230721358484, -122.398263732799)
47821 211986 2 15 100 De Montfort Ave 5 1 1 1     2 Width 3ft   5995007.309090001 2091908.61395 37.7236963750783 -122.459403705022 (37.7236963750783, -122.459403705022)
154247 211985 2 15 100 De Montfort Ave 1 1 1 1     2 Width 3ft   5995023.16483 2091909.8583400003 37.7237007035157 -122.45934898488701 (37.7237007035157, -122.459348984887)
109280 11700 1 15 799X Junipero Serra Blvd 32 1 1 13     18 3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
52778 178631 2 15 661 Brussels St 1 1 1 1     20 Width 3ft   6010974.0949800005 2091668.9858400002 37.723943515975 -122.404192100612 (37.723943515975, -122.404192100612)
175474 211984 2 15 1215 Capitol Ave 6 1 1 1     2 Width 3ft   5995042.93975 2091999.53532 37.7239480719295 -122.459287117821 (37.7239480719295, -122.459287117821)
163248 178632 2 15 649 Brussels St 1 1 1 1     15 Width 3ft   6010957.7594800005 2091720.88481 37.724085107030604 -122.404252221185 (37.7240851070306, -122.404252221185)
77145 178633 2 15 649 Brussels St 2 1 1 1     14 Width 3ft   6010954.35314 2091735.9375200002 37.72412624831829 -122.404265055401 (37.7241262483183, -122.404265055401)
10868 1003 3 15 1750 Alemany Blvd 1 1 1 2     30 3X3   6001350.47669 2091970.9547 37.7242302198351 -122.43748096390101 (37.7242302198351, -122.437480963901)
78239 1002 3 15 1731 Alemany Blvd 2 1 1 2     27 3X3   6001471.07065 2092002.59485 37.724323951976 -122.437066353202 (37.724323951976, -122.437066353202)
73781 178634 2 15 619 Brussels St 1 1 1 1     14 Width 3ft   6010918.94664 2091849.32517 37.724435608804896 -122.404395428331 (37.7244356088049, -122.404395428331)
110324 999 1 15 1725 Alemany Blvd 1 1 1 1     24 3X3   6001467.99656 2092045.3572200001 37.724441193017796 -122.43708004004499 (37.7244411930178, -122.437080040045)
10127 173869 2 15 619 Brussels St 1 1 1 1       3x3   6010937.0 2091855.0 37.72445219957 -122.40433341923901 (37.72445219957, -122.404333419239)
Powered by Datasette · Query took 54.712ms · Data source: data.sfgov.org