sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
22927 251157 2 47 625 Brotherhood Way 10 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22928 251155 2 47 625 Brotherhood Way 8 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22929 251156 2 47 625 Brotherhood Way 9 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22930 251151 2 47 625 Brotherhood Way 4 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22931 251158 2 47 625 Brotherhood Way 11 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22932 251153 2 47 625 Brotherhood Way 6 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22933 251149 2 47 625 Brotherhood Way 2 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22934 251159 2 47 625 Brotherhood Way 12 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
10618 2271 3 47 700X Brotherhood Way 5 11 1 2     25 14M   5990752.82343 2088228.49759 37.71334614597279 -122.47384223413499 (37.7133461459728, -122.473842234135)
11028 2270 3 47 700X Brotherhood Way 4 11 1 2     6 14M   5990735.60667 2088236.9442599998 37.7133683412468 -122.473902356505 (37.7133683412468, -122.473902356505)
10938 2269 3 47 700X Brotherhood Way 3 11 1 2     6 14M   5990714.96133 2088247.7727 37.7133968776506 -122.473974502829 (37.7133968776506, -122.473974502829)
149883 2256 3 47 700X Brotherhood Way 2 11 1 2     15     5990689.72825 2088261.00769 37.7134317560555 -122.47406268136801 (37.7134317560555, -122.474062681368)
186596 2255 3 47 700X Brotherhood Way 1 11 1 2     17     5990660.02895 2088282.4204099998 37.713488829713796 -122.474166893001 (37.7134888297138, -122.474166893001)
160062 176162 2 47 301 Naglee Ave 1 7 1 1     30 Width 10ft   5997669.17463 2088536.7397200002 37.7145906808916 -122.449959233558 (37.7145906808916, -122.449959233558)
49614 176138 2 47 10 Lake Merced Blvd 1 4 1 1     16 Width 0ft   5987453.76086 2088540.35852 37.714010802520704 -122.485267666593 (37.7140108025207, -122.485267666593)
46715 176139 2 47 10 Lake Merced Blvd 2 4 1 1     10 Width 0ft   5987453.25598 2088569.38174 37.714090463565796 -122.485271539962 (37.7140904635658, -122.485271539962)
88589 114269 2 47 800x BROTHERHOOD WAY 10 7 1 1     38     5990271.0 2088582.0 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779)
91685 114268 2 47 800x BROTHERHOOD WAY 9 7 1 1     30     5990271.0 2088582.0 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779)
114769 114267 2 47 800x BROTHERHOOD WAY 8 7 1 1     50     5990271.0 2088582.0 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779)
124433 114265 2 47 800x BROTHERHOOD WAY 6 8 1 1     26     5990271.0 2088582.0 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779)
80604 109658 2 47 800X BROTHERHOOD WAY 29 11 1 2           5990271.4 2088582.7 37.7142908027957 -122.47553203031799 (37.7142908027957, -122.475532030318)
94555 109656 2 47 800X BROTHERHOOD WAY 8 11 1 2   02/27/2015 10:16:00 AM 3     5990271.4 2088582.7 37.7142908027957 -122.47553203031799 (37.7142908027957, -122.475532030318)
94669 109654 2 47 800X BROTHERHOOD WAY 25 11 1 2           5990271.4 2088582.7 37.7142908027957 -122.47553203031799 (37.7142908027957, -122.475532030318)
94728 109655 2 47 800X BROTHERHOOD WAY 26 11 1 2           5990271.4 2088582.7 37.7142908027957 -122.47553203031799 (37.7142908027957, -122.475532030318)
97780 109648 2 47 800X BROTHERHOOD WAY 1 11 1 2           5990271.4 2088582.7 37.7142908027957 -122.47553203031799 (37.7142908027957, -122.475532030318)
102772 109653 2 47 800X BROTHERHOOD WAY 6 11 1 2           5990271.4 2088582.7 37.7142908027957 -122.47553203031799 (37.7142908027957, -122.475532030318)
109323 109649 2 47 800X BROTHERHOOD WAY 2 11 1 2           5990271.4 2088582.7 37.7142908027957 -122.47553203031799 (37.7142908027957, -122.475532030318)
109927 109657 2 47 800X BROTHERHOOD WAY 28 11 1 2           5990271.4 2088582.7 37.7142908027957 -122.47553203031799 (37.7142908027957, -122.475532030318)
110258 109650 2 47 800X BROTHERHOOD WAY 21 11 1 2           5990271.4 2088582.7 37.7142908027957 -122.47553203031799 (37.7142908027957, -122.475532030318)
111096 109659 2 47 800X BROTHERHOOD WAY 30 11 1 2           5990271.4 2088582.7 37.7142908027957 -122.47553203031799 (37.7142908027957, -122.475532030318)
142047 109652 2 47 800X BROTHERHOOD WAY 23 11 1 2           5990271.4 2088582.7 37.7142908027957 -122.47553203031799 (37.7142908027957, -122.475532030318)
145583 109651 2 47 800X BROTHERHOOD WAY 22 11 1 2           5990271.4 2088582.7 37.7142908027957 -122.47553203031799 (37.7142908027957, -122.475532030318)
72073 176140 2 47 10 Lake Merced Blvd 3 4 1 1     15 Width 0ft   5987455.898580001 2088588.29538 37.7141425496068 -122.48526379321501 (37.7141425496068, -122.485263793215)
41942 176158 2 47 825 Brotherhood Way 2 7 1 1     27 Width 0ft   5989484.91598 2088634.67131 37.7143878792713 -122.47825419477199 (37.7143878792713, -122.478254194772)
11963 2289 3 47 800X Brotherhood Way 4 11 1 2   08/30/2016 12:00:00 AM 3 14M Permit Number 777532 5989454.26944 2088678.0808599999 37.7145052920719 -122.478363292437 (37.7145052920719, -122.478363292437)
10549 2290 3 47 800X Brotherhood Way 5 11 1 2   08/30/2016 12:00:00 AM 3 14M Permit Number 777532 5989540.89128 2088682.16282 37.714521528411495 -122.478064194121 (37.7145215284115, -122.478064194121)
12203 2287 3 47 800X Brotherhood Way 2 11 1 2   08/30/2016 12:00:00 AM 3 14M Permit Number 777532 5989126.18342 2088688.6181299998 37.7145151729252 -122.47949804711 (37.7145151729252, -122.47949804711)
168599 176157 2 47 999 Brotherhood Way 2 7 1 1     25 Width 0ft   5988327.5004199995 2088688.82584 37.714469318273004 -122.482258598878 (37.714469318273, -122.482258598878)
172439 206843 2 47 2 Lobos St 4 2 1 1     12     5996870.71882 2088697.5203900002 37.7149864275584 -122.45273060322901 (37.7149864275584, -122.452730603229)
40889 176156 2 47 900 Brotherhood Way 10 4 1 1     31 Width 0ft   5988097.715469999 2088752.8411700001 37.714631719660396 -122.48305750709801 (37.7146317196604, -122.483057507098)
28511 176155 2 47 900 Brotherhood Way 9 4 1 1     25 Width 0ft   5988052.58895 2088755.4955 37.71463638173179 -122.48321367528798 (37.7146363817318, -122.483213675288)
140124 176152 2 47 900 Brotherhood Way 2 4 1 1     20 Width 0ft   5987747.4162 2088772.85017 37.7146662689143 -122.48426973566099 (37.7146662689143, -122.484269735661)
36171 176154 2 47 900 Brotherhood Way 4 4 1 1     20 Width 0ft   5987807.09848 2088773.10862 37.714670453457295 -122.48406347077801 (37.7146704534573, -122.484063470778)
166286 176153 2 47 900 Brotherhood Way 3 4 1 1     18 Width 0ft   5987778.038380001 2088773.7248200001 37.7146704534554 -122.484163958296 (37.7146704534554, -122.484163958296)
10134 173877 2 47 2651 San Jose Ave 1 18 1 1       3x3   5997397.0 2088796.0 37.7152869722449 -122.450918658158 (37.7152869722449, -122.450918658158)
122547 176099 2 47 491 La Grande Ave 1 23 1 1     43     6004400.9540099995 2089156.27858 37.716674693347 -122.42673555649999 (37.716674693347, -122.4267355565)
162701 176100 2 47 491 La Grande Ave 2 23 1 1     19     6004405.409030001 2089175.08917 37.7167265950249 -122.42672149649799 (37.7167265950249, -122.426721496498)
45680 176101 2 47 491 La Grande Ave 3 23 1 1     26     6004411.36222 2089192.97967 37.716776055035794 -122.426702192554 (37.7167760550358, -122.426702192554)
115560 109453 1 47 951 GILMAN AVE 1 7 1 3   03/24/2015 12:00:00 AM 3   Permit Number 774986 6015934.0 2089205.0 37.717453787650705 -122.38687458595501 (37.7174537876507, -122.386874585955)
180895 176096 2 47 184 Mount Vernon Ave 5 17 1 1     15     5998966.43073 2089373.6298 37.7169627336137 -122.445535550248 (37.7169627336137, -122.445535550248)
65775 176097 2 47 184 Mount Vernon Ave 6 17 1 1     12     5998962.663240001 2089377.08137 37.716971995749795 -122.445548820645 (37.7169719957498, -122.445548820645)
35448 176098 2 47 184 Mount Vernon Ave 8 17 1 1     6     5998949.65718 2089392.42013 37.717013369950706 -122.44559487852699 (37.7170133699507, -122.445594878527)
174101 176141 2 47 10 Lake Merced Blvd 1 4 1 1     48 Width 0ft   5987562.65817 2089512.7313599999 37.7166870365437 -122.484962576069 (37.7166870365437, -122.484962576069)
9640 114128 2 47 1200X JUNIPERO SERRA BLVD 21 9 1 1     18     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9648 114133 2 47 1200X JUNIPERO SERRA BLVD 26 9 1 1     28     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9649 114125 2 47 1200X JUNIPERO SERRA BLVD 18 9 1 1     18     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9650 114131 2 47 1200X JUNIPERO SERRA BLVD 24 9 1 1     30     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9662 114130 2 47 1200X JUNIPERO SERRA BLVD 23 9 1 1     24     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9664 114135 2 47 1200X JUNIPERO SERRA BLVD 30 9 1 1     28     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9666 114127 2 47 1200X JUNIPERO SERRA BLVD 20 9 1 1     36     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9669 114126 2 47 1200X JUNIPERO SERRA BLVD 19 9 1 1     36     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9671 114132 2 47 1200X JUNIPERO SERRA BLVD 25 9 1 1     36     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9673 114129 2 47 1200X JUNIPERO SERRA BLVD 22 9 1 1     36     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9678 114134 2 47 1200X JUNIPERO SERRA BLVD 28 9 1 1     36     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
166548 206841 2 47 246 Thrift St 2 9 1 1     17     5994549.17298 2089660.24802 37.7174965486989 -122.46082452325199 (37.7174965486989, -122.460824523252)
38808 176142 2 47 10 Lake Merced Blvd 2 4 1 1     38 Width 0ft   5987571.34971 2089706.0579 37.7172183686082 -122.48494670935 (37.7172183686082, -122.48494670935)
16807 106757 2 47 999 Key Ave 1 2 1 1   06/02/2014 12:00:00 AM 36     6013321.202330001 2089752.82506 37.718812992515105 -122.395944254446 (37.7188129925151, -122.395944254446)
40050 176160 2 47 0 Gonzalez Dr 2 2 1 1     2     5990378.89561 2089837.21304 37.7177416175535 -122.47525201947701 (37.7177416175535, -122.475252019477)
184827 176107 3 47 700x Mansell St 46 11 1 2     61 Width 0ft   6008982.60232 2089910.3513099998 37.7190031946297 -122.41095224595699 (37.7190031946297, -122.410952245957)
40380 176106 3 47 700x Mansell St 38 11 1 2     12 Width 0ft   6009144.0469 2089931.11882 37.719069269612206 -122.410395658243 (37.7190692696122, -122.410395658243)
61768 206845 2 47 401 Victoria St 1 9 1 1     30 Width 5ft   5993220.45249 2089938.0951 37.7181829076919 -122.465437434707 (37.7181829076919, -122.465437434707)
44967 176143 2 47 10 Lake Merced Blvd 4 4 1 1     60 Width 0ft   5987585.53383 2089941.9294099999 37.7178668382624 -122.48491497676201 (37.7178668382624, -122.484914976762)
148568 176105 3 47 700x Mansell St 29 11 1 2     105 Width 0ft   6009225.48687 2089982.90412 37.7192160263732 -122.41011780460899 (37.7192160263732, -122.410117804609)
58718 22877 3 47 951X Mansell St 4 11 1 2     6 3X100   6009106.075933999 2090003.4402518997 37.7192657205166 -122.410532013931 (37.7192657205166, -122.410532013931)
113957 22878 3 47 951X Mansell St 5 11 1 2   06/10/1992 12:00:00 AM 3 3X100   6009106.075933999 2090003.4402518997 37.7192657205166 -122.410532013931 (37.7192657205166, -122.410532013931)
136128 218153 2 47 22 Ashton Ave 1 17 1 1     20     5994153.71185 2090014.1877400002 37.7184456203604 -122.46221709555 (37.7184456203604, -122.46221709555)
176077 176104 3 47 700x Mansell St 19 11 1 2     26 Width 0ft   6009423.2681599995 2090026.7428 37.7193474820922 -122.409437239052 (37.7193474820922, -122.409437239052)
161920 218151 2 47 35 Ashton Ave 4 13 1 1     19     5994130.74614 2090030.24083 37.7184883759248 -122.46229764153799 (37.7184883759248, -122.462297641538)
61253 218150 2 47 35 Ashton Ave 3 13 1 1     8     5994126.47455 2090031.2465099997 37.7184908913149 -122.46231247944999 (37.7184908913149, -122.46231247945)
30020 218148 2 47 35 Ashton Ave 1 13 1 1     25     5994122.86099 2090034.3755400002 37.7184992748049 -122.462325196761 (37.7184992748049, -122.462325196761)
176884 218149 2 47 35 Ashton Ave 2 13 1 1     12     5994121.0220800005 2090034.4141 37.7184992747921 -122.462331555861 (37.7184992747921, -122.462331555861)
175601 176161 2 47 0 Gonzalez Dr 4 2 1 1     2     5990361.86615 2090050.7376 37.718326916127204 -122.475326462647 (37.7183269161272, -122.475326462647)
107501 115835 2 47 900X LAKE MERCED BLVD 3 11 1 1   08/30/2016 12:00:00 AM 3 10x100   5987646.0 2090104.0 37.7183153647657 -122.484717856844 (37.7183153647657, -122.484717856844)
111885 115833 2 47 900X LAKE MERCED BLVD 1 11 1 1   08/30/2016 12:00:00 AM 3 10x100   5987646.0 2090104.0 37.7183153647657 -122.484717856844 (37.7183153647657, -122.484717856844)
117533 105764 2 47 1X GONZALEZ DR 1 7 1 1           5990111.8 2090190.8 37.718696994740704 -122.476201051717 (37.7186969947407, -122.476201051717)
71082 176144 2 47 10 Lake Merced Blvd 5 4 1 1     39 Width 0ft   5987593.26623 2090234.31177 37.7186700965335 -122.484909687836 (37.7186700965335, -122.484909687836)
35639 176145 2 47 10 Lake Merced Blvd 6 4 1 1     41 Width 0ft   5987592.83524 2090286.1257900002 37.7188123395933 -122.484914976763 (37.7188123395933, -122.484914976763)
186983 206877 2 47 900 Junipero Serra Blvd 112 4 1 1     24 Width 0ft   5991127.9538900005 2090310.3975099998 37.7190842541173 -122.472697367507 (37.7190842541173, -122.472697367507)
171157 176146 2 47 10 Lake Merced Blvd 7 4 1 1     40 Width 0ft   5987590.810219999 2090334.9259400002 37.7189462144818 -122.48492555458999 (37.7189462144818, -122.48492555459)
43611 206876 2 47 900 Junipero Serra Blvd 107 4 1 1     15 Width 0ft   5991129.63237 2090361.82623 37.7192255618863 -122.472695313452 (37.7192255618863, -122.472695313452)
52900 206875 2 47 900 Junipero Serra Blvd 102 4 1 1     26 Width 0ft   5991134.69079 2090432.70427 37.71942046834911 -122.472682993629 (37.7194204683491, -122.472682993629)
136102 176147 2 47 10 Lake Merced Blvd 8 4 1 1     40 Width 0ft   5987595.02111 2090461.3006400003 37.7192934526127 -122.484920265678 (37.7192934526127, -122.484920265678)
45769 176148 2 47 10 Lake Merced Blvd 9 4 1 1     34 Width 0ft   5987583.49684 2090495.06547 37.7193854910228 -122.484962576086 (37.7193854910228, -122.484962576086)
149666 176149 2 47 10 Lake Merced Blvd 10 4 1 1     58 Width 0ft   5987588.89275 2090533.04242 37.7194900803794 -122.48494670933998 (37.7194900803794, -122.48494670934)
143237 104888 6 47 146 Gonzalez Dr 1 7 1 1           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286)
147594 206851 2 47 3800 19th Ave 1 9 1 1     26 Width 6ft   5990535.05203 2090576.85379 37.7197815380709 -122.47476621738899 (37.7197815380709, -122.474766217389)
43604 206874 2 47 900 Junipero Serra Blvd 70 4 1 1     20 Width 0ft   5991143.093090001 2090605.8468900002 37.7198963617096 -122.472666567502 (37.7198963617096, -122.472666567502)
67783 176150 2 47 10 Lake Merced Blvd 11 4 1 1     36 Width 0ft   5987592.48981 2090630.47985 37.7197578283347 -122.484941420412 (37.7197578283347, -122.484941420412)
98711 105649 6 47 3 Gonzalez Dr 1 7 1 1           5990274.6 2090665.2 37.7200090188364 -122.475672946469 (37.7200090188364, -122.475672946469)
183376 176159 2 47 0 Serrano Dr 1 2 1 1     2     5989661.71527 2090692.2421799998 37.720047719404 -122.477793431626 (37.720047719404, -122.477793431626)
20392 106278 3 47 200X VIDAL DR 2 11 1 2     60     5987624.0 2090693.0 37.719931328083206 -122.48483708629801 (37.7199313280832, -122.484837086298)
Powered by Datasette · Query took 19.329ms · Data source: data.sfgov.org